public string getUserDetailsToVerify(string query)
{
string CS = ConfigurationManager.ConnectionStrings["FlipZonCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
List <Login_Register> pdList = new List <Login_Register>();
while (rdr.Read())
{
Login_Register InsLogReg = new Login_Register();
InsLogReg.Email_Id = rdr["Email_Id"].ToString();
InsLogReg.Full_Name = rdr["Full_Name"].ToString();
InsLogReg.Login_Id = rdr["Login_Id"].ToString();
InsLogReg.Mobile_No = double.Parse(rdr["Mobile_No"].ToString());
pdList.Add(InsLogReg);
}
var json = JsonConvert.SerializeObject(pdList);
return(json);
}
}
public int RegisterUserAllowLogin(Login_Register UserDetail)
{
string CS = ConfigurationManager.ConnectionStrings["FlipZonCS"].ConnectionString;
string command;
int IsSuccess;
if (UserDetail.Mobile_No != 0)
{
command = @"Insert into User_Login_Details (Email_Id, Full_Name, Login_Id, Mobile_No, Passwords) values ('" + UserDetail.Email_Id + "','" + UserDetail.Full_Name + "','" + UserDetail.Login_Id + "'," + UserDetail.Mobile_No + ",'" + UserDetail.Passwords + "')";
}
else
{
command = @"select count(Email_Id) from User_Login_Details where Login_Id='" + UserDetail.Login_Id + "' and Passwords='" + UserDetail.Passwords + "'";
}
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(command, con);
con.Open();
if (UserDetail.Mobile_No != 0)
{
IsSuccess = cmd.ExecuteNonQuery();
}
else
{
IsSuccess = (int)cmd.ExecuteScalar();
}
if (IsSuccess != 0)
{
return(1);
}
else
{
return(0);
}
}
}