/// <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);
}
