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));
 }
Example #2
0
        /// <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));
        }
Example #3
0
 public ArrayList UpdateCustomerEmailMobileNumber_Verification(MobileEmailVerf Mobj)
 {
     return(new MobileAppDal().UpdateCustomerEmailMobileNumber_Verification(Mobj, "[dbo].[usp_EmailmobileUpdate_MobileApp]"));
 }