Пример #1
0
        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);
            }
        }
Пример #2
0
        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);
            }
        }