protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
//get event values
Recognition tempRecognition = new Recognition()
{
Id = recognitionId,
Title = txtMRATitle.Text,
Details = ftbMRADetails.Text
};
var errorList = Validaterecognition(tempRecognition);
if (errorList.Count == 0)
{
tempRecognition.Resources = SelectResources.GetSelectedResources();
RecognitionManager.SaveRecognition(tempRecognition);
Helper.GoToMessagePage(string.Format("Recognition {0} saved successfully.", tempRecognition.Title));
}
else
{
lblMsg.Text = Helper.FormatMessageToUL(errorList);
}
}
else
{
lblMsg.Text = Helper.FormatMessageToUL(new List<string>() { Resources.Messages.PageValidationFailed });
}
}
public static int SaveRecognition(Recognition RecognitionToSave)
{
SqlParameter parameter = null;
SqlParameter[] parameters = new SqlParameter[4];
//add parameters
parameter = new SqlParameter("@RecognitionId", System.Data.SqlDbType.Int);
parameter.Value = RecognitionToSave.Id;
parameters[0] = parameter;
parameter = new SqlParameter("@RecognitionTitle", System.Data.SqlDbType.VarChar, 250);
parameter.Value = RecognitionToSave.Title;
parameters[1] = parameter;
parameter = new SqlParameter("@RecognitionDetails", System.Data.SqlDbType.VarChar);
parameter.Value = RecognitionToSave.Details;
parameters[2] = parameter;
parameter = new SqlParameter("@RecognitionResources", System.Data.SqlDbType.NVarChar);
parameter.Value = ConvertRecognitionResourcesToXML(RecognitionToSave.Resources);
parameters[3] = parameter;
MSSQLHandler.CurrentConnectionType = GetConnectionType();
//add parameters
var result = MSSQLHandler.ExecuteNonQuery("SaveRecognition", parameters);
//update cache for events
Helper.ClearCache(Resources.CacheKeys.MasterRecognitions);
return result;
}
protected List<string> Validaterecognition(Recognition valTorecognition)
{
List<string> errorMsg = new List<string>(25);
if (string.IsNullOrEmpty(valTorecognition.Details))
errorMsg.Add(Resources.Messages.RecognitionDetailsMandatory);
//check event duplicate
if ((valTorecognition.Id > 0 && RecognitionManager.GetAllRecognitions().Exists(x => x.Id != valTorecognition.Id && x.Title == valTorecognition.Title)) || (!(valTorecognition.Id > 0) && RecognitionManager.GetAllRecognitions().Exists(x => x.Title == valTorecognition.Title)))
errorMsg.Add(Resources.Messages.EventNameDuplidate);
return errorMsg;
}
