Asp.net

D365 Blog URL

2024-02-01T11:00:00.000+05:30

https://dynamicscrm-jainik.blogspot.com/

Find sum of two number without using any arithmetic operator.

2021-06-21T12:12:00.003+05:30

class Program
    {
        static void Main(string[] args)
        {
 
            int a = 10, b = 5;
            if (b > 0)
            {
                while (b > 0)
                {
                    a++;
                    b--;
                }
            }
            // when 'b' is negative
            if (b < 0)
            { 
                while (b < 0)
                {
                    a--;
                    b++;
                }
            }
            Console.Write("Sum is: " + a);
        }
 
    }

How to implement request and response oAuth2 with RestSharp?

2021-03-17T12:57:00.000+05:30


I am calling an API with access token that expire in 1799 seconds (approximately 30 minutes). What is the right to handle this? or how to use the refresh token to get a new access token, once the access token expires, without having to submit credentials again.
This is what I have so far:
public void api()
{
    string token = "";

    try {
        callApi(token);
    }
    catch(Exception)
    {
        var client = new RestClient("www.example.com/api/token");
        var request = new RestRequest(Method.POST);
        request.AddHeader("content-type", "application/x-www-form-urlencoded");
        request.AddHeader("cache-control", "no-cache");
        request.AddParameter("application/x-www-form-urlencoded", "grant_type=password&username=us&password=pas", ParameterType.RequestBody);
        IRestResponse response = client.Execute(request);

        dynamic resp = JObject.Parse(response.Content);
        token = resp.access_token;

        callApi(token);
    }
}

public void callApi(string token)
{
    var client = new RestClient("www.example.com/api/data");
    var request = new RestRequest(Method.GET);
    request.AddHeader("cache-control", "no-cache");
    request.AddHeader("authorization", "Bearer " + token);
    request.AddHeader("accept", "application/json; charset=utf-8");
    IRestResponse response = client.Execute(request);
}

}

List array removed and append the last in c#

2019-09-15T23:36:00.003+05:30

class Program

