public async Task <ActionResult> Create(ChamCong chamCong, KyLuat kyLuat)
{
var model = new ViewModelCC();
model.ListNhanVien = database.NhanViens.ToArray();
model.ListloaiKyLuat = database.LoaiKyLuats.ToArray();
if (ModelState.IsValid)
{
chamCong.Idnv = int.Parse(HttpContext.Session.GetString("IDNV"));
chamCong.Ngay = DateTime.Now;
chamCong.TrangThai = true;
database.Add(chamCong);
await database.SaveChangesAsync();
if (chamCong.Ngay.Hour > 7 || chamCong.Ngay.Hour == 7 && chamCong.Ngay.Minute >= 1)
{
kyLuat.Idnv = int.Parse(HttpContext.Session.GetString("IDNV"));
kyLuat.IdloaiKl = 2;
kyLuat.Ngay = DateTime.Now;
database.Add(kyLuat);
await database.SaveChangesAsync();
}
return(RedirectToAction("Index", "ChamCong"));
}
return(View(model));
}
public async Task <IActionResult> PutChamCong([FromRoute] int id, [FromBody] ChamCong chamcong)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != chamcong.ChamCongId)
{
return(BadRequest());
}
_context.Entry(chamcong).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChamCongExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
if (txtMaNV.Text == null)
{
MessageBox.Show("Bạn phải nhập đầy đủ thông tin!");
return;
}
int b = 0;
long c;
int.TryParse(cbbCa.SelectedIndex.ToString(), out b);
long.TryParse(txtMaNV.Text, out c);
ChamCong cc = new ChamCong(1, dtpNgay.Value, b, c);
ChamCongDAO dao = new ChamCongDAO();
if (!dao.Insert(cc))
{
MessageBox.Show("Sai !");
}
else
{
MessageBox.Show("Thêm thành công!");
}
txtMaNV.Text = "";
}catch (Exception ex)
{
MessageBox.Show("không có sinh ma sinh viên nào");
}
}
public void TaoBangChamCong(List <Employee> dsNV)
{
DateTime dt = (DateTime)dtThang.EditValue;
DateTime minDate = new DateTime(dt.Year, dt.Month, 1);
DateTime maxDate = new DateTime(dt.Year, dt.Month, SoNgayTrongThang());
XPCollection _xpcChamCong = new XPCollection(xpcChamCong, CriteriaOperator.And(new BinaryOperator("Thang", minDate, BinaryOperatorType.GreaterOrEqual),
new BinaryOperator("Thang", maxDate, BinaryOperatorType.LessOrEqual)));
foreach (Employee e in dsNV)
{
foreach (LoaiDuLieuChamCong l in xpcLoaiDuLieuChamCong)
{
CriteriaOperator test = CriteriaOperator.And(
new BinaryOperator("NhanVien", e, BinaryOperatorType.Equal),
new BinaryOperator("LoaiDuLieuChamCong", l, BinaryOperatorType.Equal));
XPCollection a = new XPCollection(_xpcChamCong);
a.Filter = test;
if (a.Count == 0)
{
ChamCong chamcong = new ChamCong();
chamcong.NhanVien = e;
chamcong.LoaiDuLieuChamCong = l;
chamcong.Thang = dt;
xpcChamCong.Add(chamcong);
}
}
}
XpoDefault.Session.Save(xpcChamCong);
}
public async Task <IActionResult> PutChamCong(DateTime id, ChamCong chamCong)
{
if (id != chamCong.NgayChamCong)
{
return(BadRequest());
}
_context.Entry(chamCong).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChamCongExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Edit(int id, [Bind("MaCC,TenNV,Thang,Nam,SoNgayLamTrongThang,TongLuong,MaPB,MaNV")] ChamCong chamCong)
{
if (id != chamCong.MaCC)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(chamCong);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChamCongExists(chamCong.MaCC))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["MaNV"] = new SelectList(_context.NhanViens, "MaNV", "TenNV", chamCong.MaNV);
ViewData["MaPB"] = new SelectList(_context.PhongBans, "MaPB", "TenPB", chamCong.MaPB);
return(View(chamCong));
}
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
db = new QLNSDataContext();
lblmanv.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MANV").ToString();
lbltennv.Text = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "HOTEN").ToString();
backup = db.ChamCongs.SingleOrDefault(x => x.MaNV == lblmanv.Text);
if (backup.SoNgayDiLam == null)
{
backup.SoNgayDiLam = 0;
}
if (backup.SoNgayNghi == null)
{
backup.SoNgayNghi = 0;
}
if (backup.PhuCap == null)
{
backup.PhuCap = 0;
}
;
if (backup.TienThuong == null)
{
backup.TienThuong = 0;
}
if (backup.TienPhat == null)
{
backup.TienPhat = 0;
}
cbphucap.Text = backup.PhuCap.ToString();
lblsnn.Text = backup.SoNgayNghi + " +";
lblsndl.Text = backup.SoNgayDiLam + " +";
}
public ActionResult DeleteConfirmed(string id)
{
ChamCong chamCong = db.ChamCongs.Find(id);
db.ChamCongs.Remove(chamCong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool themChamCong(ChamCong cc)
{
if (!db.ChamCongs.Contains(cc))
{
db.ChamCongs.InsertOnSubmit(cc);
db.SubmitChanges();
return(true);
}
return(false);
}
public void Delete(string Name, DateTime date)
{
QuanLyQuanCaPheEntities quanLyQuanCaPheEntities = new QuanLyQuanCaPheEntities();
var _temp = new ChamCong {
MaChamCong = Find(Name, date)
};
quanLyQuanCaPheEntities.Entry(_temp).State = System.Data.Entity.EntityState.Deleted;
quanLyQuanCaPheEntities.SaveChanges();
}
public ActionResult Edit([Bind(Include = "TenNV,SoNgayLam,SoNgayNghi,LyDoNghi")] ChamCong chamCong)
{
if (ModelState.IsValid)
{
db.Entry(chamCong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chamCong));
}
public IActionResult XoaChamCong(int id)
{
ChamCong delete = context.ChamCong.Where(c => c.Id == id).FirstOrDefault();
if (delete != null)
{
context.ChamCong.Remove(delete);
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "TenNV,SoNgayLam,SoNgayNghi,LyDoNghi")] ChamCong chamCong)
{
if (ModelState.IsValid)
{
db.ChamCongs.Add(chamCong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chamCong));
}
public List <ChamCong> LayDL(DateTime d)
{
List <ChamCong> list = new List <ChamCong>();
DataTable data = DataProvider.Instance.ExecuteQuery("EXEC DSChamCong @Ngay", new object[] { d });
foreach (DataRow item in data.Rows)
{
ChamCong nv = new ChamCong(item);
list.Add(nv);
}
return(list);
}
public List <ChamCong> LayDL()
{
List <ChamCong> list = new List <ChamCong>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from ChamCong");
foreach (DataRow item in data.Rows)
{
ChamCong nv = new ChamCong(item);
list.Add(nv);
}
return(list);
}
public void xoachamcong(string manv)
{
ChamCong chamCong = new ChamCong();
chamCong = data.ChamCongs.Where(t => t.MaNhanVien == manv).FirstOrDefault();
if (chamCong != null)
{
data.ChamCongs.DeleteOnSubmit(chamCong);
data.SubmitChanges();
}
}
public List <ChamCong> TimNV(long d)
{
List <ChamCong> list = new List <ChamCong>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from chamcong where MaNV like @MaNV", new object[] { d });
foreach (DataRow item in data.Rows)
{
ChamCong nv = new ChamCong(item);
list.Add(nv);
}
return(list);
}
public async Task <IActionResult> PostChamCong([FromBody] ChamCong chamcong)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.ChamCongs.Add(chamcong);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetChamCong", new { id = chamcong.ChamCongId }, chamcong));
}
public bool xoaChamCong(int maPC, int thang, int nam)
{
ChamCong b = new ChamCong();
b = db.ChamCongs.Single(a => a.thang == thang && a.nam == nam && a.maPhanCong == maPC);
if (b != null)
{
db.ChamCongs.DeleteOnSubmit(b);
db.SubmitChanges();
return(true);
}
return(false);
}
public async Task <IActionResult> Create([Bind("MaCC,TenNV,Thang,Nam,SoNgayLamTrongThang,TongLuong,MaPB,MaNV")] ChamCong chamCong)
{
if (ModelState.IsValid)
{
_context.Add(chamCong);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MaNV"] = new SelectList(_context.NhanViens, "MaNV", "TenNV", chamCong.MaNV);
ViewData["MaPB"] = new SelectList(_context.PhongBans, "MaPB", "TenPB", chamCong.MaPB);
return(View(chamCong));
}
public bool ThemChamCong(ChamCong cc)
{
try
{
db.ChamCongs.InsertOnSubmit(cc);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool XoaChamCong(int id)
{
try
{
ChamCong cc = (from c in db.ChamCongs where c.IDChamCong == id select c).SingleOrDefault();;
db.ChamCongs.DeleteOnSubmit(cc);
return(true);
}
catch
{
return(false);
}
}
public bool CapNhat(ChamCong item)
{
ChamCongDAL dal = new ChamCongDAL(db);
if (item != null)
{
return(dal.CapNhat(item));
}
else
{
return(false);
}
}
// GET: ChamCong/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChamCong chamCong = db.ChamCongs.Find(id);
if (chamCong == null)
{
return(HttpNotFound());
}
return(View(chamCong));
}
public async Task <ChamCong> Insert(ChamCong chamcong)
{
return(await WithConnection(async c =>
{
await c.InsertAsync(chamcong);
if (chamcong.ChamCongId == 0)
{
throw new Exception("Insert Fail");
}
return chamcong;
}));
}
public bool Them1DongChamCong(string manv, DateTime ngay, string tinhtrang)
{
try
{
ChamCong cc = new ChamCong();
cc.MaNhanVien = manv;
cc.Ngay = ngay;
cc.TinhTrang = tinhtrang;
db.ChamCongs.InsertOnSubmit(cc);
db.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public JsonResult CapNhatDanhSachChamCong(string maNhanVien, string caLamViec, string ngay, string thoiGianVao, string thoiGianRa)
{
var chamCong = chamCongbll.TimKiemChiTietChamCong(maNhanVien, caLamViec, DateTime.Parse(ngay));
int status = 0;
ScriptFunctionsDataContext function = new ScriptFunctionsDataContext();
if (chamCong == null)
{
ChamCong cc = new ChamCong()
{
MaChamCong = function.auto_maChamCong(),
CaLamViec = caLamViec,
ThoiGianRa = TimeSpan.Parse(thoiGianRa),
ThoiGianVao = TimeSpan.Parse(thoiGianVao),
Ngay = DateTime.Parse(ngay),
MaNhanVien = maNhanVien,
};
if (chamCongbll.ThemMoi(cc) == true)
{
status = 1;
}
else
{
status = 2;
}
}
else
{
chamCong.ThoiGianRa = TimeSpan.Parse(thoiGianRa);
chamCong.ThoiGianVao = TimeSpan.Parse(thoiGianVao);
if (chamCongbll.CapNhat(chamCong) == true)
{
status = 3;
}
else
{
status = 4;
}
}
return(Json(new
{
status = status
}, JsonRequestBehavior.AllowGet));
}
private void btnCapNhatKQ_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Cursor = Cursors.WaitCursor;
if (dtThang.EditValue != System.DBNull.Value)
{
DateTime d = DateTime.Parse(dtThang.EditValue.ToString());
for (int j = 0; j < xpcChamCong.Count; j++)
{
ChamCong cc = xpcChamCong[j] as ChamCong;
cc.KetQua = String.Format("{0:0.0}", TinhTong(cc, d.Year, d.Month));
cc.DonVi = str;
}
XpoDefault.Session.Save(xpcChamCong);
xpcChamCong.Reload();
}
Cursor = Cursors.Default;
}
public IActionResult SuaDiem(int id)
{
ChamCong edit = context.ChamCong.Where(c => c.Id == id).FirstOrDefault();
if (edit != null)
{
return(View(
new ChamCongSuaDiem()
{
ChamCong = edit,
TenNhanVien = context.NhanVien.Where(nv => nv.MaNV == edit.MaNV).FirstOrDefault().TenNV
}
));
}
else
{
return(RedirectToAction("Index"));
}
}
public bool Xoa(ChamCong item)
{
ChamCongDAL dal = new ChamCongDAL(db);
try
{
if (item != null)
{
return(dal.Xoa(item));
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region Variables
var loggedIn = Security.IsAuthenticated();
var Id = Request["Id"];
var STTBX = Request["STTBX"];
var STTALL = Request["STTALL"];
var NgayXuatBen = Request["NgayXuatBen"];
var XE_BienSo = Request["XE_BienSo"];
var XE_ID = Request["XE_ID"];
var LAIXE_Ten = Request["LAIXE_Ten"];
var LAIXE_ID = Request["LAIXE_ID"];
var DONVI_Ten = Request["DONVI_Ten"];
var DI_Ten = Request["DI_Ten"];
var DEN_Ten = Request["DEN_Ten"];
var GioXuatBen = Request["GioXuatBen"];
var XeThayThe_BienSo = Request["XeThayThe_BienSo"];
var XeThayThe_ID = Request["XeThayThe_ID"];
var PHI_BenBai = Request["PHI_BenBai"];
var PHI_XeDauDem = Request["PHI_XeDauDem"];
var PHI_VeSinhBenBai = Request["PHI_VeSinhBenBai"];
var GiaVe = Request["GiaVe"];
var HoaHongBanVe = Request["HoaHongBanVe"];
var PhiTrenMotVe = Request["PhiTrenMotVe"];
var Ve = Request["Ve"];
var PHI_HoaHongBanVe = Request["PHI_HoaHongBanVe"];
var KhachTruyThu = Request["KhachTruyThu"];
var PHI_KhachTruyThu = Request["PHI_KhachTruyThu"];
var PHI_XeLuuBen = Request["PHI_XeLuuBen"];
var PHI_ChuyenTruyThu = Request["PHI_ChuyenTruyThu"];
var ChuyenTruyThu = Request["ChuyenTruyThu"];
var PHI_TruyThuGiam = Request["PHI_TruyThuGiam"];
var PHI_Khac = Request["PHI_Khac"];
var PHI_Tong = Request["PHI_Tong"];
var PHI_Nop = Request["PHI_Nop"];
var PHI_ConNo = Request["PHI_ConNo"];
var SoChuyenBieuDo = Request["SoChuyenBieuDo"];
var DeNghi = Request["DeNghi"];
var SoChuyenDeNghi = Request["SoChuyenDeNghi"];
var NOIDUNG_Ten = Request["NOIDUNG_Ten"];
var NOIDUNG_ID = Request["NOIDUNG_ID"];
var DANHGIA_Ten = Request["DANHGIA_Ten"];
var DANHGIA_ID = Request["DANHGIA_ID"];
var TRUYTHU_ID = Request["TRUYTHU_ID"];
var DeNghiCuaNhaXe = Request["DeNghiCuaNhaXe"];
var GiaTienDichVuTrongHopDong = Request["GiaTienDichVuTrongHopDong"];
var TongTruyThu = Request["TongTruyThu"];
var GiamTru = Request["GiamTru"];
var ConLai = Request["ConLai"];
var q = Request["q"];
var NgayChamCong = Request["NgayChamCong"];
var XVB_ID = Request["XVB_ID"];
var XeTangCuong = Request["XeTangCuong"];
var PHI_ChiThuBenBai = Request["PHI_ChiThuBenBai"];
var saveType = Request["saveType"];
var hopLe = Request["hopLe"];
var Draff = Request["Draff"];
var YKienQuanLy = Request["YKienQuanLy"];
XeTangCuong = !string.IsNullOrEmpty(XeTangCuong)
? "true"
: "false";
PHI_ChiThuBenBai = !string.IsNullOrEmpty(PHI_ChiThuBenBai)
? "true"
: "false";
var XeThayThe = Request["XeThayThe"];
XeThayThe = !string.IsNullOrEmpty(XeThayThe)
? "true"
: "false";
#endregion
var Inserted = Convert.ToBoolean(Draff);
if (string.IsNullOrEmpty(saveType)) saveType = "";
switch (subAct)
{
case "save":
#region save
/////////////////////////////////////////
// Ý tưởng cơ bản là check số NgayChamCong != Null => Có truy thu.
// Nếu số chuyến đề nghị =0 nghĩa là tự nguyện truy thu. Ngược lại là có phát sinh đề nghị truy thu.
////////////////////////////////////////
if (!loggedIn || !string.IsNullOrEmpty(STTBX) || !string.IsNullOrEmpty(XE_BienSo))
{
var Item = Inserted
? PhoiDal.SelectLastest(Security.CqId.ToString(), true)
: PhoiDal.SelectById(Convert.ToInt64(Id));
if (Inserted && !string.IsNullOrEmpty(Id))
{
Item.ID = Convert.ToInt64(Id);
}
if (!string.IsNullOrEmpty(NgayXuatBen))
{
Item.NgayXuatBen = Convert.ToDateTime(NgayXuatBen, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(XE_ID))
{
Item.XE_ID = Convert.ToInt64(XE_ID);
var xe = XeDal.SelectById(Convert.ToInt64(XE_ID));
Item.DONVI_ID = xe.DONVI_ID;
}
if (!string.IsNullOrEmpty(LAIXE_ID))
{
Item.LAIXE_ID = Convert.ToInt64(LAIXE_ID);
}
if (!string.IsNullOrEmpty(XeThayThe_ID))
{
Item.XeThayThe_ID = Convert.ToInt64(XeThayThe_ID);
}
// PHI
if (!string.IsNullOrEmpty(PHI_BenBai))
{
Item.PHI_BenBai = Convert.ToDouble(PHI_BenBai);
}
if (!string.IsNullOrEmpty(PHI_XeDauDem))
{
Item.PHI_XeDauDem = Convert.ToDouble(PHI_XeDauDem);
}
if (!string.IsNullOrEmpty(PHI_VeSinhBenBai))
{
Item.PHI_VeSinhBenBai = Convert.ToDouble(PHI_VeSinhBenBai);
}
if (!string.IsNullOrEmpty(GiaVe))
{
Item.GiaVe = Convert.ToDouble(GiaVe);
}
if (!string.IsNullOrEmpty(Ve))
{
Item.Ve = Convert.ToInt16(Ve);
}
if (!string.IsNullOrEmpty(PHI_HoaHongBanVe))
{
Item.PHI_HoaHongBanVe = Convert.ToDouble(PHI_HoaHongBanVe);
}
// Truy thu
if (!string.IsNullOrEmpty(KhachTruyThu))
{
Item.KhachTruyThu = Convert.ToInt16(KhachTruyThu);
}
if (!string.IsNullOrEmpty(PHI_KhachTruyThu))
{
Item.PHI_KhachTruyThu = Convert.ToDouble(PHI_KhachTruyThu);
}
if (!string.IsNullOrEmpty(PHI_XeLuuBen))
{
Item.PHI_XeLuuBen = Convert.ToDouble(PHI_XeLuuBen);
}
if (!string.IsNullOrEmpty(ChuyenTruyThu))
{
Item.ChuyenTruyThu = Convert.ToInt16(ChuyenTruyThu);
}
if (!string.IsNullOrEmpty(PHI_ChuyenTruyThu))
{
Item.PHI_ChuyenTruyThu = Convert.ToDouble(PHI_ChuyenTruyThu);
}
if (!string.IsNullOrEmpty(PHI_TruyThuGiam))
{
Item.PHI_TruyThuGiam = Convert.ToDouble(PHI_TruyThuGiam);
}
if (!string.IsNullOrEmpty(PHI_Khac))
{
Item.PHI_Khac = Convert.ToDouble(PHI_Khac);
}
Item.PHI_ChiThuBenBai = Convert.ToBoolean(PHI_ChiThuBenBai);
Item.XeThayThe = Convert.ToBoolean(XeThayThe);
Item.XeTangCuong = Convert.ToBoolean(XeTangCuong);
Item.CQ_ID = Security.CqId;
Item.PhiMotChuyenTruyThu = Item.PHI_ChiThuBenBai
? Item.PHI_BenBai
: (Item.PHI_HoaHongBanVe + Item.PHI_BenBai);
Item.NgayCapNhat = DateTime.Now;
if (!string.IsNullOrEmpty(PHI_Tong))
{
Item.PHI_Tong = Convert.ToDouble(PHI_Tong);
}
// !imporant giả định là cứ cấp phơi mặc định nộp đủ
if (!string.IsNullOrEmpty(PHI_Tong))
{
Item.PHI_Nop = Item.PHI_Tong;
}
//if (!string.IsNullOrEmpty(PHI_ConNo))
//{
// Item.PHI_ConNo = Convert.ToDouble(PHI_ConNo);
//}
// Trong trường hợp chỉ tiến hành Truy thu
if (saveType.ToLower().Contains("truythu"))
{
Item.PHI_Tong = Item.PhiMotChuyenTruyThu * Item.ChuyenTruyThu;
Item.PHI_Nop = Item.PHI_Tong;
}
Item.Draff = false;
if (Inserted)
{
Item.Username = Security.Username;
Item.NgayTao = DateTime.Now;
Item.RowId = Guid.NewGuid();
//Update Ca làm việc
var giaoCa = GiaoCaDal.Current(Security.CqId, Security.Username);
Item.GIAOCA_ID = giaoCa.ID;
giaoCa.TongSoPhoi += 1;
giaoCa.DoanhThu += Item.PHI_Tong;
giaoCa.NgayCapNhat = DateTime.Now;
GiaoCaDal.Update(giaoCa);
}
Item = PhoiDal.Update(Item);
var chamCong = new ChamCong();
if (Inserted)
{
if (!saveType.ToLower().Contains("truythu")) // Trong trường hợp không truy thu
{
// Thêm chấm công mới
short loaiChamCong = 1;
if (hopLe == "0") loaiChamCong = 2;
chamCong.Loai = loaiChamCong;
chamCong.Duyet = true;
chamCong.Ngay = new DateTime(Item.NgayXuatBen.Year, Item.NgayXuatBen.Month, Item.NgayXuatBen.Day);
chamCong.PHOI_ID = Item.ID;
chamCong.XE_ID = Item.XE_ID;
chamCong.CQ_ID = Security.CqId;
chamCong.TrangThaiNo = 0;
chamCong.NgayCapNhat = DateTime.Now;
chamCong.Username = Security.Username;
chamCong.NgayTao = DateTime.Now;
chamCong.RowId = Guid.NewGuid();
chamCong.Draff = false;
ChamCongDal.Insert(chamCong);
}
}
var idTruyThuNull = string.IsNullOrEmpty(TRUYTHU_ID);
var truyThu = idTruyThuNull ? TruyThuDal.SelectLastest(Security.CqId) : TruyThuDal.SelectById(Convert.ToInt64(TRUYTHU_ID));
if (!string.IsNullOrEmpty(DANHGIA_ID))
{
truyThu.DANHGIA_ID = new Guid(DANHGIA_ID);
}
if (!string.IsNullOrEmpty(NOIDUNG_ID))
{
truyThu.NOIDUNG_ID = new Guid(NOIDUNG_ID);
}
if (!string.IsNullOrEmpty(SoChuyenDeNghi))
{
truyThu.SoChuyenDeNghi = Convert.ToInt16(SoChuyenDeNghi);
}
truyThu.SoChuyenThieu = Item.ChuyenTruyThu;
truyThu.TongTruyThu = Item.PHI_ChuyenTruyThu;
truyThu.Duyet = truyThu.SoChuyenDeNghi == 0;
truyThu.CQ_ID = Security.CqId;
truyThu.PHOI_ID = Item.ID;
truyThu.DeNghiCuaNhaXe = DeNghiCuaNhaXe;
truyThu.PHOI_ID = Item.ID;
truyThu.XE_ID = Item.XE_ID;
truyThu.DeNghi = truyThu.SoChuyenDeNghi != 0;
truyThu.YKienQuanLy = YKienQuanLy;
if (truyThu.DeNghi)
{
truyThu.TrangThai = 1;
}
else
{
truyThu.TrangThai = 0;
}
truyThu.NgayCapNhat = DateTime.Now;
if(idTruyThuNull)
{
truyThu.Username = Security.Username;
truyThu.NgayTao = DateTime.Now;
truyThu.RowId = Guid.NewGuid();
truyThu.NguoiLap = Security.Username;
truyThu = TruyThuDal.Insert(truyThu);
}
else
{
truyThu = TruyThuDal.Update(truyThu);
ChamCongDal.DeleteByTruyThuId(Convert.ToInt64(TRUYTHU_ID));
}
var chamCongByPhoiId = ChamCongDal.SelectByPhoiId(Item.ID);
foreach (var item in chamCongByPhoiId)
{
item.Tien = Item.PhiMotChuyenTruyThu;
item.XE_ID = Item.XE_ID;
item.TRUYTHU_ID = truyThu.ID;
item.NgayCapNhat = DateTime.Now;
//item.Draff = false;
ChamCongDal.Update(item);
}
// Xử lý phần XeVaoBen
if (!string.IsNullOrEmpty(XVB_ID))
{
var xvb = XeVaoBenDal.SelectById(Convert.ToInt64(XVB_ID));
xvb.NgayDuyetPhoi = xvb.NgayCapNhat = DateTime.Now;
xvb.NguoiDuyetPhoi = Security.Username;
xvb.PHOI_ID = Item.ID;
xvb.Tien = Item.PHI_Tong;
xvb.TrangThai = 400;
if (truyThu.SoChuyenDeNghi > 0 && !truyThu.Duyet) // Có đề nghị truy thu và truy thu này chưa duyệt
{
xvb.TrangThai = 500; // Chờ duyệt truy thu
}
xvb.TRUYTHU_ID = truyThu.ID;
XeVaoBenDal.Update(xvb);
}
else
{
var xvb = new XeVaoBen {TrangThai = 400};
xvb.NgayDuyetPhoi = xvb.NgayCapNhat = DateTime.Now;
xvb.NguoiDuyetPhoi = Security.Username;
xvb.PHOI_ID = Item.ID;
xvb.XE_ID = Item.XE_ID;
xvb.Loai = 300;
xvb.Username = Security.Username;
xvb.CQ_ID = Security.CqId;
xvb.TrangThai = 400;
xvb.Tien = Item.PHI_Tong;
if (truyThu.SoChuyenDeNghi > 0 && !truyThu.Duyet) // Có đề nghị truy thu và truy thu này chưa duyệt
{
xvb.TrangThai = 500; // Chờ duyệt truy thu
}
xvb.TRUYTHU_ID = truyThu.ID;
XeVaoBenDal.Insert(xvb);
}
rendertext(Item.ID.ToString());
}
rendertext("0");
break;
#endregion
case "getLatest":
#region getLatest
if (loggedIn)
{
var Item = PhoiDal.SelectLastest(Security.CqId.ToString());
rendertext(string.Format("({0})", JavaScriptConvert.SerializeObject(Item)));
}
rendertext("-1");
break;
#endregion
case "remove":
#region remove
if (loggedIn)
{
var Item = PhoiDal.SelectById(Convert.ToInt32(Id));
if (Item.Username == Security.Username)
{
PhoiDal.DeleteById(Item.ID);
rendertext("0");
}
}
rendertext("-1");
break;
#endregion
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var loggedIn = Security.IsAuthenticated();
var Id = Request["Id"];
var XE_ID = Request["XE_ID"];
var PHOI_ID = Request["PHOI_ID"];
var NgayXuatBen = Request["NgayXuatBen"];
var Ngay = Request["Ngay"];
var TangCuong = Request["TangCuong"];
var PhoiId = Request["PhoiId"];
var CHAMCONG_ID = Request["CHAMCONG_ID"];
var CHAMCONG_GhiChu = Request["CHAMCONG_GhiChu"];
var CHAMCONG_Tien = Request["CHAMCONG_Tien"];
var CHAMCONG_TrangThaiNo = Request["CHAMCONG_TrangThaiNo"];
var ChamCongTruyChuCkb = Request["ChamCongTruyChuCkb"];
var GhiChu = Request["GhiChu"];
var Loai = Request["Loai"];
Loai = string.IsNullOrEmpty(Loai)
? "4"
: "3";
if (string.IsNullOrEmpty(NgayXuatBen)) NgayXuatBen = DateTime.Now.ToString("dd/MM/yyyy");
var q = Request["q"];
switch (subAct)
{
case "BangChamCongTheoXe":
#region BangChamCongTheoXe
if(!string.IsNullOrEmpty(XE_ID))
{
using(var con = DAL.con())
{
var month = DateTime.Now.Month;
var year = DateTime.Now.Year;
var prevMonth = month == 1 ? 12 : month - 1;
var tuNgay = new DateTime(year, prevMonth, 1);
var Xe = XeDal.SelectById(con, Convert.ToInt64(XE_ID));
var loaiBieuDo = LoaiBieuDoDal.SelectById(con, Xe.BIEUDO_ID);
var chamCongList = ChamCongDal.SelectByXeTuNgay(con, PHOI_ID, tuNgay.ToString("dd/MM/yyyy"), Xe.ID);
var chamCongListCurrent = new List<ChamCong>();
var phoi = new Phoi() { XE_ID = Xe.ID };
phoi.Xe = Xe;
ChamCongCalendar_View.Item = phoi;
ChamCongCalendar_View.NgayXuatBen = NgayXuatBen;
ChamCongCalendar_View.ListChamCong = chamCongList;
ChamCongCalendar_View.ListChamCongCurrent = chamCongListCurrent;
ChamCongCalendar_View.LoaiBieuDo = loaiBieuDo;
ChamCongCalendar_View.Visible = true;
ChamCongCalendar_View.TuNgay = tuNgay;
ChamCongCalendar_View.DenNgay = DateTime.Now;
}
}
break;
#endregion
case "LuuChamCongDraff":
#region LuuChamCongDraff
if (!string.IsNullOrEmpty(PhoiId) && loggedIn)
{
var item = new ChamCong();
item.PHOI_ID = Convert.ToInt64(PhoiId);
item.Ngay = Convert.ToDateTime(Ngay, new CultureInfo("Vi-vn"));
item.TangCuong = Convert.ToBoolean(TangCuong);
item.Draff = true;
item.NgayTao = DateTime.Now;
item.Username = Security.Username;
item.CQ_ID = Security.CqId;
item.Loai = 3;
item = ChamCongDal.Insert(item);
AddPhoiListItem.Item = item;
AddPhoiListItem.Visible = true;
}
break;
#endregion
case "UpdateChamCongDraff":
#region UpdateChamCongDraff
if (!string.IsNullOrEmpty(Id) && loggedIn)
{
var item = ChamCongDal.SelectById(Convert.ToInt64(Id));
item.GhiChu = GhiChu;
if(!string.IsNullOrEmpty(ChamCongTruyChuCkb))
{
item.Loai = 3;
}
else
{
item.Loai = 2;
}
item.NgayCapNhat = DateTime.Now;
ChamCongDal.Update(item);
}
break;
#endregion
case "XoaChamCongDraff":
#region XoaChamCongDraff
if (!string.IsNullOrEmpty(Id) && loggedIn)
{
ChamCongDal.DeleteById(Convert.ToInt64(Id));
}
break;
#endregion
case "BangCongNoTheoXe":
#region BangCongNoTheoXe
if (!string.IsNullOrEmpty(XE_ID))
{
var chamCongList = ChamCongDal.NoByXeTuNgay(DAL.con(), null, Convert.ToInt64(XE_ID));
ThuNoList.XE_ID = XE_ID;
ThuNoList.List = chamCongList;
ThuNoList.Visible = chamCongList.Any();
}
break;
#endregion
case "updateAjaxTruyThuDuyetKetQua":
#region updateAjaxTruyThuDuyetKetQua
if(loggedIn && !string.IsNullOrEmpty(CHAMCONG_ID))
{
var item = ChamCongDal.SelectById(Convert.ToInt64(CHAMCONG_ID));
if(!string.IsNullOrEmpty(CHAMCONG_Tien))
{
item.Tien = CHAMCONG_Tien.ToMoney();
}
item.TrangThaiNo = Convert.ToInt16(string.IsNullOrEmpty(CHAMCONG_TrangThaiNo) ? 2 : 1);
item.NgayCapNhat = DateTime.Now;
item.GhiChu = CHAMCONG_GhiChu;
item.Loai = Convert.ToInt16(Loai);
item = ChamCongDal.Update(item);
rendertext(item.ID.ToString());
}
rendertext("0");
break;
#endregion
default:
break;
}
}
