public bool SaveControl() { lblError.Text = string.Empty; Conference confToSave = new Conference(); if (UserControlMode == EnumUserControlMode.Edit) { confToSave = ConferenceManager.Load(ConferenceId); } confToSave.Name = txtName.Text; confToSave.Description = txtDescription.Text; confToSave.StartDate = dtStartPicker.SelectedDate.GetValueOrDefault(DateTime.Now); confToSave.EndDate = dtEndPicker.SelectedDate.GetValueOrDefault(DateTime.Now); confToSave.ActivityType = EnumerationsHelper.ConvertFromString<EnumActivityType>(ddlActivties.SelectedValue); if (txtBaseFee.Value.HasValue) { confToSave.BaseFee = (decimal)txtBaseFee.Value.Value; } string error; bool isValid = ConferenceManager.Save(confToSave, out error); lblError.Text = error; return isValid; }
/// <summary> /// Save Conference Entity /// </summary> /// <param name="item">Entity to save</param> /// <param name="errorMessage">Error Message</param> /// <returns>return true if save successfully, else return false</returns> public static bool Save(Conference item, out string errorMessage) { bool isValid = Validate(item, out errorMessage); if (isValid) { ConferenceDao.Save(item); } return isValid; }
/// <summary> /// Saves a Conference to the data store. /// </summary> /// <param name="item">The item to save</param> public static void Save(Conference item) { if (item.IsItemModified) { if (item.ConferenceId == null) { item.ConferenceId = Insert(item); } else { Update(item); } } }
/// <summary> /// Updates a Conference /// </summary> /// <param name="item">The Conference item to save</param> private static void Update(Conference item) { List<SqlParameter> parameters = new List<SqlParameter> { new SqlParameter("@ConferenceId", item.ConferenceId), new SqlParameter("@ActivityTypeId", item.ActivityType), new SqlParameter("@Name", item.Name), new SqlParameter("@BaseFee", item.BaseFee), new SqlParameter("@Description", item.Description), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate) }; DataManager.ExecuteProcedure(ConferencePlusConnectionString, "Conference_Update", parameters); }
/// <summary> /// Inserts a new Conference /// </summary> /// <param name="item">The Conference item to insert</param> /// <returns>The id of the Conference item just inserted</returns> private static int Insert(Conference item) { List<SqlParameter> parameters = new List<SqlParameter> { new SqlParameter("@ActivityTypeId", item.ActivityType), new SqlParameter("@Name", item.Name), new SqlParameter("@BaseFee", item.BaseFee), new SqlParameter("@Description", item.Description), new SqlParameter("@StartDate", item.StartDate), new SqlParameter("@EndDate", item.EndDate) }; return Convert.ToInt32(DataManager.ExecuteScalarProcedure(ConferencePlusConnectionString, "Conference_Insert", parameters)); }
/// <summary> /// Validate Conference Entity /// </summary> /// <param name="item">Entity to validate</param> /// <param name="errorMessage">error message if vlidation failed</param> /// <returns>return true if entity passes validation logic, else return false</returns> public static bool Validate(Conference item, out string errorMessage) { StringBuilder builder = new StringBuilder(); if (item.ActivityType == EnumActivityType.None) { builder.AppendHtmlLine("*Activity type is required"); } if (item.BaseFee == default(decimal)) { builder.AppendHtmlLine("*Base fee is required"); } if (item.Description.IsNullOrWhiteSpace()) { builder.AppendHtmlLine("*Description is required"); } if (!item.EndDate.IsValidWithSqlDateStandards()) { builder.AppendHtmlLine("*End date is required"); } if (!item.StartDate.IsValidWithSqlDateStandards()) { builder.AppendHtmlLine("*Start date is required"); } if (item.Name.IsNullOrWhiteSpace()) { builder.AppendHtmlLine("*Name is required"); } errorMessage = builder.ToString(); return errorMessage.IsNullOrWhiteSpace(); }