{

static void Main(string[] args)

{

List<string> list1 = new List<string>();

// list elements

list1.Add("A");

list1.Add("I");

list1.Add("G");

list1.Add("B");

list1.Add("E");

list1.Add("H");

list1.Add("F");

list1.Add("C");

list1.Add("D");

list1.Add("a");

list1.Add("--Geen--");

Console.WriteLine("Original List");

List<string> list2 = new List<string>();

for (int i = 0; i < list1.Count; i++)

{

if (list1[i].Contains("--Geen--"))

{

list2.Add(list1[i]);

list1.RemoveAt(i);

}

list1.Add(list2[0]);

Console.WriteLine("\nSorted List");

// use of List.Sort() method

list1.Sort(StringComparer.Ordinal);

}

open popup after form post

2018-12-20T22:03:00.001+05:30

https://www.blogger.com/blogger.g?blogID=7765714418392902530#editor/src=sidebar

https://stackoverflow.com/questions/48311149/asp-net-mvc-post-not-working-on-popup-window

string format

2018-12-11T23:35:00.000+05:30

https://docs.microsoft.com/en-us/dotnet/standard/base-types/composite-formatting

https://stackoverflow.com/questions/16101100/string-format-input-string-was-not-in-correct-format-for-string-with-curly-brack

Nested Case Condition

2018-10-12T14:55:00.001+05:30

CASE

WHEN(P.PropertyId=115)

THEN

ELSE

CASE

WHEN R.CompanyId is not null and R.CompanyId>0

THEN CASE WHEN R.IsSeleComContForConfi = 1

THEN

AA.Pincode

ELSE

A.Pincode

END

ELSE

A1.Pincode

END

END AS [Pincode]

Adding html text to Word using Interop

2018-09-20T12:18:00.001+05:30

using Microsoft.Office.Interop.Word;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WindowsFormsApplication1

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

CreateDocument();

}

public static string SaveToTemporaryFile(string html)

{

string htmlTempFilePath = Path.Combine(Path.GetTempPath(), string.Format("{0}.html", Path.GetRandomFileName()));

using (StreamWriter writer = File.CreateText(htmlTempFilePath))

{

html = string.Format("<html>{0}</html>", html);

writer.WriteLine(html);

}

return htmlTempFilePath;

}

private void CreateDocument()

{

string html = @"<div>Test Jainik</div>

<div>Test 3</div>";

try

{

//Create an instance for word app

Microsoft.Office.Interop.Word.Application winword = new Microsoft.Office.Interop.Word.Application();

//Set animation status for word application

winword.ShowAnimation = false;

//Set status for word application is to be visible or not.

winword.Visible = false;

//Create a missing variable for missing value

object missing = System.Reflection.Missing.Value;

//Create a new document

Microsoft.Office.Interop.Word.Document document = winword.Documents.Add(ref missing, ref missing, ref missing, ref missing);

//Add header into the document

foreach (Microsoft.Office.Interop.Word.Section section in document.Sections)

{

Microsoft.Office.Interop.Word.Range headerRange = section.Headers[Microsoft.Office.Interop.Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;

headerRange.Fields.Add(headerRange, Microsoft.Office.Interop.Word.WdFieldType.wdFieldPage);

headerRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;

headerRange.Font.ColorIndex = Microsoft.Office.Interop.Word.WdColorIndex.wdBlue;

headerRange.Font.Size = 10;

headerRange.Text = "Header text goes here";

}

//Add the footers into the document

foreach (Microsoft.Office.Interop.Word.Section wordSection in document.Sections)

{

Microsoft.Office.Interop.Word.Range footerRange = wordSection.Footers[Microsoft.Office.Interop.Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;

footerRange.Font.ColorIndex = Microsoft.Office.Interop.Word.WdColorIndex.wdDarkRed;

footerRange.Font.Size =10;

footerRange.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;

footerRange.Text = "Footer text goes here";

}

//adding text to document

document.Content.SetRange(0, 0);

// System.Text.RegularExpressions.Regex rx = new System.Text.RegularExpressions.Regex("<[^>]*>");

// replace all matches with empty strin

// string str = rx.Replace("<html><body><h1>Jainik</h1></body></html>", "");

// document.Content.Text = pasteHTML("") + Environment.NewLine;

// document.Content.HTMLDivisions.Add("<html><body><h1>Jainik</h1></body></html>");

//Add paragraph with Heading 1 style

Microsoft.Office.Interop.Word.Paragraph para1 = document.Content.Paragraphs.Add(ref missing);

//object styleHeading1 = "Heading 1";

//// para1.Range.set_Style(ref styleHeading1);

//// document.ActiveWindow.View.Type = Microsoft.Office.Interop.Word.WdViewType.wdPrintView;

//para1.Range.Text = "<html><body><h1>Jainik</h1></body></html>";

//para1.Format.Application.ActiveWindow.View.Type = Microsoft.Office.Interop.Word.WdViewType.wdPrintView;

//para1.Range.InsertParagraphAfter();

ContentControl contentControl = document.ContentControls.Add(WdContentControlType.wdContentControlRichText, ref missing);

contentControl.Title = "This is html content";

contentControl.Range.InsertFile(SaveToTemporaryFile(html), ref missing, ref missing, ref missing, ref missing);

//Add paragraph with Heading 2 style

Microsoft.Office.Interop.Word.Paragraph para2 = document.Content.Paragraphs.Add(ref missing);

object styleHeading2 = "Heading 2";

para2.Range.set_Style(ref styleHeading2);

para2.Range.Text = "Para 2 text";

para2.Range.InsertParagraphAfter();

//Create a 5X5 table and insert some dummy record

Table firstTable = document.Tables.Add(para1.Range, 5, 5, ref missing, ref missing);

firstTable.Borders.Enable = 1;

foreach (Row row in firstTable.Rows)

{

foreach (Cell cell in row.Cells)

{

//Header row

if (cell.RowIndex == 1)

{

cell.Range.Text = "Column " + cell.ColumnIndex.ToString();

cell.Range.Font.Bold = 1;

//other format properties goes here

cell.Range.Font.Name = "verdana";

cell.Range.Font.Size = 10;

//cell.Range.Font.ColorIndex = WdColorIndex.wdGray25;

cell.Shading.BackgroundPatternColor = WdColor.wdColorGray25;

//Center alignment for the Header cells

cell.VerticalAlignment = WdCellVerticalAlignment.wdCellAlignVerticalCenter;

cell.Range.ParagraphFormat.Alignment = WdParagraphAlignment.wdAlignParagraphCenter;

}

//Data row

else

{

cell.Range.Text = (cell.RowIndex - 2 + cell.ColumnIndex).ToString();

}

//Save the document

object filename = @"d:\temp1.docx";

document.Activate();

document.ActiveWindow.View.Type = Microsoft.Office.Interop.Word.WdViewType.wdPrintView;

document.SaveAs(ref filename, WdSaveFormat.wdFormatDocumentDefault);

document.Close(ref missing, ref missing, ref missing);

document = null;

winword.Quit(ref missing, ref missing, ref missing);

winword = null;

MessageBox.Show("Document created successfully !");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

2018-08-23T23:53:00.004+05:30

using System;

using System.Collections.Generic;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Net;

using System.Net.Http;

using System.Threading;

using System.Web;

using System.Web.Http;

using KlickSocialAPP.Helpers;

using KlickSocialAPP.Models;

using KlickSocialAPP.PushNotifications;

using KlickSocialAPP.Repository;

namespace KlickSocialAPP.Controllers

{

public class ValuesController : ApiController

{

// GET api/values/5

public string Get(int id)

{

return "value";

}

[HttpPost]

[ActionName("authenticateUser")]

public dynamic authenticateUser(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

Pro_UserMaster_API Result = new UserRepository().AuthentucateUser(user.klickName, user.password, user.deviceId, user.deviceType);

if (Result.mobileNumber == "-1" || Result.mobileNumber == "-2" || Result.mobileNumber == "-3")

{

//dicto = ServiceHelper.GetServiceJson(ServiceHelper.JsonType.Error, StatusConstants.Error, null, "Login Failed"); // msg as per client said

dicto.Add("status", 0);

dicto.Add("message", Result.klickName);

}

else

{

dicto.Add("userDetail", Result);

dicto.Add("status", "1");

dicto.Add("message", "success");

}

return dicto;

}

[HttpPost]

[ActionName("getUserProfile")]

public dynamic getUserProfile(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

Pro_UserMaster_API Result = new UserRepository().GetUserById(user.mobileNumber);

if (Result == null)

dicto.Add("status", 0);

else

{

dicto.Add("userDetail", Result);

dicto.Add("status", "1");

}

return dicto;

}

[HttpPost]

[ActionName("forgotPassword")]

public dynamic forgotPassword(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string Result = Convert.ToString(new UserRepository().GetUserByUserNameEmailId(user.emailId));

if (Result != "0")

{

Random rnd = new Random();

string code = rnd.Next(1000, 10000).ToString();

if (code.Length == 3)

code = code + "0";

else if (code.Length == 2)

code = code + "00";

Result = Convert.ToString(new UserRepository().UpdatePassword(Result, code));

if (!string.IsNullOrEmpty(Result))

{

//bool EmailStatus = EmailHelper.SendEmailForgotPassword(user.userName, user.emailId, code);

//if (EmailStatus == true)

// dicto.Add("code", code);

//else

// dicto.Add("Result", "Email Sending fail");

dicto.Add("mobileNumber", Result);

dicto.Add("status", "1");

dicto.Add("message", "success");

}

else

{

dicto.Add("status", "0");

dicto.Add("message", "EmailId doesn't exists");

}

return dicto;

}

[HttpPost]

[ActionName("changePassword")]

public dynamic changePassword(Pro_UserMaster_ChangePassword_API user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string Result = Convert.ToString(new UserRepository().ChangePassword(user));

if (Result == user.mobileNumber)

{

dicto.Add("status", "1");

dicto.Add("message", "success");

}

else if (Result == "2")

{

dicto.Add("status", "0");

dicto.Add("message", "old password does not match.");

}

else if (Result == "0")

{

dicto.Add("status", "0");

dicto.Add("message", "fail");

}

return dicto;

}

[HttpPost]

[ActionName("UpdateNotification")]

public dynamic UpdateNotification(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string Result = Convert.ToString(new UserRepository().UpdateNotification(user.mobileNumber, user.sendNotification));

if (Result == user.mobileNumber)

dicto.Add("status", "1");

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("updateLocation")]

public dynamic updateLocation(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string Result = Convert.ToString(new UserRepository().UpdateLatLong(user.mobileNumber, user.latitude, user.longitude));

if (Result == user.mobileNumber)

dicto.Add("status", "1");

else if (Result == "0")

{

dicto.Add("status", "0");

dicto.Add("message", "user does not exists");

}

else

{

dicto.Add("status", "0");

dicto.Add("message", "fail");

}

return dicto;

}

[HttpPost]

[ActionName("registerUser")]

public dynamic registerUser(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

Pro_UserMaster_API Result = new UserRepository().AddEditUser(user);

if (Result.mobileNumber == user.mobileNumber)

{

if (!string.IsNullOrEmpty(user.profileImage))

{

if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Uploads/ProfilePicture/")))

Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Uploads/ProfilePicture/"));

byte[] imageBytes = Convert.FromBase64String(user.profileImage);

MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);

ms.Write(imageBytes, 0, imageBytes.Length);

Image image = Image.FromStream(ms, true);

image.Save(HttpContext.Current.Server.MapPath("~/Uploads/ProfilePicture/") + "ProfilePic_" + Result.mobileNumber + ".png");

Image imgthumb = image.GetThumbnailImage(100, 100, () => false, IntPtr.Zero);

imgthumb.Save(HttpContext.Current.Server.MapPath("~/Uploads/ProfilePicture/") + "Thumb_ProfilePic_" + Result.mobileNumber + ".png");

image.Dispose();

imgthumb.Dispose();

}

if (user.mode == "Insert")

{ //-------------------Send Email with varfication code--------------

Random rnd = new Random();

string code = rnd.Next(1000, 10000).ToString();

if (code.Length == 3)

code = code + "0";

else if (code.Length == 2)

code = code + "00";

//bool EmailStatus = EmailHelper.SendEmailForVarificationCode(user.emailId, code, user.phoneNumber);

//if (EmailStatus == true)

dicto.Add("code", code);

//else

// dicto.Add("Result", "Email Sending fail");

//-------------------End-------------------------------------------

}

dicto.Add("userDetail", Result);

dicto.Add("status", "1");

dicto.Add("message", "success");

}

else if (Result.mobileNumber == "-1")

{

dicto.Add("status", "0");

dicto.Add("message", "Email already Exists");

}

else if (Result.mobileNumber == "-2")

{

dicto.Add("status", "0");

dicto.Add("message", "MobileNumber already Exists");

}

else if (Result.mobileNumber == "-3")

{

dicto.Add("status", "0");

dicto.Add("message", "KlickName already Exists");

}

else

{

dicto.Add("status", "0");

dicto.Add("message", "fail");

}

return dicto;

}

[HttpPost]

[ActionName("blockUnblockUser")]

public dynamic blockUnblockUser(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().UpdateStatus(user.mobileNumber, user.contactNumber, Convert.ToInt16(user.friendStatus), Convert.ToInt16(user.isFriend));

if (Result != null)

dicto.Add("status", "1");

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("addFriend")]

public dynamic addFriend(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_UserContact_API> Result = new UserContactRepository().AddContacts(user);

if (Result != null)

{

dicto.Add("contacts", Result);

dicto.Add("status", "1");

dicto.Add("MessageType", 5);

// PushHelper.SendPushNotificationAddFreind(user.mobileNumber);

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("getContacts")]

public dynamic getContacts(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().GetContacts(user.mobileNumber, Convert.ToInt16(userContactStatus.Friend));

if (Result != null)

{

dicto.Add("Friends", Result);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("getBlockedUsers")]

public dynamic getBlockedUsers(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().GetContacts(user.mobileNumber, Convert.ToInt16(userContactStatus.Block));

if (Result != null)

{

dicto.Add("Friends", Result);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("getExcludeUsers")]

public dynamic getExcludeUsers(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().GetContacts(user.mobileNumber, Convert.ToInt16(userContactStatus.Exclude));

if (Result != null)

{

dicto.Add("Friends", Result);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("excludeUser")]

public dynamic excludeUser(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().UpdateStatus(user.mobileNumber, user.contactNumber, Convert.ToInt16(user.friendStatus), Convert.ToInt16(user.isFriend));

if (Result != null)

dicto.Add("status", "1");

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("removeFriend")]

public dynamic removeFriend(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().UpdateStatus(user.mobileNumber, user.contactNumber, 0, 1);

if (Result != null)

dicto.Add("status", "1");

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("getFriends")]

public dynamic getFriends(Pro_UserContactMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

var Result = new UserContactRepository().GetFriendsOnly(user.mobileNumber, user.contactNumber);

if (Result != null)

{

dicto.Add("friendsList", Result);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("getCity")]

public dynamic getCity(Pro_CityMaster city)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_CityMaster> Result = new UserRepository().GetCities(city.countryId);

if (Result != null)

{

dicto.Add("Cities", Result);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("getCountry")]

public dynamic getCountry()

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_CountryMaster_New> Result = new UserRepository().GetCountriesForAPI();

if (Result != null)

{

dicto.Add("Countries", Result);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("uploadPost")]

public dynamic uploadPost(Pro_PostMaster post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

if (post.postId == 0)

{

int Result = Convert.ToInt32(new PostRepository().uploadPost(post));

if (Result > 0)

{

if (post.postType == 2)

{

byte[] imageByte = Convert.FromBase64String(post.thumbContent);

MemoryStream ms = new MemoryStream(imageByte, 0, imageByte.Length);

ms.Write(imageByte, 0, imageByte.Length);

Image image = Image.FromStream(ms, true);

image.Save(HttpContext.Current.Server.MapPath("~/Uploads/Posts/") + "Thumb_" + Result + ".png");

image.Dispose();

}

dicto.Add("postId", Result);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

}

else if (post.postId > 0)

{

if (!string.IsNullOrEmpty(post.postContent))

{

if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Uploads/Posts/")))

Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Uploads/Posts/"));

bool IsDataRemain;

byte[] imageBytes = Convert.FromBase64String(post.postContent);

if (post.IsUploadingEnd == true)

{

new Helpers.HelperFunctions().UploadFile(post.FileName, imageBytes, Convert.ToInt64(post.Offset), HttpContext.Current.Server.MapPath("~/Uploads/Posts/"));

IsDataRemain = false;

if (post.postType == 1)

{

Helpers.HelperFunctions.SaveThumbImage(HttpContext.Current.Server.MapPath("~/Uploads/Posts/") + post.FileName, 100, 100, "Thumb_");

}

//else if (post.postType == 2)

//{

// byte[] imageByte = Convert.FromBase64String(post.thumbContent);

// MemoryStream ms = new MemoryStream(imageByte, 0, imageByte.Length);

// ms.Write(imageByte, 0, imageByte.Length);

// Image image = Image.FromStream(ms, true);

// image.Save(HttpContext.Current.Server.MapPath("~/Uploads/Posts/") + "Thumb_" + post.FileName + ".png");

// image.Dispose();

//}

}

else

IsDataRemain = new Helpers.HelperFunctions().UploadFile(post.FileName, imageBytes, Convert.ToInt64(post.Offset), HttpContext.Current.Server.MapPath("~/Uploads/Posts/"));

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("getPosts")]

public dynamic getPosts(Pro_PostMaster post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_PostMaster_API> posts = new PostRepository().GetPostByMobileNumber(post.mobileNumber, post.isBefore, post.pageSize, post.postId, post.distanceType, post.distanceVal);

if (posts.Count > 0)

{

dicto.Add("posts", posts);

dicto.Add("status", "1");

}

else

{

dicto.Add("posts", posts);

dicto.Add("status", "0");

}

return dicto;

}

[HttpPost]

[ActionName("getPostById")]

public dynamic getPostById(Pro_PostMaster_API post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

Pro_PostMaster_API posts = new PostRepository().getPostById(post.postId, post.mobileNumber);

if (posts != null)

{

dicto.Add("postDetail", posts);

dicto.Add("status", "1");

}

else

dicto.Add("status", "0");

return dicto;

}

[HttpPost]

[ActionName("deletePost")]

public dynamic deletePost(Pro_PostMaster post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_PostMaster> objPostList = new PostRepository().GetAllPostForDelete(post.postIds);

foreach (Pro_PostMaster obj in objPostList)

{

if (obj.postType == 1)

{

HelperFunctions.DeleteFile(HttpContext.Current.Server.MapPath("~/Uploads/Posts/" + obj.postId + ".png"));

HelperFunctions.DeleteFile(HttpContext.Current.Server.MapPath("~/Uploads/Posts/Thumb_" + obj.postId + ".png"));

}

else if (obj.postType == 2)

{

HelperFunctions.DeleteFile(HttpContext.Current.Server.MapPath("~/Uploads/Posts/" + obj.postId + ".mp4"));

}

string Result = Convert.ToString(new PostRepository().DeletePost(Convert.ToString(post.postIds)));

if (!string.IsNullOrEmpty(Result))

dicto.Add("status", 1);

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("addLike")]

public dynamic addLike(Pro_PostMaster post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string Result = Convert.ToString(new PostRepository().AddLike(post.postId, post.postBy));

if (Result == "1")

{

dicto.Add("postId", post.postId);

dicto.Add("status", 1);

dicto.Add("message", "liked");

PushHelper.SendPushNotificationLike(post.postId, post.postBy);

}

else if (Result == "-1")

{

dicto.Add("status", 1);

dicto.Add("message", "disliked");

}

return dicto;

}

[HttpPost]

[ActionName("getAllLikes")]

public dynamic getAllLikes(Pro_PostMaster post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_LikeMaster_API> objPostList = new PostRepository().GetAllLikes(post.postId);

if (objPostList != null)

{

dicto.Add("likeList", objPostList);

dicto.Add("MessageType", 3);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("addComments")]

public dynamic addComments(Pro_CommentMaster comment)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

Pro_CommentMaster_API Result = new CommentRepository().InsertComment(comment);

if (Result != null)

{

dicto.Add("comments", Result);

dicto.Add("status", 1);

dicto.Add("MessageType", 4);

PushHelper.SendPushNotificationComments(comment.postId, comment.commentedBy);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("deleteComment")]

public dynamic deleteComment(Pro_CommentMaster comment)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

int Result = Convert.ToInt32(new CommentRepository().DeleteComment(comment.commentId));

if (Result > 0)

dicto.Add("status", 1);

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("getComments")]

public dynamic getComments(Pro_CommentMaster comment)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_CommentMaster_API> objPro_FeedLikeUsers = new CommentRepository().GetComments(comment.postId, comment.commentId, comment.isBefore, comment.pageSize);

if (objPro_FeedLikeUsers != null)

{

dicto.Add("comments", objPro_FeedLikeUsers);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("getPeopleAroundMe")]

public dynamic getPeopleAroundMe(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_UserMaster_ArroundMe> objPro_Users = new UserRepository().AroundMe(user.mobileNumber, user.latitude, user.longitude, user.count, user.distance, user.distanceType);

if (objPro_Users != null)

{

dicto.Add("users", objPro_Users);

dicto.Add("status", 1);

}

else

{

dicto.Add("users", objPro_Users);

dicto.Add("status", 0);

}

return dicto;

}

[HttpPost]

[ActionName("sendPost")]

public dynamic sendPost(Pro_MessageMaster msg)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string obj = Convert.ToString(new MessageRepository().SendPost(msg.messageFrom, msg.messageTo, msg.postId));

if (obj == msg.messageFrom)

dicto.Add("status", 1);

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("sendMessage")]

public dynamic sendMessage(Pro_MessageMaster msg)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

if (msg.messageId == 0)

{

int Result = Convert.ToInt32(new MessageRepository().SaveChat(msg));

if (Result > 0)

{

if ((msg.messageType == 1 || msg.messageType == 2) && msg.thumbContent != "")

{

if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Uploads/Messages/")))

Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Uploads/Messages/"));

byte[] imageBytes = Convert.FromBase64String(msg.thumbContent);

MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);

ms.Write(imageBytes, 0, imageBytes.Length);

Image image = Image.FromStream(ms, true);

image.Save(HttpContext.Current.Server.MapPath("~/Uploads/Messages/") + "Thumb_" + Result + ".png");

image.Dispose();

}

dicto.Add("messageId", Result);

dicto.Add("status", 1);

if (msg.messageType == 4 || msg.messageType == 3 || msg.messageType == 2 || msg.messageType == 1)

PushHelper.SendPushNotificationMessage(Result);

// ThreadPool.QueueUserWorkItem(report => PushHelper.SendPushNotificationMessage(Result));

}

else

dicto.Add("status", 0);

}

else if (msg.messageId > 0)

{

if (!string.IsNullOrEmpty(msg.messageContent))

{

if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Uploads/Messages/")))

Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Uploads/Messages/"));

bool IsDataRemain;

byte[] imageBytes = Convert.FromBase64String(msg.messageContent);

if (msg.IsUploadingEnd == true)

{

new Helpers.HelperFunctions().UploadFile(msg.FileName, imageBytes, Convert.ToInt64(msg.Offset), HttpContext.Current.Server.MapPath("~/Uploads/Messages/"));

IsDataRemain = false;

if (msg.messageType == 4 || msg.messageType == 3 || msg.messageType == 2 || msg.messageType == 1)

{

ThreadPool.QueueUserWorkItem(report => PushHelper.SendPushNotificationMessage(msg.messageId));

}

else

IsDataRemain = new Helpers.HelperFunctions().UploadFile(msg.FileName, imageBytes, Convert.ToInt64(msg.Offset), HttpContext.Current.Server.MapPath("~/Uploads/Messages/"));

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("recieveMessage")]

public dynamic recieveMessage(Pro_MessageMaster msg)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_MessageDetail> objPro_MessageDetail = new MessageRepository().GetMyNewMsg(msg.messageFrom, msg.messageTo, msg.messageId, msg.groupId);

if (objPro_MessageDetail != null)

{

dicto.Add("messages", objPro_MessageDetail);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("getConversations")]

public dynamic getConversations(Pro_MessageMaster msg)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_MessageHistoryDetail> objPro_MessageHistoryDetail = new MessageRepository().GetConversations(msg.messageFrom, msg.messageTo, msg.messageId);

if (objPro_MessageHistoryDetail != null)

{

dicto.Add("messages", objPro_MessageHistoryDetail);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("getRecentMessages")]

public dynamic getRecentMessages(Pro_MessageMaster msg)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_InboxScreen_Api> objPro_MessageDetail = new MessageRepository().GetRecentMsg(msg.messageTo, msg.messageId);

if (objPro_MessageDetail != null)

{

dicto.Add("messages", objPro_MessageDetail);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("createGroup")]

public dynamic createGroup(Pro_GroupMaster group)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

int obj = Convert.ToInt32(new GroupRepository().SaveGroup(group));

if (obj == -1)

{

dicto.Add("message", "Group name already exist");

dicto.Add("status", 0);

}

else if (obj > 0)

{

group.groupId = obj;

ThreadPool.QueueUserWorkItem(report => PushHelper.SendNotifiationForCreateGroup(group));

dicto.Add("groupId", obj);

dicto.Add("status", 1);

}

else

{

dicto.Add("status", 0);

} return dicto;

}

[HttpPost]

[ActionName("getGroupList")]

public dynamic getGroupList(Pro_GroupMaster group)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_GroupList> objPro_Detail = new GroupRepository().getGroupList(group);

if (objPro_Detail != null)

{

dicto.Add("groupList", objPro_Detail);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("getRecievedPosts")]

public dynamic getRecievedPosts(Pro_MessageMaster msg)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

List<Pro_GetMessageDetail> objPro_GetMessageDetail = new MessageRepository().getRecievedPosts(msg.messageTo, msg.messageId);

if (objPro_GetMessageDetail != null)

{

dicto.Add("RecievedPosts", objPro_GetMessageDetail);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

[HttpPost]

[ActionName("deleteAccount")]

public dynamic deleteAccount(Pro_UserMaster user)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string objPro_Users = new UserRepository().deleteAccount(user.mobileNumber);

if (objPro_Users != null)

{

dicto.Add("users", objPro_Users);

dicto.Add("status", 1);

}

else

dicto.Add("status", 0);

return dicto;

}

Web Api

2018-08-23T23:49:00.001+05:30

webapi config
==========================

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web.Http;

namespace WebApplication1

{

public static class WebApiConfig

{

public static void Register(HttpConfiguration config)

{

// Web API configuration and services

// Web API routes

//config.MapHttpAttributeRoutes();

//config.Routes.MapHttpRoute(

// name: "DefaultApi",

// routeTemplate: "api/{controller}/{id}",

// defaults: new { id = RouteParameter.Optional }

//);

config.Routes.MapHttpRoute(

routeTemplate: "api/{controller}"

);

// Controller with ID

config.Routes.MapHttpRoute(

routeTemplate: "api/{controller}/{id}",

defaults: null,

constraints: new { id = @"^\d+$" } // Only integers

);

// Controllers with Actions

config.Routes.MapHttpRoute(

routeTemplate: "api/{controller}/{action}"

);

var json = config.Formatters.JsonFormatter;

json.SerializerSettings.PreserveReferencesHandling =

Newtonsoft.Json.PreserveReferencesHandling.None;

config.Formatters.Remove(config.Formatters.XmlFormatter);

}

==================================
web api
========================================

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Net.Http;

using System.Web.Http;

using WebApplication1.Models;

namespace WebApplication1.Controllers

{

public class ValuesController : ApiController

{

[HttpGet]

[ActionName("getEmp")]

public dynamic getEmp()

{

testEntities db = new testEntities();

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

if (db.Employees.ToList().Count <= 0)

{

//dicto = ServiceHelper.GetServiceJson(ServiceHelper.JsonType.Error, StatusConstants.Error, null, "Login Failed"); // msg as per client said

dicto.Add("status", 0);

dicto.Add("message", "Not Found Data");

}

else

{

dicto.Add("empDetail", db.Employees.ToList());

dicto.Add("status", "1");

dicto.Add("message", "success");

}

return dicto;

}

[HttpPost]

[ActionName("delete")]

public dynamic delete(Employee post)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

return dicto;

}

==========================
pass parameter
================

{
"Emp_Id":"5"

}

Calculate Running Total, Total of a Column and Row

2017-07-04T17:29:00.000+05:30

1. CREATE TABLE CustomerOrders

2. (

3. OrderID int identity,

4. Amount Decimal(8,2),

5. OrderDate SmallDatetime default getdate()

6. )

8. Go

10. INSERT INTO CustomerOrders(Amount) Values(120.12)

11. INSERT INTO CustomerOrders(Amount) Values(20.12)

12. INSERT INTO CustomerOrders(Amount) Values(10.12)

13. INSERT INTO CustomerOrders(Amount) Values(30.12)

14. INSERT INTO CustomerOrders(Amount) Values(40)

15.

16. GO

17.

18. SELECT * FROM CustomerOrders

Calculating Running Total

Let's see how to calculate the running total using SQL Query as given below:

1. select OrderID, OrderDate, CO.Amount

2. ,(select sum(Amount) from CustomerOrders

3. where OrderID <= CO.OrderID)

4. 'Running Total'

5. from CustomerOrders CO

Calculating Final Total

Let's see how to calculate the final total using ROLLUP with in SQL Query as given below:

1. SELECT OrderID, SUM(Amount) AS Amount

2. FROM CustomerOrders

3. GROUP BY OrderID WITH ROLLUP

Calculating Total of All Numeric columns in a row

Let's see how to calculate the total of all numeric fields with in a row using SQL Query as given below:

1. SELECT OrderID, Amount, SUM(OrderID+Amount) AS RowNumericColSum

2. FROM CustomerOrders

3. GROUP BY OrderID,Amount

4. ORDER BY OrderID

SP for Find Values in Entire DB

2017-04-28T14:54:00.001+05:30

Here is the SP using which you can find the table name and column for the value you want to search in entire Database. It has 2 parameter.

1. Value which you want to search and its string.

2. Exact Match , 0/1 , 1 for exact match and 0 for common search. If you pass 0 it will search with % (like) query else it will be with equal to query.

This has help us in NCR and I hope it might help you in future.

-- exec FindDatainDB 'any text',0

CREATE PROCEDURE FindDatainDB

@DataToFind NVARCHAR(4000),

@ExactMatch BIT = 0

SET NOCOUNT ON

DECLARE @Temp TABLE(RowId INT IDENTITY(1,1), SchemaName sysname, TableName sysname, ColumnName SysName, DataType VARCHAR(100), DataFound BIT)

INSERT INTO @Temp(TableName,SchemaName, ColumnName, DataType)

SELECT C.Table_Name,C.TABLE_SCHEMA, C.Column_Name, C.Data_Type

FROM Information_Schema.Columns AS C

INNER Join Information_Schema.Tables AS T

ON C.Table_Name = T.Table_Name

AND C.TABLE_SCHEMA = T.TABLE_SCHEMA

WHERE Table_Type = 'Base Table'

And Data_Type In ('ntext','text','nvarchar','nchar','varchar','char')

DECLARE @i INT

DECLARE @MAX INT

DECLARE @TableName sysname

DECLARE @ColumnName sysname

DECLARE @SchemaName sysname

DECLARE @SQL NVARCHAR(4000)

DECLARE @PARAMETERS NVARCHAR(4000)

DECLARE @DataExists BIT

DECLARE @SQLTemplate NVARCHAR(4000)

SELECT @SQLTemplate = CASE WHEN @ExactMatch = 1

THEN 'If Exists(Select *

From ReplaceTableName

Where Convert(nVarChar(4000), [ReplaceColumnName])

= ''' + @DataToFind + '''

)

Set @DataExists = 1

Else

Set @DataExists = 0'

ELSE 'If Exists(Select *

From ReplaceTableName

Where Convert(nVarChar(4000), [ReplaceColumnName])

Like ''%' + @DataToFind + '%''

)

Set @DataExists = 1

Else

Set @DataExists = 0'

END,

@PARAMETERS = '@DataExists Bit OUTPUT',

@i = 1

SELECT @i = 1, @MAX = MAX(RowId)

FROM @Temp

WHILE @i <= @MAX

BEGIN

SELECT @SQL = REPLACE(REPLACE(@SQLTemplate, 'ReplaceTableName', QUOTENAME(SchemaName) + '.' + QUOTENAME(TableName)), 'ReplaceColumnName', ColumnName)

FROM @Temp

WHERE RowId = @i

PRINT @SQL

EXEC SP_EXECUTESQL @SQL, @PARAMETERS, @DataExists = @DataExists OUTPUT

IF @DataExists =1

UPDATE @Temp SET DataFound = 1 WHERE RowId = @i

SET @i = @i + 1

END

SELECT SchemaName,TableName, ColumnName

FROM @Temp

WHERE DataFound = 1

Set 301 HTTPS site

2017-04-24T15:00:00.002+05:30

Put code in global.asax file

void Application_BeginRequest(Object sender, EventArgs e)
    {

        if (Convert.ToString(System.Web.HttpContext.Current.Request.Url).Contains("http://"))
        {
            string strMainurl = Convert.ToString(System.Web.HttpContext.Current.Request.Url);
            HttpContext.Current.Response.StatusCode = 301;
            HttpContext.Current.Response.Status = "301 Moved Permanently";
            HttpContext.Current.Response.AddHeader("Location", strMainurl.Replace("http://", "https://"));

        }
    }

OwlCarousel 2: Flickering on slide in Chrome and Safari

2017-04-11T10:16:00.000+05:30

https://github.com/OwlCarousel2/OwlCarousel2/issues/599

if you use the owl-carousel / owl.carousel.css just add the bottom attribute

.owl-carousel .owl-wrapper-outer{
    overflow: hidden;
    position: relative;
    width: 100%;
    z-index: 1;  // added this
}

/*
.owl-item {
    -webkit-backface-visibility: hidden;
    -webkit-transform: translateZ(0) scale(1.0, 1.0);
}*/

Insert a line break in mailto body

2017-03-31T10:24:00.002+05:30

I would suggest you try the html tag <br>, in case your marketing application will recognize it.
I use %0D%0A. This should work as long as the email is HTML formatted.

<a href="mailto:email@mycompany.com?subject=Subscribe&body=Lastame%20%3A%0D%0AFirstname%20%3A"><img alt="Subscribe" class="center" height="50" src="subscribe.png" style="width: 137px; height: 50px; color: #4da6f7; font-size: 20px; display: block;" width="137"></a>

http://stackoverflow.com/questions/22765834/insert-a-line-break-in-mailto-body

Bsic

2017-02-01T18:58:00.003+05:30

Free Licence in kentico for local Or any domain
============================================================================

Create account on:

then open : http://devnet.kentico.com

https://client.kentico.com/free-edition

generate key and add in kentico site.

=====================================================================================
{% CurrentDocument.NodeAliasPath=="/contact-us" ? "~/success/#success" : "~/Success-Quote/#success" #%}

if(rbc.Value=="yes")
{txtInvoiceNumber.Enabled=true}else {txtInvoiceNumber.Enabled=false}

PMS
==============================================
Allocated task hours wise entry.
Description of every task which I worked

http://devnet.kentico.com/articles/kentico-8-technology-form-engine-improvements

http://devnet.kentico.com/articles/how-to-work-with-depending-fields

http://ideas.kentico.com/search?filter=ideas&query=forms

https://devnet.kentico.com/articles/using-dependency-fields-in-forms

https://docs.kentico.com/display/K8/Adding+widget+dashboards+to+the+interface

https://docs.kentico.com/display/K8/CMSDataGrid

~/CMSGlobalFiles/AddBanner.aspx?dashboardName=AddBanner&templateName=AddBannerDashboard&{hash}

AddBanner.aspx

~/CMSGlobalFiles/ListBanner.aspx?dashboardName=ListBanner&templateName=ListBannerDashboard&{hash}

==============================================================================================================

Transformaion Condition

==============================================================================================================

<% if (Eval("OpenInNewTab") == "True") { %>

<div class="item"><a target="_blank" href="<%# Eval("BannerLink") %>">
<img alt="" class="show-web" src="~/NCR/media/BannerImages/<%# Eval("BannerImage") %>" />
</a></div>

<% } else { %>

<div class="item"><a href="<%# Eval("BannerLink") %>">
<img alt="" class="show-web" src="~/NCR/media/BannerImages/<%# Eval("BannerImage") %>" />
</a></div>


   <% } %>

======================================================

{% Settings["WebsiteName"]#%}

{% Settings['WebsiteURL']#%}

{%CurrentSite.SiteDisplayName#%}

====================================================================================================================================
Created Custom Setting Module
=====================================================================

Sending any data or information from web.config file is quite unusual scenario. Moreover, typically application settings in web.config are not setup dynamically. Therefore, our macro engine does not have support for direct access of the web.config’s application settings. You will need to use some workaround. The best way would be to create to custom setting in our Settings application as per https://docs.kentico.com/display/K9/Adding+custom+website+settings and store requited value within. Then, you can get its value in notification email via macro expression: Settings["<sitename>.<settingkeyname>"], of Settings["mycustomkey"] for global settings. More info about writing macros can be found in https://docs.kentico.com/display/K9/Entering+macro+expressions

=========================================

Captcha

===================

siteKey : 6LfqkSgTAAAAAL8mNut1jny4edvB3dYBsnfRapN4

secrateKey : 6LfqkSgTAAAAAJRTm_phpjbBXCin18E9VBDvN443

https://www.google.com/recaptcha/admin#site/321425898?setup

https://devnet.kentico.com/marketplace/inline-controls/new-recaptcha

=================================
Forms Search
======================

https://docs.kentico.com/display/K8/Displaying+filters+using+alternative+forms

=======================================
Repeter select Transformation Type text/xml
========================================

{% if (OpenInNewTab) { %}

<div class="item">

<a target="_blank"   href="{% BannerLink=="" ? "javascript:;" : BannerLink #%}">
<img alt="" class="show-web" src="~/NCR/media/BannerImages/{% BannerImage %}" />
</a></div>
{% }else{ %}
<div class="item">
<a href="{% BannerLink=="" ? "javascript:;" : BannerLink #%}">
<img alt="" class="show-web" src="~/NCR/media/BannerImages/{% BannerImage %}" />
</a></div>
{% } #%}
======================================

Data Gried Link

==================================================================

https://docs.kentico.com/display/K8/CMSDataGrid

https://docs.kentico.com/display/K8/Reference+-+UniGrid+definition

https://devnet.kentico.com/articles/advanced-unigrid-example

https://docs.kentico.com/display/K8/Adding+custom+UniGrid+transformations

https://docs.kentico.com/display/K8/UniGrid
https://docs.kentico.com/display/K82/Creating+custom+UniGrid+filters
https://devnet.kentico.com/articles/extending-unigrid-and-filtering-options

https://docs.kentico.com/display/API9/Custom+table+data#Customtabledata-Changingtheorderofcustomtablerecords

===========================================================================================================================

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Ecommerce

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

http://devnet.kentico.com/articles/kentico-uservoice-clean-up

Product filter

https://docs.kentico.com/display/K9/Configuring+product+listings+with+filtering#Configuringproductlistingswithfiltering-PreparingtheindexforageneralpageorSKUfield

=====================================================================================================================================================

AutoComplet forms
===================================================

https://devnet.kentico.com/marketplace/inline-controls/user-selector-with-autocomplete

https://docs.kentico.com/display/K9/Developing+form+controls

Prevent safari loading from cache when back button is clicked

2017-02-01T18:49:00.000+05:30

Your problem is caused by back-forward cache. It is supposed to save complete state of page when user navigates away. When user navigates back with back button page can be loaded from cache very quickly. This is different from normal cache which only caches HTML code.

When page is loaded for bfcache onload event wont be triggered. Instead you can check the persisted property of the onpageshow event. It is set to false on initial page load. When page is loaded from bfcache it is set to true.

Kludgish solution is to force a reload when page is loaded from bfcache.

window.onpageshow = function(event) {
    if (event.persisted) {
        window.location.reload()
    }
};

If you are using jQuery then do:

$(window).bind("pageshow", function(event) {
    if (event.originalEvent.persisted) {
        window.location.reload()
    }
});

JQuery data table

2016-05-11T15:18:00.004+05:30

$j = jQuery.noConflict();

$j(document).ready(function () {

//For data table

$j('#example').DataTable({

"iDisplayLength": 25, // default load data

"order": [[4, "desc"]], // Default desc order

stateSave: true, // Maintain the paging session to next page

// "bProcessing": true,

// "bSort": false

"aoColumnDefs": [{ 'bSortable': false, 'aTargets': [5] }] // hide the column

});

</script>

Remove jquery datatable sorting on particular column

2016-03-23T17:17:00.001+05:30

$j = jQuery.noConflict();

$j(document).ready(function () {

//For data table

$j('#example').DataTable({

"iDisplayLength": 100,

// "bProcessing": true,

// "bSort": false

"aoColumnDefs": [

{ 'bSortable': false, 'aTargets': [2,6,7] }

]

});

Sql Most asking Query

2016-03-17T10:18:00.000+05:30

INTRODUCTION

SQL queries most asked in .NET/SQL Server job interviews. These tricky queries may be required in your day to day database usage.

BACKGROUND

This article demonstrates some commonly asked SQL queries in a job interview. I will be covering some of the common but tricky queries like:-

(i) Finding the nth highest salary of an employee.
(ii) Finding TOP X records from each group.
(iii) Deleting duplicate rows from a table.

NOTE : All the SQL mentioned in this article has been tested under SQL Server 2005.

(i) Finding the nth highest salary of an employee.

Create a table named Employee_Test and insert some test data as:-

Hide Copy Code

CREATE TABLE Employee_Test

(

Emp_ID INT Identity,

Emp_name Varchar(100),

Emp_Sal Decimal (10,2)

)

INSERT INTO Employee_Test VALUES ('Anees',1000);

INSERT INTO Employee_Test VALUES ('Rick',1200);

INSERT INTO Employee_Test VALUES ('John',1100);

INSERT INTO Employee_Test VALUES ('Stephen',1300);

INSERT INTO Employee_Test VALUES ('Maria',1400);

It is very easy to find the highest salary as:-

Hide Copy Code

--Highest Salary

select max(Emp_Sal) from Employee_Test

Now, if you are asked to find the 3rd highest salary, then the query is as:-

Hide Copy Code

--3rd Highest Salary

select min(Emp_Sal) from Employee_Test where Emp_Sal in

(select distinct top 3 Emp_Sal from Employee_Test order by Emp_Sal desc)

The result is as :- 1200
To find the nth highest salary, replace the top 3 with top n (n being an integer 1,2,3 etc.)

Hide Copy Code

--nth Highest Salary

select min(Emp_Sal) from Employee_Test where Emp_Sal in

(select distinct top n Emp_Sal from Employee_Test order by Emp_Sal desc)

(ii) Finding TOP X records from each group

Create a table named photo_test and insert some test data as :-

Hide Copy Code

create table photo_test

(

pgm_main_Category_id int,

pgm_sub_category_id int,

file_path varchar(MAX)

)

insert into photo_test values

(17,15,'photo/bb1.jpg');

insert into photo_test values(17,16,'photo/cricket1.jpg');

insert into photo_test values(17,17,'photo/base1.jpg');

insert into photo_test values(18,18,'photo/forest1.jpg');

insert into photo_test values(18,19,'photo/tree1.jpg');

insert into photo_test values(18,20,'photo/flower1.jpg');

insert into photo_test values(19,21,'photo/laptop1.jpg');

insert into photo_test values(19,22,'photo/camer1.jpg');

insert into photo_test values(19,23,'photo/cybermbl1.jpg');

insert into photo_test values

(17,24,'photo/F1.jpg');

There are three groups of pgm_main_category_id each with a value of 17 (group 17 has four records),18 (group 18 has three records) and 19 (group 19 has three records).
Now, if you want to select top 2 records from each group, the query is as follows:-

Hide Copy Code

select pgm_main_category_id,pgm_sub_category_id,file_path from

(

select pgm_main_category_id,pgm_sub_category_id,file_path,

rank() over (partition by pgm_main_category_id order by pgm_sub_category_id asc) as rankid

from photo_test

) photo_test

where rankid < 3 -- replace 3 by any number 2,3 etc for top2 or top3.

order by pgm_main_category_id,pgm_sub_category_id

The result is as:-

Hide Copy Code

pgm_main_category_id pgm_sub_category_id file_path

17 15 photo/bb1.jpg

17 16 photo/cricket1.jpg

18 18 photo/forest1.jpg

18 19 photo/tree1.jpg

19 21 photo/laptop1.jpg

19 22 photocamer1.jpg

(iii) Deleting duplicate rows from a table

A table with a primary key doesn’t contain duplicates. But if due to some reason, the keys have to be disabled or when importing data from other sources, duplicates come up in the table data, it is often needed to get rid of such duplicates.
This can be achieved in tow ways :-
(a) Using a temporary table.
(b) Without using a temporary table.

(a) Using a temporary or staging table

Let the table employee_test1 contain some duplicate data like:-

Hide Copy Code

CREATE TABLE Employee_Test1

(

Emp_ID INT,

Emp_name Varchar(100),

Emp_Sal Decimal (10,2)

)

INSERT INTO Employee_Test1 VALUES (1,'Anees',1000);

INSERT INTO Employee_Test1 VALUES (2,'Rick',1200);

INSERT INTO Employee_Test1 VALUES (3,'John',1100);

INSERT INTO Employee_Test1 VALUES (4,'Stephen',1300);

INSERT INTO Employee_Test1 VALUES (5,'Maria',1400);

INSERT INTO Employee_Test1 VALUES (6,'Tim',1150);

Step 1: Create a temporary table from the main table as:-

Hide Copy Code

select top 0* into employee_test1_temp from employee_test1

Step2 : Insert the result of the GROUP BY query into the temporary table as:-

Hide Copy Code

insert into employee_test1_temp

select Emp_ID,Emp_name,Emp_Sal

from employee_test1

group by Emp_ID,Emp_name,Emp_Sal

Step3: Truncate the original table as:-

Hide Copy Code

truncate table employee_test1

Step4: Fill the original table with the rows of the temporary table as:-

Hide Copy Code

insert into employee_test1

select * from employee_test1_temp

Now, the duplicate rows from the main table have been removed.

Hide Copy Code

select * from employee_test1

gives the result as:-

Hide Copy Code

Emp_ID Emp_name Emp_Sal

1 Anees 1000

2 Rick 1200

3 John 1100

4 Stephen 1300

5 Maria 1400

6 Tim 1150

(b) Without using a temporary table

Hide Copy Code

;with T as

(

select * , row_number() over (partition by Emp_ID order by Emp_ID) as rank

from employee_test1

)

delete

from T

where rank > 1

The result is as:-

Hide Copy Code

Emp_ID Emp_name Emp_Sal

1 Anees 1000

2 Rick 1200

3 John 1100

4 Stephen 1300

5 Maria 1400

6 Tim 1150

CONCLUSION

I hope that these queries will help you for Interviews as well as in your day database activities.

DropDown dynamic Month and year bind

2016-03-17T10:13:00.000+05:30

public void BindMonthDropDownList()

{

List<SelectListItem> ddlMonthNames = new List<SelectListItem>();

ddlMonthNames.Add(new SelectListItem { Text = "--Select Month--", Value = "0" });

for (int month = 1; month <= 12; month++)

{

string monthName = DateTimeFormatInfo.CurrentInfo.GetMonthName(month);

ddlMonthNames.Add(new SelectListItem { Text = monthName, Value = month.ToString().PadLeft(2, '0') });

}

ViewBag.MonthDropDownList = ddlMonthNames;

}

public void BindYearDropDownList()

{

List<SelectListItem> ddlMonthNames = new List<SelectListItem>();

ddlMonthNames.Add(new SelectListItem { Text = "--Select Year--", Value = "0" });

for (int i = 2000; i <= System.DateTime.Now.AddYears(1).Year; i++)

{

ddlMonthNames.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() });

}

ViewBag.yearDropDownList = ddlMonthNames;

}

Cursor Demo

2016-03-17T10:05:00.000+05:30

CREATE TABLE Employee

(

EmpID int PRIMARY KEY,

EmpName varchar (50) NOT NULL,

Salary int NOT NULL,

Address varchar (200) NOT NULL,

)

INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(1,'Mohan',12000,'Noida')

INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(2,'Pavan',25000,'Delhi')

INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(3,'Amit',22000,'Dehradun')

INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(4,'Sonu',22000,'Noida')

INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(5,'Deepak',28000,'Gurgaon')

SELECT * FROM Employee

==================================

Cursor

=====================

SET NOCOUNT ON

DECLARE @Id int

DECLARE @name varchar(50)

DECLARE @salary int

DECLARE cur_emp CURSOR

STATIC FOR

SELECT EmpID,EmpName,Salary from Employee

OPEN cur_emp

IF @@CURSOR_ROWS > 0

BEGIN

FETCH NEXT FROM cur_emp INTO @Id,@name,@salary

WHILE @@Fetch_status = 0

BEGIN

PRINT 'ID : '+ convert(varchar(20),@Id)+', Name : '+@name+ ', Salary : '+convert(varchar(20),@salary)

FETCH NEXT FROM cur_emp INTO @Id,@name,@salary

END

CLOSE cur_emp

DEALLOCATE cur_emp

SET NOCOUNT OFF

=========================================

With table varible

==============================================

SET NOCOUNT ON

DECLARE @Id int

DECLARE @name varchar(50)

DECLARE @salary int

DECLARE @LocalTempTable table(

Id int,

name varchar(max),

Salary varchar(max))

DECLARE cur_emp CURSOR

STATIC FOR

SELECT EmpID,EmpName,Salary from Employee

OPEN cur_emp

IF @@CURSOR_ROWS > 0

BEGIN

FETCH NEXT FROM cur_emp INTO @Id,@name,@salary

WHILE @@Fetch_status = 0

BEGIN

IF @salary >10000

BEGIN

insert into @LocalTempTable(Id,name,Salary) values( @Id, @name,@salary)

PRINT 'ID : '+ convert(varchar(20),@Id)+', Name : '+@name+ ', Salary : '+convert(varchar(20),@salary)

END

FETCH NEXT FROM cur_emp INTO @Id,@name,@salary

END

select * from @LocalTempTable

CLOSE cur_emp

DEALLOCATE cur_emp

SET NOCOUNT OFF

Free Chat Messanger

2016-01-07T17:55:00.000+05:30

https://dashboard.tawk.to/?lang=en

How to frequently refresh page using json Ajax request.

2015-11-06T17:10:00.001+05:30

Aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="3way.aspx.cs" Inherits="Bettingdisplays1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%--<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script>--%>

setInterval(function ShowCurrentTime() {

$.ajax({

type: "POST",

url: "3way.aspx/BindMarketSubbetType",

data: '{id: "' + $("#<%=hdneventId.ClientID%>")[0].value + '" }',

contentType: "application/json; charset=utf-8",

dataType: "json",

success: OnSuccess,

failure: function(response) {

}

});

}, 3000);

function OnSuccess(response) {

$('#divMarket').html(response.d);

}

</script>

</head>

<body>

<asp:HiddenField ID="hdneventId" runat="server" Value="0" />

<asp:Panel ID="pnlMarket" runat="server" Visible="">

</div>

</asp:Panel>

<asp:Panel ID="Panel1" runat="server" Visible="false">

Please Pass the eventId in URL.

</div>

</asp:Panel>

</div>

</form>

</body>

</html>

webMethod

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Text;

using TurfSportOnline.Library;

using TurfSportOnline.Library.Template;

using TurfSportOnline.Library.WSBackOfficeSec;

using TurfSportOnline;

using System.Configuration;

using System.Data.SqlClient;

using Properties;

using Helper;

using DataAccessLayer;

using System.Data.Common;

public partial class Bettingdisplays1 : System.Web.UI.Page

{

string tournamentID = string.Empty;

string tournamentDates = string.Empty;

string name = string.Empty;

SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

private static DBHelper objDALHelper = new DBHelper();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

if (Request.QueryString["eventId"] != null)

hdneventId.Value = Request.QueryString["eventId"];

else

Panel1.Visible=true;

}

private DataTable GetNextList()

{

DataTable dts = new DataTable();

try

{

SqlCommand cmd = new SqlCommand("spTournamentsLVINP", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dts);

}

catch (Exception ex)

{

throw ex;

}

return dts;

}

private static DataTable CreateTableEvent()

{

DataTable dt = new DataTable();

dt.Columns.Add("eventId", Type.GetType("System.Int32"));

dt.Columns.Add("tournamentId", Type.GetType("System.Int32"));

dt.Columns.Add("eventDate", Type.GetType("System.DateTime"));

dt.Columns.Add("payPlaces", Type.GetType("System.Int32"));

return dt;

}

private static void AddThisRowEventRow(ref DataTable dt, int? eventId, int? tournamentId, DateTime eventDate, int? payPlaces)

{

DataRow dr = dt.NewRow();

dr["eventId"] = eventId;

dr["tournamentId"] = tournamentId;

dr["eventDate"] = eventDate;

dr["payPlaces"] = payPlaces;

dt.Rows.Add(dr);

}

protected void rptTour_OnItemDataBound(object sender, RepeaterItemEventArgs e)

{

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

HiddenField hd = (HiddenField)e.Item.FindControl("tID");

CheckBox chk = (CheckBox)e.Item.FindControl("chkID");

chk.Attributes.Add("onclick", "setvalue(this," + hd.Value + ")");

}

public static List<Pro_NextEventList> GetEventListByTournament(int eventId)

{

objDALHelper = new DBHelper();

List<Pro_NextEventList> objPro_NextEventList2 = new List<Pro_NextEventList>();

try

{

objDALHelper.Command.Parameters.Clear();

objDALHelper.AddParameter("@eventId", eventId);

using (DbDataReader dr = (DbDataReader)objDALHelper.ExecuteReader("spSelectLPeventById", CommandType.StoredProcedure))

{

while (dr.Read())

{

Pro_NextEventList objPro_NextEventList = new Pro_NextEventList();

// objPro_NextEventList.Id = CommanLogic.GetIntValue(dr["id"], 0);

// objPro_NextEventList.sportId = CommanLogic.GetIntValue(dr["sportId"], 0);

objPro_NextEventList.tournamentId = CommanLogic.GetIntValue(dr["tournamentId"], 0);

objPro_NextEventList.eventId = CommanLogic.GetIntValue(dr["eventId"], 0);

objPro_NextEventList.betType = CommanLogic.GetIntValue(dr["betType"], 0);

objPro_NextEventList.subBetTypes = CommanLogic.GetIntValue(dr["subBetTypes"], 0);

objPro_NextEventList.eventName = CommanLogic.GetStringValue(dr["eventName"], string.Empty);

objPro_NextEventList.eventNumber = CommanLogic.GetStringValue(dr["eventNumber"], string.Empty);

objPro_NextEventList.eventDate = CommanLogic.GetDateTimeValue(dr["eventDate"]);

objPro_NextEventList.eventStatus = CommanLogic.GetIntValue(dr["eventStatus"], 0);

objPro_NextEventList.wagerStart = CommanLogic.GetDateTimeValue(dr["wagerStart"]);

objPro_NextEventList.wagerEnd = CommanLogic.GetDateTimeValue(dr["wagerEnd"]);

objPro_NextEventList.displayStart = CommanLogic.GetDateTimeValue(dr["displayStart"]);

objPro_NextEventList.displayEnd = CommanLogic.GetDateTimeValue(dr["displayEnd"]);

objPro_NextEventList.CloseOnWagerEnd = CommanLogic.GetBoolValue(dr["CloseOnWagerEnd"], false);

objPro_NextEventList.PlacePerc = CommanLogic.GetIntValue(dr["PlacePerc"], 0);

objPro_NextEventList.PayPlaces = CommanLogic.GetIntValue(dr["PayPlaces"], 0);

objPro_NextEventList.LiveInRunning = CommanLogic.GetIntValue(dr["LiveInRunning"], 0);

objPro_NextEventList.LongtermAntePost = CommanLogic.GetIntValue(dr["LongtermAntePost"], 0);

objPro_NextEventList.CurrentBetting = CommanLogic.GetIntValue(dr["CurrentBetting"], 0);

objPro_NextEventList.spreadBetting = CommanLogic.GetIntValue(dr["spreadBetting"], 0);

objPro_NextEventList.exoticBetting = CommanLogic.GetIntValue(dr["exoticBetting"], 0);

objPro_NextEventList.comments = CommanLogic.GetStringValue(dr["comments"], string.Empty);

objPro_NextEventList2.Add(objPro_NextEventList);

}

catch (Exception ex)

{

throw ex;

}

finally

{ objDALHelper = null; }

return objPro_NextEventList2;

}

[System.Web.Services.WebMethod]

public static string BindMarketSubbetType(string id)

{

StringBuilder sb = new StringBuilder();

if (!string.IsNullOrEmpty(id))

{

int tId = Convert.ToInt32(id);

// pnlMarket.Visible = true;

// pnlTournament.Visible = false;

DataTable tdt = CreateTableEvent();

int v, d;

List<Properties.Pro_NextEventList> obj_pro_nexteventlist = new List<Properties.Pro_NextEventList>();

obj_pro_nexteventlist = GetEventListByTournament(Convert.ToInt32(tId));

for (int ii = 0; ii < obj_pro_nexteventlist.Count; ii++)

AddThisRowEventRow(ref tdt, obj_pro_nexteventlist[ii].eventId, obj_pro_nexteventlist[ii].tournamentId, obj_pro_nexteventlist[ii].eventDate, obj_pro_nexteventlist[ii].PayPlaces);

DataView dv1 = tdt.DefaultView;

dv1.Sort = "eventDate asc";

tdt = dv1.ToTable();

List<TurfSportOnline.Library.MarketList> obj_marketlist = new List<TurfSportOnline.Library.MarketList>();

Event event2 = null;

if (tdt.Rows.Count > 0)

{

// if (Request.QueryString["name"] == null)

//{

sb.Append("<div id='sliderwrap'>");

bool added = false;

for (int j = 0; j < 1; j++)

{

event2 = new Event(Convert.ToInt32(tdt.Rows[j]["eventId"]));

event2.Load();

event2.MarketList.Sort(new TurfSportOnline.Library.MarketList.MarketComparer());

// if (event2.MarketList[0].EventDate >= DateTime.Now && added == false)

// {

added = true;

sb.Append("<div class='contentslider'>");

sb.Append("<div class='tbl'>");

sb.Append("<table width='100%' class='uk-table uk-table-striped uk-table-condensed uk-text-nowrap' border='0' align='left' cellpadding='0' cellspacing='0'>");

sb.Append("<tr>");

//sb.Append("<h2>");

//// sb.Append("<em class='font35'>" + event2.MarketList[0].TournamentName + " (" + event2.MarketList[0].WagerEnd.ToString("dd MMM yyyy") + ")" + event2.MarketList[0].WagerEnd.ToString(" HH:mm") + " Race " + event2.MarketList[0].EventNumber + " [ " + tdt.Rows[j]["payPlaces"] + " Places ] </em></h2>");

//sb.Append("<em class='font35'> DateTime : " + DateTime.Now + " </em></h2>");

sb.Append("<h1 style='color:#005B31'>LIVE IN-PLAY BETTING <h2 style='color:#005B31'>");

// sb.Append("<em class='font35'>" + event2.MarketList[0].TournamentName + " (" + event2.MarketList[0].WagerEnd.ToString("dd MMM yyyy") + ")" + event2.MarketList[0].WagerEnd.ToString(" HH:mm") + " Race " + event2.MarketList[0].EventNumber + " [ " + tdt.Rows[j]["payPlaces"] + " Places ] </em></h2>");

sb.Append(event2.MarketList[0].EventName + "(3 ways odd)</h2></h1>");

sb.Append("</tr>");

sb.Append("<tr>");

//sb.Append("<td td width='15%' align='center' >");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>NO</em></h2>");

//sb.Append("</td>");

sb.Append("<td width='66%'>");

sb.Append("<h2>");

sb.Append("MARKET NAME</h2>");

sb.Append("</td>");

sb.Append("<td width='19%' align='center'>");

sb.Append("<h2>");

sb.Append("HOME</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append("DRAW</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append("AWAY</h2>");

sb.Append("</td>");

//sb.Append("<td width='15%' align='center'>");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>STATUS</em></h2>");

//sb.Append("</td>");

sb.Append("</tr>");

for (int i = 0; i < event2.MarketList.Count; i++)

{

if (event2.MarketList[i].Status != MarketStatus.Closed)

{

sb.Append("<tr>");

//sb.Append("<td width='15%' align='center'>");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>" + event2.MarketList[i].Id + "</em></h2>");

//sb.Append("</td>");

sb.Append("<td width='66%' align='left'>");

sb.Append("<h2>");

if (event2.MarketList[i].Status == MarketStatus.Scratched)

sb.Append( event2.MarketList[i].MarketName + " (" + event2.MarketList[i].ScratchingDeduction.ToString("0.##") + "%)" + "</h2>");

else

sb.Append( event2.MarketList[i].MarketName + "</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append(event2.MarketList[i].HomePrice.ToString("0.00") + "</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append(event2.MarketList[i].DrawPrice.ToString("0.00") + "</h2>");

sb.Append("</td>");

sb.Append("<td width='15%' align='center'>");

sb.Append("<h2>");

sb.Append(event2.MarketList[i].AwayPrice.ToString("0.00") + "</h2>");

sb.Append("</td>");

//sb.Append("<td width='15%' align='center'>");

//sb.Append("<h2>");

//sb.Append("<em class='font35'>" + event2.MarketList[i].Status + "</em></h2>");

//sb.Append("</td>");

sb.Append("</tr>");

}

sb.Append("</table>");

sb.Append("</div>");

//}

// sb.Append("</div>");

}

sb.Append("</div>");

// divMarket.InnerHtml = sb.ToString();

}

// }

// else

// {

//Response.Redirect("Bettingdisplays.aspx");

//string url = HttpContext.Current.Request.Url.AbsoluteUri;

//Response.Redirect(url);

// }

}

return sb.ToString();

}

How to get json Array through web api and insert in database

2015-11-06T16:45:00.000+05:30

Json Request
===============
{"questions":

"[{'option1':'Surat','option2':'ahmedabad','correctAnswer':'2','option3':'baroda','userId':'1','questionText':'What is big city in gujarat?'},{'option1':'d','option2':'sd','correctAnswer':'2','option3':'s','userId':'1','questionText':'222222'}]",
"questionCount":4}

========================

[HttpPost]

[ActionName("addQuestion")]

public dynamic addQuestion(Pro_Questionslists question)

{

Dictionary<string, dynamic> dicto = new Dictionary<string, dynamic>();

string abc = Convert.ToString(question.questions);

JavaScriptSerializer jss = new JavaScriptSerializer();

List<Pro_Questions> Contactlist = jss.Deserialize<List<Pro_Questions>>(abc);

QuestionRepository obj = new QuestionRepository();

obj.SaveQuestionAPI(Contactlist, question.questionsCount);

if (obj != null)

{

dicto.Add("status", "1");

dicto.Add("message", "success");

}

else

{

dicto.Add("status", "0");

dicto.Add("message", "fail");

}

return dicto;

}

======================================

   public class Pro_Questions
    {
        public int? page { get; set; }
        public string mode { get; set; }
        public int questionId { get; set; }
        public int userId { get; set; }

        public string questionText { get; set; }

        public string userName { get; set; }

        public int ID { get; set; }

        public int questionsCount { get; set; }
        public string option1 { get; set; }
        public string option2 { get; set; }
        public string option3 { get; set; }
        public string option4 { get; set; }
        public string option { get; set; }

        public string correctAnswer { get; set; }


        public DateTime? createdOn { get; set; }
        public bool status { get; set; }

        public string sortBy { get; set; }
        public string sortOrder { get; set; }
        public string searchField { get; set; }
        public string searchValue { get; set; }
    }

============================

public void SaveQuestionAPI(List<Pro_Questions> objPro_Question, int count)
        {
            objDBHelper = new DBHelper();
            try
            {
                //   objPro_Question.mode = "INSERT";

                for (int i = 0; i < objPro_Question.Count; i++)
                {
                    if (objPro_Question[i].questionId > 0)
                    {
                        objDBHelper.AddParameter("@mode", "UPDATE");
                        objDBHelper.AddParameter("@questionId", objPro_Question[i].questionId);

                        objDBHelper.AddParameter("@userId", objPro_Question[i].userId);
                        objDBHelper.AddParameter("@option1", objPro_Question[i].option1);
                        objDBHelper.AddParameter("@option2", objPro_Question[i].option2);
                        objDBHelper.AddParameter("@option3", objPro_Question[i].option3);
                        //   objDBHelper.AddParameter("@option4", objPro_Question[i].option4);
                        objDBHelper.AddParameter("@questionText", objPro_Question[i].questionText);
                        objDBHelper.AddParameter("@correctAnswer", objPro_Question[i].correctAnswer);
                        objDBHelper.ExecuteScaler(SPName, CommandType.StoredProcedure);
                    }
                    else
                    {
                        objDBHelper.AddParameter("@mode", "INSERT");
                        // objDBHelper.AddParameter("@questionId", objPro_Question.questionId);
                        objDBHelper.AddParameter("@userId", objPro_Question[i].userId);
                        objDBHelper.AddParameter("@option1", objPro_Question[i].option1);
                        objDBHelper.AddParameter("@option2", objPro_Question[i].option2);
                        objDBHelper.AddParameter("@option3", objPro_Question[i].option3);
                        //   objDBHelper.AddParameter("@option4", objPro_Question[i].option4);
                        objDBHelper.AddParameter("@questionText", objPro_Question[i].questionText);
                        objDBHelper.AddParameter("@correctAnswer", objPro_Question[i].correctAnswer);
                        objDBHelper.ExecuteScaler(SPName, CommandType.StoredProcedure);
                    }
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                CacheHelper.Clear(key);
                objDBHelper = null;
            }
        }