protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e) { try { string id = Convert.ToString(e.CommandArgument); if (!string.IsNullOrEmpty(id)) { EventBLL eventBLL = new EventBLL(); DataTable dt = eventBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id))); if (dt != null) { if (dt.Rows.Count > 0) { string actionStatus = "Updated"; Events evnt = new Events(); evnt.EventId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["EventId"])); evnt.EventCode = Convert.ToString(dt.Rows[0]["EventCode"]); evnt.Title = Convert.ToString(dt.Rows[0]["Title"]); evnt.Slag = Convert.ToString(dt.Rows[0]["Slag"]); evnt.FromDate = Convert.ToDateTime(dt.Rows[0]["FromDate"]); evnt.ToDate = Convert.ToDateTime(dt.Rows[0]["ToDate"]); evnt.Description = Convert.ToString(dt.Rows[0]["Description"]); evnt.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"])); evnt.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"])); evnt.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]); evnt.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]); evnt.LocationId = Convert.ToInt32(dt.Rows[0]["LocationId"]); evnt.UpdatedDate = DateTime.Now; evnt.UpdatedBy = UserInfo; evnt.UpdatedFrom = StationInfo; if (evnt.IsActive) { evnt.IsActive = false; actionStatus = "Deactivated"; } else { evnt.IsActive = true; actionStatus = "Activated"; } if (eventBLL.Update(evnt)) { Alert(AlertType.Success, actionStatus + " successfully."); LoadList(); } else { Alert(AlertType.Error, "Failed to update."); } } } } } catch (Exception) { Alert(AlertType.Error, "Failed to process."); } }
private void SaveAndUpdate() { try { if (string.IsNullOrEmpty(txtTitle.Text)) { Alert(AlertType.Warning, "Enter title."); txtTitle.Focus(); } else if (string.IsNullOrEmpty(txtFromDate.Text)) { Alert(AlertType.Warning, "Select from date."); txtFromDate.Focus(); } else if (string.IsNullOrEmpty(txtToDate.Text)) { Alert(AlertType.Warning, "Select to date."); txtToDate.Focus(); } else if (ddlLocation.SelectedIndex < 1) { Alert(AlertType.Warning, "Select location."); ddlLocation.Focus(); } else { QuaintLibraryManager lib = new QuaintLibraryManager(); string title = Convert.ToString(txtTitle.Text); string slag = lib.ConvertToSlug(title); DateTime fromDate = Convert.ToDateTime(txtFromDate.Text); DateTime toDate = Convert.ToDateTime(txtToDate.Text); string description = Convert.ToString(txtDescription.Text); int locationId = Convert.ToInt32(ddlLocation.SelectedValue); EventBLL eventBLL = new EventBLL(); if (this.ModelId > 0) { DataTable dt = eventBLL.GetById(this.ModelId); Events evnt = new Events(); evnt.EventId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["EventId"])); evnt.EventCode = Convert.ToString(dt.Rows[0]["EventCode"]); evnt.Title = Convert.ToString(dt.Rows[0]["Title"]); evnt.Slag = Convert.ToString(dt.Rows[0]["Slag"]); evnt.FromDate = Convert.ToDateTime(Convert.ToString(dt.Rows[0]["FromDate"])); evnt.ToDate = Convert.ToDateTime(Convert.ToString(dt.Rows[0]["ToDate"])); evnt.Description = Convert.ToString(dt.Rows[0]["Description"]); evnt.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"])); evnt.LocationId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["LocationId"])); evnt.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"])); evnt.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]); evnt.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]); evnt.Title = title.Trim(); evnt.Slag = slag; evnt.FromDate = fromDate; evnt.ToDate = toDate; evnt.Description = description; evnt.LocationId = locationId; evnt.UpdatedDate = DateTime.Now; evnt.UpdatedBy = this.UserInfo; evnt.UpdatedFrom = this.StationInfo; if (eventBLL.Update(evnt)) { this.MultiEntryDisallow = true; Alert(AlertType.Success, "Updated successfully."); ClearFields(); } else { Alert(AlertType.Error, "Failed to update."); } } else { Events evnt = new Events(); evnt.EventCode = this.ModelCode; evnt.Title = title; evnt.Slag = slag; evnt.FromDate = fromDate; evnt.ToDate = toDate; evnt.Description = description; evnt.LocationId = locationId; evnt.IsActive = true; evnt.CreatedDate = DateTime.Now; evnt.CreatedBy = this.UserInfo; evnt.CreatedFrom = this.StationInfo; if (eventBLL.Save(evnt)) { Alert(AlertType.Success, "Saved successfully."); ClearFields(); GenerateCode(); } else { Alert(AlertType.Error, "Failed to save."); } } } } catch (Exception ex) { Alert(AlertType.Error, ex.Message.ToString()); } }