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