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); } }