public bool themNhatKy(NhatKy objNhatKy)
{
bool isSuccess = false;
SqlConnection conn = null;
conn = DataAccessConnection.getConnection();
conn.Open();
string strQuery = "INSERT INTO nhatky VALUES('"
+ objNhatKy.MaHopDong + "','"
+ objNhatKy.MaPhong + "','"
+ objNhatKy.Cmnd + "',N'"
+ objNhatKy.TenKhachHang + "','"
+ objNhatKy.SoNguoi + "','"
+ objNhatKy.NgayDatPhong + "','"
+ objNhatKy.NgayTraPhong + "','"
+ objNhatKy.SoTien + "','"
+ objNhatKy.MaNhanVien + "')";
SqlCommand command = conn.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = strQuery;
isSuccess = command.ExecuteNonQuery() > 0;
conn.Close();
return(isSuccess);
}
public List <NhatKy> timNhatKyTheoMaHopDong(string maHopDong)
{
List <NhatKy> lstNhatKy = new List <NhatKy>();
SqlConnection conn = null;
conn = DataAccessConnection.getConnection();
conn.Open();
string strQuery = "SELECT mahopdong,maphong,cmnd,tenkhachhang,songuoi,ngaydatphong,ngaytraphong,sotien,manhanvien FROM nhatky WHERE mahopdong LIKE '%" + maHopDong + "%'";
SqlDataReader reader = null;
SqlCommand command = new SqlCommand(strQuery, conn);
reader = command.ExecuteReader();
while (reader.Read())
{
NhatKy objNhatKy = new NhatKy();
objNhatKy.MaHopDong = reader["mahopdong"].ToString();
objNhatKy.MaPhong = reader["maphong"].ToString();
objNhatKy.Cmnd = reader["cmnd"].ToString();
objNhatKy.TenKhachHang = reader["tenkhachhang"].ToString();
objNhatKy.SoNguoi = (int)reader["songuoi"];
objNhatKy.NgayDatPhong = (DateTime)reader["ngaydatphong"];
objNhatKy.NgayTraPhong = (DateTime)reader["ngaytraphong"];
//objNhatKy.SoTien = (float)reader.GetDouble(8);
objNhatKy.SoTien = float.Parse(reader[7].ToString());
objNhatKy.MaNhanVien = reader["manhanvien"].ToString();
lstNhatKy.Add(objNhatKy);
}
conn.Close();
return(lstNhatKy);
}
public float tinhTienThuePhong(NhatKy objNhatKy)
{
float tienPhaiTra = 0;
int soPhutThuePhong = 0;
SqlConnection conn = null;
conn = DataAccessConnection.getConnection();
conn.Open();
string strQuery = "SELECT DATEDIFF(minute,'"
+ objNhatKy.NgayDatPhong + "','" + objNhatKy.NgayTraPhong + "')";
SqlCommand command = conn.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = strQuery;
soPhutThuePhong = (int)command.ExecuteScalar();
conn.Close();
List <Phong> lstPhong = phongRepository.timPhongTheoMaPhong(objNhatKy.MaPhong);
float giaTienPhong = lstPhong[0].GiaTien;
if (soPhutThuePhong < 1)
{
tienPhaiTra = (float)10000;
}
else
{
tienPhaiTra = (giaTienPhong / 60) * soPhutThuePhong;
}
return(tienPhaiTra);
}
private void btnVaoCa_Click(object sender, EventArgs e)
{
//KHOI TAO THC VA LUU TRU
if (nhatKy != null || thucHienCaID == null)
{
return;
}
Ca ca = new Ca();
ca.maCa = thucHienCaID;
ca.thoiGian = "" + DateTime.Now;
ca.maKip = cbKip.Text.Substring(0, cbKip.Text.IndexOf(" - "));
DBCa dbCa = new DBCa();
bool isUpdate = false;
if (dbCa.isExisted(ca.maCa, ca.maKip))
{
DialogResult dlr = MessageBox.Show("Bạn có muon doi kip?", "IceTea Việt", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlr == DialogResult.No)
{
return;
}
isUpdate = true;
}
dbCa.addNewCa(ca, isUpdate);
nhatKy = new NhatKy(thucHienCaID, ca.maKip);
nhatKy.Closed += nhatKy_Closed;
nhatKy.Show();
}
public bool Insert(long c)
{
int result;
NhatKy nv = new NhatKy();
result = DataProvider.Instance.ExecuteNonQuery("exec ThemNK @Ma ", new object[] { c });
return(result > 0);
}
public ActionResult Delete(int[] Id)
{
for (int i = 0; i < Id.Count(); i++)
{
NhatKy objNhatKy = DataProvider.ShopEntities.NhatKies.Find(Id[i]);
DataProvider.ShopEntities.NhatKies.Remove(objNhatKy);
}
DataProvider.ShopEntities.SaveChanges();
return(Json("Tất cả các nhật ký đã được xóa"));
}
public static void XoaNhatKy(int ID)
{
try
{
NhatKy dao = new NhatKy();
dao.XoaNhatKy(ID);
}
catch (SqlException ex)
{
throw ex;
}
}
public static void ThemNhatKy(CNhatKy nk)
{
try
{
NhatKy dao = new NhatKy();
dao.ThemNhatKy(nk);
}
catch (SqlException ex)
{
throw ex;
}
}
public List <NhatKy> LayDL()
{
List <NhatKy> list = new List <NhatKy>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from NhatKy");
foreach (DataRow item in data.Rows)
{
NhatKy nv = new NhatKy(item);
list.Add(nv);
}
return(list);
}
public static DataTable LoadNhatKy()
{
try
{
NhatKy dao = new NhatKy();
return(dao.LoadNhatKy());
}
catch (SqlException ex)
{
throw ex;
}
}
public List <NhatKy> TimKiemNgay(DateTime a)
{
NhatKy nv = new NhatKy();
DataTable data = DataProvider.Instance.ExecuteQuery("EXEC TimNKNgay @ngay", new object[] { a });
List <NhatKy> list = new List <NhatKy>();
foreach (DataRow d in data.Rows)
{
NhatKy nk = new NhatKy(d);
list.Add(nk);
}
return(list);
}
public IHttpActionResult GetNhatKy(int id)
{
NhatKy nhatKy = db.NhatKies.Find(id);
if (nhatKy == null)
{
return(NotFound());
}
if (!isAccess(nhatKy.IDQuanLy))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
return(Ok(nhatKy));
}
public JsonResult Xoa(int id)
{
NhatKy objNhatKy = DataProvider.ShopEntities.NhatKies.Where(p => p.Id == id).First();
if (objNhatKy != null)
{
//Thực hiện xóa
DataProvider.ShopEntities.NhatKies.Remove(objNhatKy);
//Lưu thay đổi
DataProvider.ShopEntities.SaveChanges();
}
// Nhât ký xóa
return(Json(objNhatKy, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult PutNhatKy(int id, NhatKy nhatKy)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != nhatKy.IDNhatKy)
{
return(BadRequest());
}
NhatKy nhatKyBefore = db.NhatKies.Find(id);
if (nhatKyBefore == null)
{
return(NotFound());
}
var tmp = db.Trams.SingleOrDefault(u => u.IDTram == nhatKyBefore.IDTram);
if (!isAccess(tmp.IDQuanLy))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
nhatKyBefore.IDQuanLy = User.Identity.GetUserId();
nhatKyBefore.NoiDung = nhatKy.NoiDung;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!NhatKyExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
Config(filterContext);
if (Access == null)
{
LoginViewModel model = new LoginViewModel();
if (!string.IsNullOrEmpty(_UsernameFieldName))
{
model.UsernameField = _UsernameFieldName;
}
if (!string.IsNullOrEmpty(_PasswordFieldName))
{
model.PasswordField = _PasswordFieldName;
}
if (!string.IsNullOrEmpty(model.UsernameValue) && !string.IsNullOrEmpty(model.PasswordValue))
{
try
{
Access = Access.Login(model.UsernameValue, model.PasswordValue);
return;
}
catch (UnauthorizedAccessException ex)
{
model.Message = ex.Message;
}
catch (Exception ex)
{
model.Message = "Lỗi hệ thống, vui lòng liên hệ quản trị viên để kiểm tra lại thông tin!";
NhatKy.Loi("Người dùng đăng nhập", ex.Message);
}
}
filterContext.Result = View(_ViewPath, model);
OnEnter(null);
}
else
{
OnEnter(Access);
}
}
public IHttpActionResult DeleteNhatKy(int id)
{
NhatKy nhatKy = db.NhatKies.Find(id);
if (nhatKy == null)
{
return(NotFound());
}
if (!isAccess(nhatKy.IDQuanLy))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
var tmp = db.Trams.SingleOrDefault(u => u.IDTram == nhatKy.IDTram);
if (!isAccess(tmp.IDQuanLy))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
db.NhatKies.Remove(nhatKy);
db.SaveChanges();
return(Ok(nhatKy));
}
public IHttpActionResult PostNhatKy(NhatKy nhatKy)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var tmp = db.Trams.SingleOrDefault(u => u.IDTram == nhatKy.IDTram);
if (tmp == null)
{
return(NotFound());
}
if (!isAccess(tmp.IDQuanLy))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
nhatKy.IDQuanLy = User.Identity.GetUserId();
nhatKy.ThoiGian = getDateTime();
db.NhatKies.Add(nhatKy);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = nhatKy.IDNhatKy }, nhatKy));
}
public IHttpActionResult PutTinhTrang(int idNhatKy, Boolean daGiaiQuyet)
{
NhatKy nhatKyBefore = db.NhatKies.Find(idNhatKy);
if (nhatKyBefore == null)
{
return(NotFound());
}
var tmp = db.Trams.SingleOrDefault(u => u.IDTram == nhatKyBefore.IDTram);
if (!isAccess(tmp.IDQuanLy))
{
return(StatusCode(HttpStatusCode.Unauthorized));
}
nhatKyBefore.DaGiaiQuyet = daGiaiQuyet;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!NhatKyExists(idNhatKy))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public float tinhTienThuePhong(NhatKy objNhatKy)
{
return(nhatKyRepository.tinhTienThuePhong(objNhatKy));
}
public bool themNhatKy(NhatKy objNhatKy)
{
return(nhatKyRepository.themNhatKy(objNhatKy));
}
public bool DangNhap()
{
foreach (Form f in MdiChildren)
{
f.Close();
}
if (MdiChildren.Length > 0)
{
return(true);
}
if (!string.IsNullOrEmpty(HeThong.TenDangNhap))
{
NhatKy.Add("Đăng xuất");
}
HeThong.TenDangNhap = string.Empty;
HeThong.ChiNhanhDangNhap = string.Empty;
lblUser.Caption = "(Chưa đăng nhập)";
var a = new ChucNangTableAdapter();
var fDangNhap = new FrmDangNhap();
if (fDangNhap.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
bool isFirsRun = Param.GetValue <bool>("Lần chạy đầu tiên", "Hệ thống", true, false);
NhatKy.Add("Đăng nhập");
MsgBox.ShowWaitForm();
var adChucNang = new ChucNangTableAdapter();
foreach (RibbonPage page in ribbon.Pages)
{
if (page.Visible == false)
{
continue;
}
if (page.Equals(pageTroGiup))
{
continue;
}
var chucnangPage = HeThong.LayChucNang(page.Name, page.Text, string.Empty);
foreach (RibbonPageGroup group in page.Groups)
{
if (group.Visible == false)
{
continue;
}
if (group.Equals(groupHethong_GiaoDien))
{
continue;
}
var chucnangGroup = HeThong.LayChucNang(group.Name, group.Text, page.Name);
if (!chucnangGroup["TenChucNang"].Equals(group.Text) && HeThong.NguoiDungDangNhap.QuanTri)
{
chucnangGroup["TenChucNang"] = group.Text;
a.Update(chucnangGroup);
}
foreach (BarItemLink itemlink in group.ItemLinks)
{
if (itemlink.Item.Visibility == BarItemVisibility.Never)
{
continue;
}
if (itemlink.Item.Equals(btnDoiMatKhau))
{
continue;
}
if (itemlink.Item.Equals(btnRefresh))
{
continue;
}
if (itemlink.Item.Equals(btnKhoaChuongTrinh))
{
continue;
}
var chucnangItem = HeThong.LayChucNang(itemlink.Item.Name, itemlink.Item.Caption, group.Name);
if (!chucnangItem["ChucNangCha"].Equals(group.Name) && HeThong.NguoiDungDangNhap.QuanTri)
{
chucnangItem["ChucNangCha"] = group.Name;
a.Update(chucnangItem);
}
itemlink.Item.Tag = itemlink.Item.Name;
if (HeThong.NguoiDungDangNhap != null)
{
var quyenItem = HeThong.LayPhanQuyen(itemlink.Item.Name, HeThong.TenDangNhap, HeThong.NguoiDungDangNhap.QuanTri);
itemlink.Item.Enabled = quyenItem.TruyCap;
}
}
HeThong.LayPhanQuyen(group.Name, HeThong.TenDangNhap, HeThong.NguoiDungDangNhap.QuanTri);
}
HeThong.LayPhanQuyen(page.Name, HeThong.TenDangNhap, HeThong.NguoiDungDangNhap.QuanTri);
}
a.Dispose();
// HIỆN TÊN NGƯỜI DÙNG
string n = HeThong.TenDangNhap == null ? "[hoasensystem]" : HeThong.TenDangNhap.ToUpper();
lblUser.Caption = string.Format("Xin chào: {0}", n);
if (isFirsRun)
{
Param.SetValue("Lần chạy đầu tiên", false);
}
MsgBox.CloseWaitForm();
return(true);
}
else
{
//Application.ExitThread();
return(false);
}
}
private void FrmMain_FormClosed(object sender, FormClosedEventArgs e)
{
NhatKy.Add("Thoát chương trình");
}
protected override void OnActionExecuting(ActionExecutingContext ctx)
{
base.OnActionExecuting(ctx);
Config(ctx);
if (Access == null)
{
LoginViewModel model = new LoginViewModel();
if (!string.IsNullOrEmpty(_UsernameFieldName))
{
model.UsernameField = _UsernameFieldName;
}
if (!string.IsNullOrEmpty(_PasswordFieldName))
{
model.PasswordField = _PasswordFieldName;
}
if (!string.IsNullOrEmpty(model.UsernameValue) && !string.IsNullOrEmpty(model.PasswordValue))
{
try
{
Access = Access.Login(model.UsernameValue, model.PasswordValue);
ctx.Result = RedirectToRoute(ctx.RouteData.Values);
return;
}
catch (UnauthorizedAccessException ex)
{
model.Message = ex.Message;
}
catch (Exception ex)
{
model.Message = "Lỗi hệ thống, vui lòng liên hệ quản trị viên để kiểm tra lại thông tin!";
NhatKy.Loi("Người dùng đăng nhập", ex.Message);
}
}
ctx.Result = View(_ViewPath, model);
OnEnter(null);
}
else
{
if (AccessCheckingPermission_Enabled)
{
var _ = Url.Content("~");
var __ = Url.Content(Request.Path);
if (_ != __)
{
if (QuanLyTaiKhoan.Context.DB.HT_Quyens.FirstOrDefault(q => q.Rule == __ && q.NhomQuyen == AccessCheckingPermission_GroupPermission) == null)
{
QuanLyTaiKhoan.Context.ThemQuyen(AccessCheckingPermission_GroupPermission, __, __);
}
if (!Access.DuocPhep(__, AccessCheckingPermission_GroupPermission))
{
ctx.Result = AccessCheckingPermission_DenyResult;
}
}
}
OnEnter(Access);
}
}