public bool EditColor(int iId, string sDescription, string sRGB, out string sErrMessage) { try { sErrMessage = ""; dbConection = new SoftBottinBD.SoftBottinDataClassesDataContext(); SoftBottinBD.Color niColors = new SoftBottinBD.Color { Id = iId, Description = sDescription, RGB = sRGB }; var query = from clr in dbConection.Colors where clr.Id.Equals(iId) select clr; foreach (SoftBottinBD.Color clr in query) { clr.Description = niColors.Description; clr.RGB = niColors.RGB; } dbConection.SubmitChanges(); return(true); } catch (Exception ex) { cUtilities.WriteLog(ex.Message, out sErrMsj); sErrMessage = ex.Message; return(false); } }
public bool AddColor(string sDescription, string sRGB, out string sErrMessage) { try { sErrMessage = ""; dbConection = new SoftBottinBD.SoftBottinDataClassesDataContext(); SoftBottinBD.Color niColor = new SoftBottinBD.Color { Description = sDescription, RGB = sRGB }; dbConection.Colors.InsertOnSubmit(niColor); dbConection.SubmitChanges(); return(true); } catch (Exception ex) { cUtilities.WriteLog(ex.Message, out sErrMsj); sErrMessage = ex.Message; return(false); } }