public Holiday Update(Holiday dataUpdated, ref string msgError)
{
SqlConnection oConn = null;
try
{
oConn = ConnManager.OpenConn();
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
throw;
};
string sql = "UPDATE Holidays SET {0} WHERE HolidayId = " + dataUpdated.HolidayId.ToString();
EnumExtension.setUpdateValues(dataUpdated, "HolidayId", ref sql);
SqlCommand cmd = new SqlCommand(sql, oConn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ConnManager.CloseConn(oConn);
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
msgError = ex.Message;
return(null);
}
Holiday data = Get(dataUpdated.HolidayId, oConn);
ConnManager.CloseConn(oConn);
return(data);
}