public void UpdateWebinarRegStatus(bool regStatus, int webinarID, int updatedBy) { try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarRegStatusUpdate, sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; sqlCmd.Parameters.Add(new MySqlParameter("@isRegEnabled", regStatus)); sqlCmd.Parameters.Add(new MySqlParameter("@webinarID", webinarID)); sqlCmd.ExecuteNonQuery(); WebinarAuditLog objWebinarAuditLog = new WebinarAuditLog(); objWebinarAuditLog.ActionByID = updatedBy; objWebinarAuditLog.WebinarAction = "Status Change"; objWebinarAuditLog.ActionDetails = "Status updated to " + regStatus.ToString(); objWebinarAuditLog.WebinarID = webinarID; sqlCon.Close(); RecordWebinarAction(objWebinarAuditLog); } } catch (Exception ex) { throw; } }
public void RecordWebinarAction(WebinarAuditLog objWebinarAuditLog) { try { using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString)) { //MySqlCommand sqlCmd = new MySqlCommand(DBQuery.sqlWebinarAuditInsert, sqlCon); MySqlCommand sqlCmd = new MySqlCommand("spAddWebinarLogs", sqlCon); sqlCon.Open(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objWebinarAuditLog.WebinarID)); sqlCmd.Parameters.Add(new MySqlParameter("pWebinarAction", objWebinarAuditLog.WebinarAction)); sqlCmd.Parameters.Add(new MySqlParameter("pActionDetail", objWebinarAuditLog.ActionDetails)); sqlCmd.Parameters.Add(new MySqlParameter("pActionby", objWebinarAuditLog.ActionByID)); sqlCmd.ExecuteNonQuery(); } } catch (Exception ex) { throw; } }