[WebMethod()] public string CheckLoginDetailNew(string Obj) { string strFinal = "error"; try { var jss = new JavaScriptSerializer(); var loginObj = jss.Deserialize(Obj); DataTable dt = new DataTable(); string str = ""; str = "usp_Client_CheckLogin"; Sqlcmd = new SqlCommand(); SqlCon.Open(); Sqlcmd.CommandText = str; Sqlcmd.CommandType = CommandType.StoredProcedure; Sqlcmd.Parameters.AddWithValue("@Mobile", loginObj["Obj"][0]["Mobile"]); Sqlcmd.Parameters.AddWithValue("@Password", loginObj["Obj"][0]["Password"]); Sqlcmd.Parameters.AddWithValue("@DeviceType", loginObj["Obj"][0]["DeviceType"]); Sqlcmd.Parameters.AddWithValue("@Mac", loginObj["Obj"][0]["Mac"]); Sqlcmd.Parameters.AddWithValue("@DeviceToken", loginObj["Obj"][0]["DeviceToken"]); Sqlcmd.Connection = SqlCon; SqlDataAdapter SqlAdp = new SqlDataAdapter(Sqlcmd); SqlAdp.Fill(dt); Sqlcmd.Dispose(); SqlCon.Close(); if (dt.Rows.Count > 0) strFinal = dt.Rows[0][0].ToString().Trim(); } catch (Exception ex) { strFinal = "error"; SqlCon.Close(); } finally { SqlCon.Close(); } return strFinal; } // [WebMethod()] // public string CheckLoginDetailNew(string strMobile, string strPassword, string strDeviceType, string strMac, string strDeviceToken) // { // string strFinal = "error"; // try // { // //var jss = new JavaScriptSerializer(); // //var loginObj = jss.Deserialize(Obj); // DataTable dt = new DataTable(); // string str = ""; // str = "usp_Client_CheckLogin"; // Sqlcmd = new SqlCommand(); // SqlCon.Open(); // Sqlcmd.CommandText = str; // Sqlcmd.CommandType = CommandType.StoredProcedure; // Sqlcmd.Parameters.AddWithValue("@Mobile", strMobile.ToString().Trim()); // Sqlcmd.Parameters.AddWithValue("@Password", strPassword.ToString().Trim()); // Sqlcmd.Parameters.AddWithValue("@DeviceType", strDeviceType.ToString().Trim()); // Sqlcmd.Parameters.AddWithValue("@Mac", strMac.ToString().Trim()); // Sqlcmd.Parameters.AddWithValue("@DeviceToken", strDeviceToken.ToString().Trim()); // Sqlcmd.Connection = SqlCon; // SqlDataAdapter SqlAdp = new SqlDataAdapter(Sqlcmd); // SqlAdp.Fill(dt); // Sqlcmd.Dispose(); // SqlCon.Close(); // if (dt.Rows.Count > 0) // strFinal = dt.Rows[0][0].ToString().Trim(); // } // catch (Exception ex) // { // strFinal = "error"; // SqlCon.Close(); // } // finally // { // SqlCon.Close(); // } // return strFinal; // }