// 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; } }