public bool CheckIfVendorExists(adminLoginPasswordModel objModel) { bool result = false; try { string sqlstr = "select * from ACRF_VendorDetails where Id=@Id and Password=@Password"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.Parameters.AddWithValue("@Id", objModel.Id); cmd.Parameters.AddWithValue("@Password", Encryption.encrypt(objModel.old_password)); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { result = true; } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(result); }
public string UpdateVendorLoginPassword(adminLoginPasswordModel objModel) { string result = "Error on updating vendor login password!"; try { bool chkres = CheckIfVendorExists(objModel); if (chkres == true) { var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction(); cmd.Transaction = transaction; cmd.Connection = connection; try { string sqlstr = ""; sqlstr = "update ACRF_VendorDetails set Password=@Password, " + " UpdatedBy=@UpdatedBy,UpdatedOn=@UpdatedOn where Id=@Id"; cmd.CommandText = sqlstr; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Id", objModel.Id); cmd.Parameters.AddWithValue("@Password", Encryption.encrypt(objModel.new_password)); cmd.Parameters.AddWithValue("@UpdatedBy", objModel.UpdatedBy); cmd.Parameters.AddWithValue("@UpdatedOn", StandardDateTime.GetDateTime()); cmd.ExecuteNonQuery(); transaction.Commit(); connection.Close(); result = "Vendor Login Password Updated Successfully!"; } catch (Exception ex) { transaction.Rollback(); connection.Close(); Global.ErrorHandlerClass.LogError(ex); result = ex.Message; } } else { result = "Enter Valid Old Password"; } } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(result); }
public IHttpActionResult UpdateVendorLoginPassword(adminLoginPasswordModel objModel) { if (ModelState.IsValid) { string result = ""; if (objModel.confirm_password == objModel.new_password) { objModel.UpdatedBy = ""; result = objAuthVM.UpdateVendorLoginPassword(objModel); } else { result = "New Password and Confirm Password should be same!"; } return(Ok(new { results = result })); } else { return(Ok(new { results = "Enter Mandatory Fields!" })); } }