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