public ArrayList UpdateCustomerEmailMobileNumber_Verification([FromBody] MobileEmailVerf Mobj) { if (Mobj.isVerified == 0) { Mobj.VerificationCode = Convert.ToString((new Random()).Next(10000, 99999).ToString()); } return(this.IMobileAppDev.UpdateCustomerEmailMobileNumber_Verification(Mobj)); }
/// <summary> /// S.A.Kiran /// Date : 07/08/2017 /// </summary> /// <param name="Mobj">Obj for Mobj.CustID Customer Loginid </param> /// Mobj.Email Update Customer Email /// Mobj.MobileNumber Mobile Number /// Mobj.VerificationCode Mobile Code /// Mobj.isVerified 0 or 1 /// <param name="spName">[dbo].[usp_EmailmobileUpdate_MobileApp]</param> /// <returns>Array List </returns> public ArrayList UpdateCustomerEmailMobileNumber_Verification(MobileEmailVerf Mobj, string spName) { ArrayList arrayList = new ArrayList(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); DataSet dtAssignSettings = new DataSet(); SqlDataAdapter daParentDetails = new SqlDataAdapter(); try { SqlCommand cmd = new SqlCommand(spName, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_CustID", Mobj.CustID); cmd.Parameters.AddWithValue("@v_Email", Mobj.Email); cmd.Parameters.AddWithValue("@v_MobileNumber", Mobj.MobileNumber); cmd.Parameters.AddWithValue("@i_CountryCode", Mobj.CountryCode); cmd.Parameters.AddWithValue("@v_VerificationCode", Mobj.VerificationCode); cmd.Parameters.AddWithValue("@isVerified", Mobj.isVerified); daParentDetails.SelectCommand = cmd; daParentDetails.Fill(dtAssignSettings); } catch (Exception Ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(Ex.Message), null, null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayListTable(dtAssignSettings)); }
public ArrayList UpdateCustomerEmailMobileNumber_Verification(MobileEmailVerf Mobj) { return(new MobileAppDal().UpdateCustomerEmailMobileNumber_Verification(Mobj, "[dbo].[usp_EmailmobileUpdate_MobileApp]")); }