// MiG 11/29/2012
public void UpdateLockedStatus(object sender, System.EventArgs e)
{
try
{
int[] usrCount = objUserDA.GetClientUserCountDA(Convert.ToInt32(Session["ClientID"]));
//Loop Through Grid
foreach (GridDataItem item in tgrdUserList.Items)
{
//Set Current Status
string CheckboxStatus = "Active";
//Get User
string strtest = (item["EmailID"].Text);
// Get Checkbox Value
CheckBox LockCheckBox = (CheckBox)item.FindControl("chkLock");
if ((LockCheckBox.Checked))
CheckboxStatus = "Inactive";
// Check if existing value has changed; if so, update database
List<UserBE> objUserBE = new List<UserBE>();
objUserBE = objUserDA.GetUserDetailDA(strtest);
if (objUserBE.Count > 0)
{
if (objUserBE[0].UserStatus != CheckboxStatus)
{
objUserDA.UpdateUserLockedFieldDA(strtest, CheckboxStatus);
ClientDA ObjClientDA = new ClientDA();
AuditLogBE objAuditlog = new AuditLogBE();
objAuditlog.ActionByID = Convert.ToInt32(Session["UserID"]);
objAuditlog.ActionID = Convert.ToInt32(AuditActions.Client_inactive_vs_Active);
objAuditlog.ActionDetail = "Updated user account " + strtest + " status to " + CheckboxStatus;
objAuditlog.ClientID = Convert.ToInt32(Session["ClientID"]);
ObjClientDA.SaveAuditRecord(objAuditlog);
}
}
}
}
catch (Exception ex)
{
throw;
}
}
public void SaveAuditRecord(AuditLogBE objAuditLogBE)
{
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
using (MySqlCommand sqlCmd = new MySqlCommand("spInsertAuditLog", sqlCon))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pActionbyID", objAuditLogBE.ActionByID));
sqlCmd.Parameters.Add(new MySqlParameter("pActionID", objAuditLogBE.ActionID));
sqlCmd.Parameters.Add(new MySqlParameter("pActiondetail", objAuditLogBE.ActionDetail));
sqlCmd.Parameters.Add(new MySqlParameter("pClientID", objAuditLogBE.ClientID));
sqlCmd.Connection.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
