protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { //get event values Gallery tempGallery = new Gallery() { Id = galleryId, Name = txtMGAName.Text, }; var errorList = ValidateGallery(tempGallery); if (errorList.Count == 0) { tempGallery.Resources = SelectResources.GetSelectedResources(); ; GalleryManager.SaveGallery(tempGallery); Helper.GoToMessagePage(string.Format("Gallery {0} saved successfully.", tempGallery.Name)); } else { lblMsg.Text = Helper.FormatMessageToUL(errorList); } } else { lblMsg.Text = Helper.FormatMessageToUL(new List<string>() { Resources.Messages.PageValidationFailed }); } }
protected List<string> ValidateGallery(Gallery valToGallery) { List<string> errorMsg = new List<string>(25); //check event duplicate if ((valToGallery.Id > 0 && GalleryManager.GetAllGalleries().Exists(x => x.Id != valToGallery.Id && x.Name == valToGallery.Name)) || (!(valToGallery.Id > 0) && GalleryManager.GetAllGalleries().Exists(x => x.Name == valToGallery.Name))) errorMsg.Add(Resources.Messages.EventNameDuplidate); return errorMsg; }
public static int SaveGallery(Gallery galleryToSave) { SqlParameter parameter = null; SqlParameter[] parameters = new SqlParameter[3]; //add parameters parameter = new SqlParameter("@GalleryId", System.Data.SqlDbType.Int); parameter.Value = galleryToSave.Id; parameters[0] = parameter; parameter = new SqlParameter("@GalleryName", System.Data.SqlDbType.VarChar, 150); parameter.Value = galleryToSave.Name; parameters[1] = parameter; parameter = new SqlParameter("@GalleryResources", System.Data.SqlDbType.NVarChar); parameter.Value = ConvertGalleryResourcesToXML(galleryToSave.Resources); parameters[2] = parameter; MSSQLHandler.CurrentConnectionType = GetConnectionType(); //add parameters var result = MSSQLHandler.ExecuteNonQuery("SaveGallery", parameters); //update cache for events Helper.ClearCache(Resources.CacheKeys.MasterGalleries); return result; }