/// <summary> /// Ghi log he thong /// </summary> /// <param name="ChucNang">Chuc nang</param> /// <param name="HanhDong">Hanh Dong</param> /// <param name="DoiTuong">Doi tuong</param> /// <param name="NoiDung">Noi dung</param> /// <returns></returns> public static bool NhatKiHeThong(string ChucNang, string HanhDong, string DoiTuong, string NoiDung) { bool status = true; try { using (var db = new QLNHEntities()) { var adminId = (int)HttpContext.Current.Session["admss"]; var adminEmail = (string)HttpContext.Current.Session["admssemail"]; var nhatki = new ANhatKyHeThong(); nhatki.NguoiDung = (string)HttpContext.Current.Session["admssemail"]; nhatki.ThoiGian = DateTime.Now; nhatki.ChucNang = ChucNang; nhatki.HanhDong = HanhDong; nhatki.DoiTuong = DoiTuong; nhatki.NoiDung = NoiDung; db.ANhatKyHeThongs.Add(nhatki); db.SaveChanges(); } } catch (Exception ex) { WriteLog(ex.Message + "\n" + ex.StackTrace); status = false; } return(status); }
public static void UpdateReservation(int id, string name, DateTime start, DateTime end, int resource, int status, int paid) { var table = new DataTable(); using (var db = new QLNHEntities()) { var objexist = db.Reservations.FirstOrDefault(x => x.ReservationId == id); if (objexist != null) { objexist.ReservationStart = start; objexist.ReservationEnd = end; objexist.ReservationName = name; objexist.BanID = resource; objexist.ReservationStatus = status; objexist.ReservationPaid = paid; db.SaveChanges(); } } //using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString)) //{ // con.Open(); // SqlCommand cmd = new SqlCommand("UPDATE [Reservation] SET [ReservationStart] = @start, [ReservationEnd] = @end, [RoomId] = @resource, [ReservationName] = @name, [ReservationStatus] = @status, [ReservationPaid] = @paid WHERE [ReservationId] = @id", con); // cmd.Parameters.AddWithValue("id", id); // cmd.Parameters.AddWithValue("start", start); // cmd.Parameters.AddWithValue("end", end); // cmd.Parameters.AddWithValue("name", name); // cmd.Parameters.AddWithValue("resource", resource); // cmd.Parameters.AddWithValue("status", status); // cmd.Parameters.AddWithValue("paid", paid); // cmd.ExecuteNonQuery(); //} }
public static void CreateReservation(DateTime start, DateTime end, int resource, string name) { var table = new DataTable(); using (var db = new QLNHEntities()) { var obj = new Reservation(); obj.ReservationStart = start; obj.ReservationEnd = end; obj.BanID = resource; obj.ReservationName = name; obj.ReservationStatus = 0; obj.Status = true; db.Reservations.Add(obj); db.SaveChanges(); } //return table; //using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString)) //{ // con.Open(); // SqlCommand cmd = new SqlCommand("INSERT INTO [Reservation] ([ReservationStart], [ReservationEnd], [RoomId], [ReservationName], [ReservationStatus]) VALUES (@start, @end, @resource, @name, 0)", con); // cmd.Parameters.AddWithValue("start", start); // cmd.Parameters.AddWithValue("end", end); // cmd.Parameters.AddWithValue("resource", resource); // cmd.Parameters.AddWithValue("name", name); // cmd.ExecuteNonQuery(); //} }
/// <summary> /// Write log /// </summary> /// <param name="content">Log content</param> public static void WriteLog(string content) { using (QLNHEntities db = new QLNHEntities()) { db.LogErrors.Add(new LogError() { Content = content, Created = DateTime.Now }); db.SaveChanges(); } }
public static void MoveReservation(int id, DateTime start, DateTime end, int resource) { var table = new DataTable(); using (var db = new QLNHEntities()) { var objexist = db.Reservations.FirstOrDefault(x => x.ReservationId == id); if (objexist != null) { objexist.ReservationStart = start; objexist.ReservationEnd = end; objexist.BanID = resource; objexist.ReservationStart = start; db.SaveChanges(); } } }
public static bool Delete(int id) { var table = new DataTable(); using (var db = new QLNHEntities()) { var objexist = db.Reservations.FirstOrDefault(x => x.ReservationId == id); if (objexist != null) { objexist.Status = false; db.SaveChanges(); } } //SqlDataAdapter da = new SqlDataAdapter("DELETE [Reservation] WHERE [ReservationId] = @id", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString); //da.SelectCommand.Parameters.AddWithValue("id", id); //var dt = new DataTable(); //da.Fill(dt); return(true); }