public static DataTable GetReservations()
{
var table = new DataTable();
using (var db = new QLNHEntities())
{
var data = db.Reservations.Where(x => x.Status).Select(x => new
{
ReservationStart = x.ReservationStart,
ReservationEnd = x.ReservationEnd,
ReservationId = x.ReservationId,
ReservationName = x.ReservationName,
ReservationPaid = x.ReservationPaid,
BanID = x.BanID,
TrangThai = x.Status ? 1 : 0
}).ToList();
using (var reader = ObjectReader.Create(data))
{
table.Load(reader);
}
}
return(table);
//SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Reservation]", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
//DataTable dt = new DataTable();
//da.Fill(dt);
//return dt;
}
public static DataTable getParent()
{
var table = new DataTable();
using (var db = new QLNHEntities())
{
var objs = db.DMPhongs.Select(x => new
{
PhongID = x.PhongID,
MaTang = x.MaTang,
MaPhong = x.MaPhong,
TenPhong = x.TenPhong
}).ToList();
using (var reader = ObjectReader.Create(objs))
{
table.Load(reader);
}
}
return(table);
//var da = new SqlDataAdapter("SELECT * FROM [Room] WHERE ParrentId is null order by ParrentId", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
//var dt = new DataTable();
//da.Fill(dt);
//return dt;
}
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();
//}
}
public static DataTable GetRoomsByParrent(string parentId)
{
var table = new DataTable();
using (var db = new QLNHEntities())
{
var data = db.DMBans.Where(x => x.MaPhong == parentId).Select(
x => new
{
MaPhong = x.MaPhong,
MaBan = x.MaBan,
TenBan = x.TenBan,
BanID = x.BanID
}).ToList();
using (var reader = ObjectReader.Create(data))
{
table.Load(reader);
}
}
return(table);
//SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Room] WHERE ParrentId = @parentId ", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
//da.SelectCommand.Parameters.AddWithValue("parentId", parentId);
//DataTable dt = new DataTable();
//da.Fill(dt);
//return dt;
}
public static bool ChekSuperAdmin()
{
bool status;
try
{
using (var db = new QLNHEntities())
{
var adminId = (int)HttpContext.Current.Session["admss"];
var adminEmail = (string)HttpContext.Current.Session["admssemail"];
var obj = db.admins.FirstOrDefault(x => x.admin_id == adminId && x.email.Equals(adminEmail) && x.status_id == 1);
if (obj != null && obj.admin_type == 1)
{
status = true;
}
else
{
status = false;
}
}
}
catch (Exception ex)
{
WriteLog(ex.Message + "\n" + ex.StackTrace);
status = false;
}
// hien tai deu vao duoc
status = true;
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();
//}
}
/// <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 String GetCurrentUserName()
{
var userid = Convert.ToInt32(HttpContext.Current.Session["UserID"]);
using (MyProject.Models.QLNHEntities db = new QLNHEntities())
{
return("Nguoi dung");
}
}
public static String GetUserName()
{
var userid = Convert.ToInt32(HttpContext.Current.Session["UserID"]);
using (var db = new QLNHEntities())
{
return("");
}
}
public static bool IsFree(int id, DateTime start, DateTime end, int resource)
{
int count = 0;
using (var db = new QLNHEntities())
{
count = db.Reservations.Count(x => !(x.ReservationEnd <= start || x.ReservationStart >= end) && x.BanID == resource && x.ReservationId == id);
}
return(count == 0);
}
/// <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 bool CheckCity(QLNHEntities db, int cityId)
{
bool b = false;
try
{
}
catch (Exception)
{
b = false;
}
return(b);
}
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);
}
public ActionResult Index(string txtUsername, string txtPassword, string returnUrl = "/HeThong")
{
using (var db = new QLNHEntities())
{
string username = txtUsername.Trim().ToLower();
var obj = db.admins.FirstOrDefault(x => x.email.ToLower() == username);
if (obj != null)
{
if (obj.status_id == 1)
{
if (Common.MaHoa(txtPassword.Trim()).Equals(obj.password))
{
Session["admss"] = obj.admin_id;
Session["admsstype"] = obj.admin_type;
Session["admssemail"] = obj.email;
if (!String.IsNullOrEmpty(returnUrl))
{
//Ghi log login
Common.NhatKiHeThong("Đăng nhập hệ thống", "Đăng nhập", "Login Form", "Đăng nhập hệ thống ");
return(Redirect(returnUrl));
}
else
{
return(Redirect("/HeThong"));
}
}
else
{
ViewBag.Alert = "Username or password is wrong";
}
}
else
{
ViewBag.Alert = "This account is locked";
}
}
else
{
ViewBag.Alert = "Username or password is wrong";
}
}
return(View());
}
public static DataRow GetReservation(int id)
{
var table = new DataTable();
using (var db = new QLNHEntities())
{
var data = db.Reservations.Where(x => x.Status && x.ReservationId == id).Select(x => new
{
ReservationStart = x.ReservationStart,
ReservationEnd = x.ReservationEnd,
ReservationId = x.ReservationId,
ReservationName = x.ReservationName,
BanID = x.BanID,
TrangThai = x.Status ? 1 : 0
}).ToList();
using (var reader = ObjectReader.Create(data))
{
table.Load(reader);
}
}
if (table.Rows.Count > 0)
{
return(table.Rows[0]);
}
return(null);
//SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Reservation] WHERE [ReservationId] = @id", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
//da.SelectCommand.Parameters.AddWithValue("id", id);
//DataTable dt = new DataTable();
//da.Fill(dt);
//if (dt.Rows.Count > 0)
//{
// return dt.Rows[0];
//}
//return null;
}
public static DataTable GetRooms()
{
var table = new DataTable();
using (var db = new QLNHEntities())
{
var data = db.DMBans.Where(x => x.TrangThai).Select(x => new
{
TenBan = x.TenBan,
BanID = x.BanID,
}).ToList();
using (var reader = ObjectReader.Create(data))
{
table.Load(reader);
}
}
return(table);
//SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Room] where ParrentId is not null order by [RoomName]", ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString);
//DataTable dt = new DataTable();
//da.Fill(dt);
//return dt;
}
