public CommonModal verifyotp(SendMobileMessage sm)
{
CommonModal e1 = new CommonModal();
SqlConnection conn = new SqlConnection(commonCode.conStr);
conn.Open();
SqlCommand cmd = new SqlCommand("Pro_LoginCRUD", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@login_Id", SqlDbType.NVarChar).Value = sm.login_Id;
cmd.Parameters.Add("@otp", SqlDbType.NVarChar).Value = sm.otp;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = "verifyotp";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
conn.Close();
if (Dt.Rows.Count > 0)
{
e1.ResponseStatus = Dt.Rows[0]["status"].ToString();
e1.ResponseMessage = Dt.Rows[0]["Msg"].ToString();
e1.data = Dt;
}
else
{
e1.ResponseStatus = "False";
e1.ResponseMessage = "Verification Failed!!";
// e1.data = Dt;
}
return(e1);
}
public CommonModal sendMobileMessage(SendMobileMessage sms)
{
CommonModal e1 = new CommonModal();
SqlConnection conn = new SqlConnection(commonCode.conStr);
SqlCommand cmd = new SqlCommand("Pro_SendMobileMessage", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mobile_No", SqlDbType.NVarChar).Value = sms.mobile_No;
cmd.Parameters.Add("@otp", SqlDbType.NVarChar).Value = GenerateNewRandom();
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = sms.mode;
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
conn.Close();
if (Dt.Rows.Count > 0)
{
e1.ResponseStatus = Dt.Rows[0]["status"].ToString();
e1.ResponseMessage = Dt.Rows[0]["MSG"].ToString();
e1.data = Dt;
}
else
{
e1.ResponseStatus = "False";
e1.ResponseMessage = "Error in c#";
}
return(e1);
}
public CommonModal Onlynumberverifyotp(SendMobileMessage sm)
{
CommonModal e1 = new CommonModal();
if (sm.mode1 == 1)
{
SqlConnection conn = new SqlConnection(commonCode.conStr);
conn.Open();
SqlCommand cmd = new SqlCommand("Pro_LoginCRUD", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@login_Id", SqlDbType.NVarChar).Value = sm.login_Id;
cmd.Parameters.Add("@otp", SqlDbType.NVarChar).Value = sm.otp;
cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = "verifyotp1";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
DataTable Dt = ds.Tables[0];
conn.Close();
if (Dt.Rows[0]["status"].ToString().Equals("True"))
{
CommonModal e2 = new CommonModal();
string encrypt_pw = encryptPassword(sm.passWord);
SqlConnection conn1 = new SqlConnection(commonCode.conStr);
conn1.Open();
SqlCommand cmd1 = new SqlCommand("Pro_LoginCRUD", conn1);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@login_Id", SqlDbType.Int).Value = sm.login_Id;
cmd1.Parameters.Add("@passWord", SqlDbType.NVarChar).Value = encrypt_pw;
cmd1.Parameters.Add("@mode", SqlDbType.NVarChar).Value = "updatepassword1";
int n = (int)cmd1.ExecuteNonQuery();
conn1.Close();
//DataSet ds1 = new DataSet();
//SqlDataAdapter da1 = new SqlDataAdapter();
//da1.SelectCommand = cmd1;
//da1.Fill(ds1);
//DataTable Dt1 = ds1.Tables[0];
//conn1.Close();
e2.ResponseStatus = "True";
e2.ResponseMessage = "Registration success";
e2.data = Dt;
return(e2);
}
else
{
e1.ResponseStatus = "False";
e1.ResponseMessage = "Verification Failed!!";
// e1.data = Dt;
}
return(e1);
}
else
{
e1 = OnlynumberCheckpassword(sm.mobile_No, sm.passWord);
return(e1);
}
}
