Exemplo n.º 1
0
 partial void DeleteDepartmentLog(DepartmentLog instance);
Exemplo n.º 2
0
 partial void InsertDepartmentLog(DepartmentLog instance);
Exemplo n.º 3
0
 partial void UpdateDepartmentLog(DepartmentLog instance);
Exemplo n.º 4
0
        public static string send_log(string msg, string depart, string sender, 
            string img1Url,string img2Url,string img3Url)
        {
            string res = "T";
            try
            {
                var db = new BathDbDataContext(connectionString);

                var log = new DepartmentLog();
                log.date = DateTime.Now;
                log.departId = db.Department.FirstOrDefault(x => x.name == depart).id;
                log.msg = msg;
                if (sender != "F")
                    log.sender = db.Employee.FirstOrDefault(x => x.id == sender).name;

                if (img1Url != "F")
                    log.imgUrl = img1Url;
                if (img2Url != "F")
                    log.img2Url = img2Url;
                if (img3Url != "F")
                    log.img3Url = img3Url;

                db.DepartmentLog.InsertOnSubmit(log);
                db.SubmitChanges();
                res = log.id.ToString();
            }
            catch (System.Exception e)
            {
                res = "F";
            }

            return res;
        }