public ActionResult DeleteConfirmed(string id)
{
Ngay ngay = db.Ngays.Find(id);
db.Ngays.Remove(ngay);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void SaveToDatabase()
{
SqlConnection conn = DBUtils.GetDBConnection();
string query = "INSERT INTO HoaDonNhap(MaHoaDonNhap, NgayNhap, MaPhanXuong, MaNhanVienNhap, GhiChu) " +
"VALUES (" + MaHoaDon + ", '" + Ngay.ToString() + "', " + MaPhanXuong + ", " + MaNhanVien + ", N'" + GhiChu + "')";
DBUtils.InsertToDB(conn, query);
}
private void TONGDOANHTHU_Load(object sender, EventArgs e)
{
txttongtien.ReadOnly = true;
groupBox2.Text = "Tổng doanh thu(VNĐ)";
if (Bngay == true)
{
trangthai = "Ngày";
load_dshd_ngay();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Ngày: " + Ngay.ToString();
tinhtongtien(5);
}
else if (Bthang == true)
{
trangthai = "Tháng";
load_dshd_thang();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Tháng: " + Thang.ToString();
tinhtongtien(5);
}
else if (Bnam == true)
{
trangthai = "Năm";
load_dshd_nam();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo Năm: " + Nam.ToString();
tinhtongtien(5);
}
else if (Timcheck == true)
{
trangthai = Tenban;
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.Soban = Tenban;
dg_dshd.DataSource = hd_old_bul.load_timhd_old(hd_old_public);
dinhdangluoi_hd_ban();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn theo " + Tenban;
tinhtongtien(5);
}
else if (Checkten == true)
{
trangthai = Tenban;
HOADON_OLD_PUBLIC hd_old_public = new HOADON_OLD_PUBLIC();
hd_old_public.TENNV = Tenban;
dg_dshd.DataSource = hd_old_bul.load_timhd_old_TENNV(hd_old_public);
dinhdangluoi_hd_ban();
groupBoxTONGDOANHTHU.Text = "Danh sách hóa đơn của nhân viên: " + Tenban;
tinhtongtien(5);
}
else
{
trangthai = "Tất cả các hóa đơn";
dg_dshd.DataSource = hd_old_bul.load_hoadon_old_NOTID();
dinhdangluoi();
groupBoxTONGDOANHTHU.Text = "Danh sách tất cả các hóa đơn";
tinhtongtien(5);
}
}
public ActionResult Edit([Bind(Include = "NgayThang")] Ngay ngay)
{
if (ModelState.IsValid)
{
db.Entry(ngay).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ngay));
}
//FrmLoaiXe7Cho LoaiXe = new FrmLoaiXe7Cho();
public void HoaDonTinhTien_Load(object sender, EventArgs e)
{
txtTuyenDuong.Text = Tuyen.ToString();
txtSoGhe.Text = Ghe.ToString();
txtGiaCuoc.Text = Tien.ToString();
txtSoXe.Text = SoXe.ToString();
txtGioKH.Text = Ngay.ToString();
txtGio.Text = Gio.ToString();
txtHanhKhach.Text = THK.ToString();
txtSDTHK.Text = SDT.ToString();
}
public ActionResult Create([Bind(Include = "NgayThang")] Ngay ngay)
{
if (ModelState.IsValid)
{
db.Ngays.Add(ngay);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ngay));
}
public static List <DonGiaTheoKhoangThoiGian> LayDonGiaMaGiaKetThucNamTrong(Ngay ngay, int maLoaiPhong)
{
DataTable dt = DAL.DataProvider.ExecuseQuery("SELECT * FROM quanlykaraoke.dongia_loaiphong WHERE GioBatDau < '" + ngay.GioKetThuc.ToString() + "' and GioKetThuc > '" + ngay.GioKetThuc.ToString() + "' and Thu = '" + ngay.Thu + "' and MaLoaiPhong = '" + maLoaiPhong + "';");
List <DonGiaTheoKhoangThoiGian> list = new List <DonGiaTheoKhoangThoiGian>();
foreach (DataRow row in dt.Rows)
{
list.Add(new DonGiaTheoKhoangThoiGian(new Gio((TimeSpan)dt.Rows[0]["GioBatDau"]), ngay.GioKetThuc, Convert.ToInt32(dt.Rows[0]["DonGia"])));
}
return(list);
}
public bool Update(Ngay entity)
{
try
{
var gv = db.Ngays.Find(entity.iD);
gv.nam = entity.nam;
db.SaveChanges();
return(true);
}catch (Exception ex)
{
return(false);
}
}
// GET: Ngays/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ngay ngay = db.Ngays.Find(id);
if (ngay == null)
{
return(HttpNotFound());
}
return(View(ngay));
}
public static ThongTinThanhToanTheoNgay TinhTienTheoNgay(Ngay ngay, int maLoaiPhong)
{
ThongTinThanhToanTheoNgay res = new ThongTinThanhToanTheoNgay();
res.listDonGiaTheoKhoangThoiGian.AddRange(ThanhToanDAL.LayDonGiaMaGioBatDauVaGioKetThucNamTrong(ngay, maLoaiPhong));
if (res.listDonGiaTheoKhoangThoiGian.Count == 0)
{
res.listDonGiaTheoKhoangThoiGian.AddRange(ThanhToanDAL.LayTatCaCacDonGiaNamTrongKhoang(ngay, maLoaiPhong));
res.listDonGiaTheoKhoangThoiGian.AddRange(ThanhToanDAL.LayDonGiaMaGioBatDauNamTrong(ngay, maLoaiPhong));
res.listDonGiaTheoKhoangThoiGian.AddRange(ThanhToanDAL.LayDonGiaMaGiaKetThucNamTrong(ngay, maLoaiPhong));
}
foreach (DonGiaTheoKhoangThoiGian donGia_KhoangTG in res.listDonGiaTheoKhoangThoiGian)
{
res.TongThanhTien += Math.Round(Gio.CalcTimeSpan(donGia_KhoangTG.GioBatDau, donGia_KhoangTG.GioKetThuc).TotalHours, 2) * donGia_KhoangTG.DonGia;
}
res.ngay = ngay;
return(res);
}
public DataTable DanhSachBuuGui_CODDen_CaChieu()
{
//Lay tat ca so lieu cua mot buu cuc
db.TaoKetNoi(FileConfigBCCP);
DataSet ds;
ds = db.ChayThuTuc("select B.ToPOSCode,C.ItemCode,C.ServiceCode,B.FromPOSCode,B.MailTripNumber,B.PostBagNumber,B.PostBagTypeCode,A.IncomingDate,A.Year, "
+ "E.BatchCode, E.AcceptancePOSCode, "
+ "E.CustomerCode, E.SenderFullname, E.SenderAddress, E.SenderTel, E.SendingTime, "
+ "E.ReceiverFullname, E.ReceiverAddress, E.ReceiverTel, "
+ "E.Weight, E.WeightConvert, E.SendingContent, D.Value "
+ "from mailtrip A "
+ "inner join PostBag B "
+ "on A.MailtripNumber = B.MailTripNumber and A.StartingCode = B.FromPOSCode and A.DestinationCode = B.ToPOSCode and A.ServiceCode = B.ServiceCode and A.year = B.year "
+ "inner join Dispatch C "
+ "on B.FromPOSCode = C.FromPOSCode and B.ToPOSCode = C.ToPOSCode and B.ServiceCode = C.ServiceCode and B.Year = C.Year and B.PostBagIndex = C.PostBagIndex and B.MailTripNumber = C.MailTripNumber "
+ "inner join ItemVASPropertyValue D "
+ "on D.ItemCode = C.ItemCode "
+ "left join Item E "
+ "on C.ItemCode = E.ItemCode "
+ "where A.destinationcode = '" + SoHieuBuuCuc + "' and convert(nvarchar(10), A.incomingdate, 101) = '" + Ngay.ToString("MM/dd/yyyy") + "' and DATEPART(hour, A.IncomingDate) between 12 and 16 "
+ "and D.PropertyCode = 'Amount' and isnull(D.Value, 0) <> 0");
DataTable dt = ds.Tables[0];
return(dt);
}
public DataTable DanhSachTuiTrongNgay()
{
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("select PostBagNumber as TuiSo " +
"from PostBag " +
"where ServiceCode='" + MaDichVu + "' and FromPOSCode='" + SoHieuBuuCuc + "' and ToPOSCode='" + MaDuongThu + "' and [Year]='" + Ngay.ToString("yyyyMMdd") + "' " +//and [Status]=2 "+
"and MailTripNumber=" + SoChuyen.ToString() +
" order by PostBagNumber desc");
return(ds.Tables[0]);
}
public static List <DonGiaTheoKhoangThoiGian> LayTatCaCacDonGiaNamTrongKhoang(Ngay ngay, int maLoaiPhong)
{
List <DonGiaTheoKhoangThoiGian> list = new List <DonGiaTheoKhoangThoiGian>();
DataTable dt = DAL.DataProvider.ExecuseQuery("SELECT * FROM quanlykaraoke.dongia_loaiphong WHERE GioBatDau >= '" + ngay.GioBatDau.ToString() + "' and GioKetThuc <= '" + ngay.GioKetThuc.ToString() + "' and Thu = '" + ngay.Thu + "' and MaLoaiPhong = '" + maLoaiPhong + "';");
foreach (DataRow row in dt.Rows)
{
list.Add(new DonGiaTheoKhoangThoiGian(new Gio((TimeSpan)row["GioBatDau"]), new Gio((TimeSpan)row["GioKetThuc"]), (double)row["DonGia"]));
}
return(list);
}
public DataTable DanhSachBuuGui_PhanHuongBuuTa()
{
//Lay tat ca so lieu cua mot buu cuc
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("select convert(datetime,A.Year,101) as NgayDong,A.ItemCode as SoHieu,A.MailTripNumber as SoChuyen,A.PostBagIndex SoTui, A.ToPosCode as MaDuongThu, " +
"A.DeliveryRouteCode as MaDuongThuPhat, C.FullName as TenBuuTa, A.FromPOSCode as MaBuuCucNhap,A.Year as NgayDoiSoat " +
"from Dispatch A " +
"left join PostmanDeliveryRoute B " +
"on A.ToPOSCode=B.PostmanCode and A.DeliveryRouteCode=B.DelieveryRouteCode " +
"left join [User] C " +
"on B.PostmanCode=C.Username " +
"where A.FromPOSCode='" + SoHieuBuuCuc + "' and A.[Year] = '" + Ngay.ToString("yyyyMMdd") + "'");
//"where A.DeliveryRouteCode<>'' and A.FromPOSCode='" + SoHieuBuuCuc + "' and A.[Year] = '" + Ngay.ToString("yyyyMMdd") + "'");
return(ds.Tables[0]);
}
public int Insert(Ngay entity)
{
db.Ngays.Add(entity);
db.SaveChanges();
return(entity.iD);
}
public DataTable DanhSachBuuGui_Den()
{
//Lay tat ca so lieu cua mot buu cuc
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("Select DT.Year as NgayDoiSoat,DT.ItemCode SoHieu, A.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, DT.PostBagIndex SoTui,DT.FromPOSCode MaDuongThu, DT.ToPOSCode as MaBuuCucNhap, " +
"A.Weight TrongLuong, isnull(A.WeightConvert,0) TrongLuongQuiDoi,A.POSCode MaBuuCucChapNhan,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
"A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
"A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, '' DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as Chon, 1 TrangThai, Tui.LastUpdatedTime NgayTrangThai " +
"from MailtripTransportPostBag TuiDen " +
"inner join PostBag Tui " +
"on TuiDen.PostBagIndex = Tui.PostBagIndex AND TuiDen.FromPOSCode = Tui.FromPOSCode AND TuiDen.ToPOSCode = Tui.ToPOSCode AND TuiDen.MailtripType = tui.MailTripType AND TuiDen.ServiceCode = Tui.ServiceCode AND TuiDen.Year = Tui.Year AND TuiDen.MailTripNumber = Tui.MailTripNumber " +
"inner join Dispatch DT " +
"on Tui.ServiceCode=DT.ServiceCode and Tui.MailTripNumber=DT.MailTripNumber and Tui.PostBagNumber=DT.PostBagIndex and Tui.FromPOSCode=DT.FromPOSCode and Tui.ToPOSCode=DT.ToPOSCode AND DT.MailtripType = tui.MailTripType " +
"inner join Item A " +
"on DT.ItemCode=A.ItemCode " +
"left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
"on DT.ItemCode=B.ItemCode " +
"left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
"on DT.ItemCode=C.ItemCode " +
"where TuiDen.ToPOSCode='" + SoHieuBuuCuc + "' and TuiDen.BC37Date='" + Ngay.ToString("yyyyMMdd") + "' " +
" order by DT.ToPOSCode,DT.MailTripNumber,DT.PostBagIndex,DT.IndexNumber");
/*ds = db.ChayThuTuc("Select DT.Year as NgayDoiSoat,DT.ItemCode SoHieu, A.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, DT.PostBagIndex SoTui,DT.FromPOSCode MaDuongThu, DT.ToPOSCode as MaBuuCucNhap, " +
* "A.Weight TrongLuong, isnull(A.WeightConvert,0) TrongLuongQuiDoi,A.POSCode MaBuuCucChapNhan,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
* "A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
* "A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, '' DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as Chon, 1 TrangThai, Tui.LastUpdatedTime NgayTrangThai " +
* "from PostBag Tui " +
* "inner join Dispatch DT " +
* "on Tui.ServiceCode=DT.ServiceCode and Tui.MailTripNumber=DT.MailTripNumber and Tui.PostBagNumber=DT.PostBagIndex " +
* "inner join Item A " +
* "on DT.ItemCode=A.ItemCode " +
* "left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
* "on DT.ItemCode=B.ItemCode " +
* "left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
* "on DT.ItemCode=C.ItemCode " +
* "where Tui.ToPOSCode='" + SoHieuBuuCuc + "' and Tui.[Status]=4 and " +
* "year(Tui.LastUpdatedTime)="+Ngay.Year.ToString()+" and month(Tui.LastUpdatedTime)="+Ngay.Month.ToString()+" and day(Tui.LastUpdatedTime)="+Ngay.Day.ToString() +
* " order by DT.ToPOSCode,DT.MailTripNumber,DT.PostBagIndex,DT.IndexNumber");*/
/*ds = db.ChayThuTuc("select DT.Year as NgayDoiSoat,DT.ItemCode SoHieu, A.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, DT.PostBagIndex SoTui,DT.FromPOSCode MaDuongThu, DT.ToPOSCode as MaBuuCucNhap, " +
* "A.Weight TrongLuong, isnull(A.WeightConvert,0) TrongLuongQuiDoi,A.POSCode MaBuuCucChapNhan,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
* "A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
* "A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, '' DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as Chon, 1 TrangThai, convert(datetime,DT.Year,101) NgayTrangThai " +
* "from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
* "left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
* "on A.ItemCode=B.ItemCode " +
* "left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
* "on A.ItemCode=C.ItemCode " +
* "where DT.Year between '" + TuNgay.ToString("yyyyMMdd") + "' and '" + DenNgay.ToString("yyyyMMdd") + "' and DT.ToPOSCode='" + SoHieuBuuCuc + "' " +
* " order by ToPOSCode,DT.MailTripNumber,DT.PostBagIndex,DT.IndexNumber");*/
DataTable dt = ds.Tables[0];
return(dt);
/*ds = new DataSet();
* ds = db.ChayThuTuc("select A.BatchCode SoHieu, A.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, 0 SoTui,DT.FromPOSCode MaDuongThu, DT.ToPOSCode as MaBuuCucNhap, " +
* "sum(A.Weight) TrongLuong, sum(isnull(A.WeightConvert,0)) TrongLuongQuiDoi,A.POSCode MaBuuCucChapNhan,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
* "A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
* "A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, CAST(COUNT(*)as nvarchar(5)) DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as Chon " +
* "from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
* "left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
* "on A.ItemCode=B.ItemCode " +
* "left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
* "on A.ItemCode=C.ItemCode " +
* "where A.BatchCode is not null and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.ToPOSCode='" + SoHieuBuuCuc + "' " +
* "group by A.BatchCode, A.ServiceCode, DT.MailTripNumber,DT.FromPOSCode,A.POSCode,A.CountryCode,A.CustomerCode, A.SenderFullname, B.FreightVAT, " +
* "A.SenderAddress,A.ReceiverFullname, A.ReceiverAddress, A.MainFreight, A.FuelSurchargeFreight, " +
* "A.FarRegionFreight, (isnull(A.SubFreight,0)-isnull(B.Freight,0)), (isnull(A.TotalFreight,0)-isnull(B.Freight,0)),A.VATFreight,A.TotalFreightVAT, C.Value, B.Freight, A.IsDebt " +
* " order by DT.MailTripNumber");
*
* for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
* {
* dt.ImportRow(ds.Tables[0].Rows[i]);
* }
* return dt;*/
}
public DataTable DanhSachBuuGui_COD_DongBuuTa_CaChieu()
{
//Lay tat ca so lieu cua mot buu cuc
db.TaoKetNoi(FileConfigBCCP);
DataSet ds;
ds = db.ChayThuTuc("select C.ItemCode, B.FromPoscode,C.ServiceCode,B.ToPoscode,B.MailTripNumber,B.PostBagNumber,B.PostBagTypeCode,A.IncomingDate,A.Year, "
+ "G.Username PostmanCode, G.FullName, H.DeliverRouteName, "
+ "E.ReceiverFullname, E.ReceiverAddress, E.ReceiverTel, "
+ "E.Weight, E.WeightConvert, E.SendingContent, D.Value "
+ "from mailtrip A "
+ "inner join PostBag B "
+ "on A.MailtripNumber = B.MailTripNumber and A.StartingCode = B.FromPOSCode and A.DestinationCode = B.ToPOSCode and A.ServiceCode = B.ServiceCode and A.year = B.year "
+ "inner join Dispatch C "
+ "on B.FromPOSCode = C.FromPOSCode and B.ToPOSCode = C.ToPOSCode and B.ServiceCode = C.ServiceCode and B.Year = C.Year and B.PostBagIndex = C.PostBagIndex and B.MailTripNumber = C.MailTripNumber "
+ "inner join ItemVASPropertyValue D "
+ "on D.ItemCode = C.ItemCode "
+ "left join Item E "
+ "on C.ItemCode = E.ItemCode "
//+ "inner join PostmanDeliveryRoute F "
//+ "on C.FromPOSCode = F.FromPOSCode AND C.DeliveryRouteCode = F.DelieveryRouteCode and F.PostmanCode=C.ToPOSCode "
+ "inner join dbo.[User] G "
+ "ON C.ToPOSCode = G.Username AND C.FromPOSCode = G.POSCode "
+ "inner join dbo.DeliveryRoute H "
+ "ON C.DeliveryRouteCode = H.DelieveryRouteCode AND C.FromPOSCode = H.FromPOSCode "
+ "where A.StartingCode = '" + SoHieuBuuCuc + "' and convert(nvarchar(10), A.incomingdate, 101) = '" + Ngay.ToString("MM/dd/yyyy") + "' and DATEPART(hour, A.IncomingDate) between 12 and 16 "
+ "and D.PropertyCode = 'Amount' and isnull(D.Value, 0) <> 0 ");
/*ds = db.ChayThuTuc("select C.ItemCode, B.FromPoscode,C.ServiceCode,B.ToPoscode,B.MailTripNumber,B.PostBagNumber,B.PostBagTypeCode,A.IncomingDate,A.Year, "
+ "F.PostmanCode, G.FullName, H.DeliverRouteName, "
+ "E.ReceiverFullname, E.ReceiverAddress, E.ReceiverTel, "
+ "E.Weight, E.WeightConvert, E.SendingContent, D.Value "
+ "from mailtrip A "
+ "inner join PostBag B "
+ "on A.MailtripNumber = B.MailTripNumber and A.StartingCode = B.FromPOCode and A.DestinationCode = B.ToPOSCode and A.ServiceCode = B.ServiceCode and A.year = B.year "
+ "inner join Dispatch C "
+ "on B.FromPOSCode = C.FromPOSCode and B.ToPOSCode = C.ToPOSCode and B.ServiceCode = C.ServiceCode and B.Year = C.Year and B.PostBagIndex = C.PostBagIndex and B.MailTripNumber = C.MailTripNumber "
+ "inner join ItemVASPropertyValue D "
+ "on D.ItemCode = C.ItemCode "
+ "left join Item E "
+ "on C.ItemCode = E.ItemCode "
+
+ "inner join PostmanDeliveryRoute F "
+ "on C.FromPOSCode = F.FromPOSCode AND C.DeliveryRouteCode = F.DelieveryRouteCode and F.PostmanCode=C.ToPOSCode "
+ "inner join dbo.[User] G "
+ "ON F.PostmanCode = G.Username AND F.FromPOSCode = G.POSCode "
+ "inner join dbo.DeliveryRoute H "
+ "ON F.DelieveryRouteCode = H.DelieveryRouteCode AND F.FromPOSCode = H.FromPOSCode "
+ "where A.StartingCode = '" + SoHieuBuuCuc + "' and convert(nvarchar(10), A.incomingdate, 101) = '" + Ngay.ToString("MM/dd/yyyy") + "' and DATEPART(hour, A.IncomingDate) between 12 and 16 "
+ "and D.PropertyCode = 'Amount' and isnull(D.Value, 0) <> 0 ");*/
DataTable dt = ds.Tables[0];
return(dt);
}
public DataTable DanhSachChuyenTrongNgay()
{
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("select MailtripNumber as ChuyenSo " +
"from Mailtrip " +
"where StartingCode='" + SoHieuBuuCuc + "' and DestinationCode='" + MaDuongThu + "' and ServiceCode='" + MaDichVu + "' and [Year]='" + Ngay.ToString("yyyyMMdd") + "' and Status=2 " +
"order by MailtripNumber desc");
return(ds.Tables[0]);
}
public DataTable DanhSachBuuGui_TheoDichVu()
{
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("select DT.ItemCode SoHieu, isnull(A.SendingContent,'') NoiDungBuuGui, DT.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, DT.PostBagIndex SoTui,DT.FromPOSCode MaDuongThu, " +
"A.Weight TrongLuong, isnull(A.WeightConvert,0) TrongLuongQuiDoi,A.ProvinceCode+'0000' MaTinhPhat,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
"A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
"A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, '' DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as Chon " +
"from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
"left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
"on A.ItemCode=B.ItemCode " +
"left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
"on A.ItemCode=C.ItemCode " +
"where A.BatchCode is null and DT.ServiceCode='" + MaDichVu + "' and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.FromPOSCode='" + SoHieuBuuCuc + "' " +
" order by ToPOSCode,DT.MailTripNumber,DT.PostBagIndex,DT.IndexNumber");
DataTable dt = ds.Tables[0];
ds = new DataSet();
ds = db.ChayThuTuc("select A.BatchCode SoHieu, isnull(A.SendingContent,'') NoiDungBuuGui, DT.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, 0 SoTui,DT.FromPOSCode MaDuongThu, " +
"sum(A.Weight) TrongLuong, sum(isnull(A.WeightConvert,0)) TrongLuongQuiDoi,A.ProvinceCode+'0000' MaTinhPhat,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
"A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
"A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, CAST(COUNT(*)as nvarchar(5)) DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as Chon " +
"from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
"left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
"on A.ItemCode=B.ItemCode " +
"left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
"on A.ItemCode=C.ItemCode " +
"where A.BatchCode is not null and DT.ServiceCode='" + MaDichVu + "' and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.FromPOSCode='" + SoHieuBuuCuc + "' " +
"group by A.BatchCode,isnull(A.SendingContent,''), DT.ServiceCode, DT.MailTripNumber,DT.FromPOSCode,A.ProvinceCode+'0000',A.CountryCode,A.CustomerCode, A.SenderFullname, B.FreightVAT, " +
"A.SenderAddress,A.ReceiverFullname, A.ReceiverAddress, A.MainFreight, A.FuelSurchargeFreight, " +
"A.FarRegionFreight, (isnull(A.SubFreight,0)-isnull(B.Freight,0)), (isnull(A.TotalFreight,0)-isnull(B.Freight,0)),A.VATFreight,A.TotalFreightVAT, C.Value, B.Freight, A.IsDebt " +
" order by DT.MailTripNumber");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dt.ImportRow(ds.Tables[0].Rows[i]);
}
return(dt);
}
public DataTable DanhSachBuuGui_TheoDichVu_Luu()
{
db.ChuoiKetNoi = ChuoiKetNoi;
db.TaoKetNoi();
DataSet ds;
ds = db.ChayThuTuc("select DT.ItemCode SoHieu, A.SendingContent NoiDungBuuGui, DT.ServiceCode MaDichVu, DT.MailTripNumber SoChuyen, DT.PostBagIndex SoTui,DT.FromPOSCode MaDuongThu, " +
"A.Weight TrongLuong, isnull(A.WeightConvert,0) TrongLuongQuiDoi,A.POSCode MaTinhPhat,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
"A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
"A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, '' DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, A.IsDebt as No, convert(bit,1,101) as Chon " +
"from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
"left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
"on A.ItemCode=B.ItemCode " +
"left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
"on A.ItemCode=C.ItemCode " +
"where DT.ServiceCode='" + MaDichVu + "' and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.FromPOSCode='" + SoHieuBuuCuc + "' " +
" order by ToPOSCode,DT.MailTripNumber,DT.PostBagIndex,DT.IndexNumber");
DataTable dt = ds.Tables[0];
return(dt);
}
public DataTable DanhSachBuuGui()
{
//Lay tat ca so lieu cua mot buu cuc
//db.ChuoiKetNoi = ChuoiKetNoi;
//db.TaoKetNoi();
db.TaoKetNoi(FileConfigBCCP);
DataSet ds;
ds = db.ChayThuTuc("select DT.ItemCode SoHieu, isnull(A.SendingContent,'') NoiDungBuuGui, DT.ServiceCode MaDichVu, S.ServiceName as TenDichVu, A.ItemTypeCode as LoaiBuuGui,A.AcceptancePOSCode as MaBCChapNhan,SendingTime as NgayGioNhan,DT.ToPOSCode as BuuCucNhanCT, DT.MailTripNumber SoChuyen, DT.PostBagIndex SoTui,DT.FromPOSCode MaDuongThu, " +
"A.Weight TrongLuong, isnull(A.WeightConvert,0) TrongLuongQuiDoi,A.ProvinceCode+'0000' MaTinhPhat,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
"A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
"A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, '' DichVuCongThem, 0 as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,0,101) as GuiLo,cast('' as nvarchar(30)) as SoLo " +
"from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
"left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
"on A.ItemCode=B.ItemCode " +
"left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
"on A.ItemCode=C.ItemCode " +
"left join Service S on A.ServiceCode=S.ServiceCode " +
"where A.BatchCode is null and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.FromPOSCode='" + SoHieuBuuCuc + "' " +
" and A.SendingTime between '" + Ngay.AddDays(-1).ToString("MM/dd/yyyy") + " 14:00:00' and '" + Ngay.ToString("MM/dd/yyyy") + " 23:59:00'" +
" order by ToPOSCode,DT.MailTripNumber,DT.PostBagIndex,DT.IndexNumber");
DataTable dt = ds.Tables[0];
ds = new DataSet();
ds = db.ChayThuTuc("select A.ItemCode SoHieu, isnull(A.SendingContent,'') NoiDungBuuGui, DT.ServiceCode MaDichVu, S.ServiceName as TenDichVu, A.ItemTypeCode as LoaiBuuGui,A.AcceptancePOSCode as MaBCChapNhan,A.SendingTime as NgayGioNhan,DT.ToPOSCode as BuuCucNhanCT, DT.MailTripNumber SoChuyen, 0 SoTui,DT.FromPOSCode MaDuongThu, " +
"(A.Weight) TrongLuong, (isnull(A.WeightConvert,0)) TrongLuongQuiDoi,A.ProvinceCode+'0000' MaTinhPhat,A.CountryCode MaNuocPhat,A.CustomerCode MaKhachHang, A.SenderFullname TenKhachHang, " +
"A.SenderAddress DiaChiKhachHang,A.ReceiverFullname TenNguoiNhan, A.ReceiverAddress DiaChiNguoiNhan, A.MainFreight CuocChinh, A.FuelSurchargeFreight PhuPhiXD, " +
"A.FarRegionFreight PhuPhiVX, (isnull(A.SubFreight,0)-isnull(B.Freight,0)) as CuocCongThem, CAST(''as nvarchar(5)) DichVuCongThem, (isnull(A.TotalFreight,0)-isnull(B.Freight,0)) as TongCuoc,A.VATFreight as VAT,A.TotalFreightVAT as ThanhTien, C.Value SoTienCOD, B.Freight CuocCOD, B.FreightVAT CuocCODVAT, A.IsDebt as No, convert(bit,1,101) as GuiLo,A.BatchCode as SoLo " +
"from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
"left join (select * from ValueAddedServiceItem where ValueAddedServiceCode='COD')B " +
"on A.ItemCode=B.ItemCode " +
"left join (select * from ItemVASPropertyValue where PropertyCode='Amount' and ValueAddedServiceCode='COD') C " +
"on A.ItemCode=C.ItemCode " +
"left join Service S on A.ServiceCode=S.ServiceCode " +
"where A.BatchCode is not null and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.FromPOSCode='" + SoHieuBuuCuc + "' " +
" and A.SendingTime between '" + Ngay.AddDays(-1).ToString("MM/dd/yyyy") + " 14:00:00' and '" + Ngay.ToString("MM/dd/yyyy") + " 23:59:00'" +
//" group by A.BatchCode,isnull(A.SendingContent,''), DT.ServiceCode, DT.MailTripNumber,DT.FromPOSCode,A.ProvinceCode+'0000',A.CountryCode,A.CustomerCode, A.SenderFullname, B.FreightVAT, " +
//"A.SenderAddress,A.ReceiverFullname, A.ReceiverAddress, A.MainFreight, A.FuelSurchargeFreight,A.ItemTypeCode,A.AcceptancePOSCode,A.SendingTime,DT.ToPOSCode, " +
//"A.FarRegionFreight, (isnull(A.SubFreight,0)-isnull(B.Freight,0)), 0,A.VATFreight,A.TotalFreightVAT, C.Value, B.Freight, A.IsDebt " +
" order by DT.MailTripNumber");
DataTable dt1;
dt1 = db.ChayThuTuc("select DT.ServiceCode, A.BatchCode, " +
"(A.MainFreight)/count(*) CuocChinh, (A.FuelSurchargeFreight)/count(*) PhuPhiXD, " +
"(A.FarRegionFreight)/count(*) PhuPhiVX, (isnull(A.SubFreight,0))/count(*) as CuocCongThem, CAST(COUNT(*)as nvarchar(5)) DichVuCongThem, (A.VATFreight)/count(*) as VAT,(A.TotalFreightVAT)/count(*) as ThanhTien " +
"from Dispatch DT inner join Item A on DT.ItemCode=A.ItemCode " +
"left join Service S on A.ServiceCode=S.ServiceCode " +
"where A.BatchCode is not null and DT.Year='" + Ngay.ToString("yyyyMMdd") + "' and DT.FromPOSCode='" + SoHieuBuuCuc + "' " +
" and A.SendingTime between '" + Ngay.AddDays(-1).ToString("MM/dd/yyyy") + " 14:00:00' and '" + Ngay.ToString("MM/dd/yyyy") + " 23:59:00'" +
" group by A.BatchCode,DT.ServiceCode,A.MainFreight,A.FuelSurchargeFreight,A.FarRegionFreight,A.SubFreight,A.TotalFreightVAT,A.VATFreight " +
"order by A.BatchCode").Tables[0];
DataRow drDL, drCL;
string _MaDV = "", _MaLo = "";
if (dt1.Rows.Count > 0)
{
drCL = dt1.Rows[0];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
drDL = ds.Tables[0].Rows[i];
if (_MaLo != drDL["SoLo"].ToString() || _MaDV != drDL["MaDichVu"].ToString())
{
_MaLo = drDL["SoLo"].ToString();
_MaDV = drDL["MaDichVu"].ToString();
drCL = TimCuocLo(_MaLo, _MaDV, dt1);
}
drDL["CuocChinh"] = drCL["CuocChinh"];
drDL["PhuPhiXD"] = drCL["PhuPhiXD"];
drDL["PhuPhiVX"] = drCL["PhuPhiVX"];
drDL["CuocCongThem"] = drCL["CuocCongThem"];
drDL["DichVuCongThem"] = drCL["DichVuCongThem"];
drDL["VAT"] = drCL["VAT"];
drDL["ThanhTien"] = drCL["ThanhTien"];
dt.ImportRow(drDL);
}
}
ChuoiKetNoiChay = db.ChuoiKetNoi;
return(dt);
}
static void Main(string[] args)
{
int Chon;
ThuVien thuvien = new ThuVien();
thuvien.NhapThuVien();
thuvien.NhapHDMuon();
int Temp; // bien dung cho viec quay lai menu
do
{
Console.WriteLine("Cap nhat lai tinh hinh thu vien ");
Console.Write("\n");
thuvien.CapNhatLai();
Console.Write("\n");
//Console.WriteLine("Chuong trinh quan ly thu vien ");
Console.WriteLine("Cac tuy chon: ");
Console.WriteLine(" 1.Dang nhap tai khoan doc gia va su dung ");
Console.WriteLine(" 2.Dang ky tai khoan doc gia moi ");
Console.WriteLine(" 3.Tim kiem thong tin 1 dau sach bat ky ");
Console.WriteLine(" 4.Cac tinh nang thong ke va sap xep thu vien ");
Console.WriteLine(" 5.Xoa hoac them moi sach vao thu vien ");
Console.WriteLine(" 6.Danh sach luong nhan vien thu vien ");
Console.Write("Xin hay nhap vao lua chon: ");
Chon = Convert.ToInt32(Console.ReadLine());
switch (Chon)
{
case 1:
{
int ChonChon;
String Ten_Temp;
Console.WriteLine(" Nhap ten hoac ma doc gia: ");
Ten_Temp = Console.ReadLine();
KiemTra kt = new KiemTra(thuvien.KiemTraViTriNguoiDocTrongListHD);
int ViTriDG_Temp = kt(Ten_Temp);
if (ViTriDG_Temp != -1)
{
Console.WriteLine("Cac tuy chon: ");
Console.WriteLine(" 1.Muon sach ");
Console.WriteLine(" 2.Tra sach ");
Console.WriteLine(" 3.KT thong tin ");
Console.WriteLine(" 4.Nap them tien vao tai khoan ");
Console.WriteLine(" 5.Gia han the thu vien ");
Console.Write("Chon: ");
ChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChon)
{
case 1:
{
if ((thuvien.DSHDMuon[ViTriDG_Temp].SoLuongSachMuon > 10))
{
Console.Write(" Tra sach truoc khi tiep tuc muon, ban da muon du 10 cuon sach ");
int ChonChonChon;
Console.WriteLine(" Ban co muon tra sach ngay:(0 la khong, 1 la co) ");
ChonChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonChon)
{
case 0:
{
break;
}
case 1:
{
Console.WriteLine("Nhap tua sach hoac ma dau sach: ");
string Tua = Console.ReadLine();
Console.WriteLine("Nhap ma quyen sach: ");
int Quyen = Convert.ToInt32(Console.ReadLine());
TraSach ts = new TraSach(thuvien.TraSach);
ts(ViTriDG_Temp, Tua, Quyen);
break;
}
default:
{
Console.WriteLine(" Nhap sai ");
break;
}
}
break;
}
else
{
if ((thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.NgayHetHanThe < thuvien.Today))
{
Console.Write(" Gia han the truoc khi duoc quyen tiep tuc muon ");
// Gia han the
Console.WriteLine("Chon gia han ngay (0 la khong dong y, 1 la dong y) : ");
int ChonChonCHon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonCHon)
{
case 1:
{
XacDinhNgay xd = new XacDinhNgay(thuvien.XacDinhToday);
ThoiGian Today_Temp = xd();
thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.GiaHanThem(Today_Temp);
break;
}
case 0:
{
break;
}
default:
{
Console.WriteLine("Nhap sai");
break;
}
}
}
else
{
if ((thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.TaiKhoan < 10000))
{
Console.Write(" Nap them vao tai khoan truoc khi duoc quyen tiep tuc muon ");
//Nap them tien
Console.WriteLine("Chon nap vao tai khoan ngay (0 la khong dong y, 1 la dong y) : ");
int ChonChonCHon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonCHon)
{
case 1:
{
Console.WriteLine(" Nhap so tien can nap: ");
double Tien = Convert.ToDouble(Console.ReadLine());
Tien nt = new Tien(thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.Tien);
nt(Tien);
break;
}
case 0:
{
break;
}
default:
{
Console.WriteLine("Nhap sai");
break;
}
}
}
}
}
CongViec ms = new CongViec(thuvien.MuonSach);
ms(ViTriDG_Temp);
break;
}
case 2:
{
Console.WriteLine("Nhap tua sach hoac ma dau sach: ");
string Tua = Console.ReadLine();
Console.WriteLine("Nhap ma quyen sach: ");
int Quyen = Convert.ToInt32(Console.ReadLine());
TraSach ts = new TraSach(thuvien.TraSach);
ts(ViTriDG_Temp, Tua, Quyen);
break;
}
case 3:
{
CongViec xd = new CongViec(thuvien.ThongTinNguoiDocTrongHD);
Console.Write("\n\n");
xd(ViTriDG_Temp);
break;
}
case 4:
{
Console.WriteLine(" Nhap so tien can nap: ");
double Tien = Convert.ToDouble(Console.ReadLine());
Tien nt = new Tien(thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.Tien);
nt(Tien);
break;
}
case 5:
{
XacDinhNgay xd = new XacDinhNgay(thuvien.XacDinhToday);
ThoiGian Today_Temp = xd();
thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.GiaHanThem(Today_Temp);
break;
}
default:
{
Console.WriteLine("Nhap sai ");
break;
}
}
}
else
{
int ChonChonChon;
Console.WriteLine(" Chua ton tai tai khoan ");
Console.WriteLine(" 1.Dang ky tai khoan ");
Console.WriteLine(" 2.Thoat ");
Console.Write("Xin moi nhap vao lua chon: ");
ChonChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonChon)
{
case 1:
{
XacDinhNgay xd = new XacDinhNgay(thuvien.XacDinhToday);
ThoiGian Today_Temp = xd();
Ngay dk = new Ngay(thuvien.DangKyTaiKhoanMoi);
dk(Today_Temp);
break;
}
case 2:
{
break;
}
default:
{
Console.WriteLine("Nhap sai ");
break;
}
}
}
break;
}
case 2:
{
XacDinhNgay xd = new XacDinhNgay(thuvien.XacDinhToday);
ThoiGian Today_Temp = xd();
Ngay dk = new Ngay(thuvien.DangKyTaiKhoanMoi);
dk(Today_Temp);
break;
}
case 3:
{
Console.Write("Hay nhap vao ma sach hoac tua sach: ");
string Ma_Temp = Console.ReadLine();
Them t = new Them(thuvien.TimKiemThongTinDauSach);
t(Ma_Temp);
break;
}
case 4:
{
int ChonChon;
Console.WriteLine("Cac lua chon: ");
Console.WriteLine(" 1.Danh sach sach khoa hoc dang trong tinh trang bi muon ");
Console.WriteLine(" 2.Danh sach khoa hoc dang nam trong thu vien ");
Console.WriteLine(" 3.Danh sach giao trinh dang trong tinh trang bi muon ");
Console.WriteLine(" 4.Danh sach giao trinh dang nam trong thu vien ");
Console.WriteLine(" 5.Danh sach doc gia ");
Console.WriteLine(" 6.Danh sach sach co gia tri lon hon 1 so tien cu the ");
Console.WriteLine(" 7.Danh sach nhung cuon sach sap toi han tra");
Console.WriteLine(" 8.Danh sach nhung doc gia sap het han the (duoi 30 ngay ke tu hom nay la het han) ");
Console.WriteLine(" 9.Danh sach nhung doc gia muon nhieu sach nhat ");
Console.WriteLine(" 10.Thong ke so luong sach duoc muon va phan tram so voi so sach ban dau ");
Console.WriteLine(" 11.Sap xep danh sach doc gia theo thu tu tang dan ngay het han the ");
Console.WriteLine(" 12.Xuat ra man hinh danh sach sach giao trinh theo thu tu gia tang dan ");
Console.WriteLine(" 13.Xuat ra man hinh danh sach sap xep doc gia theo thu tu tang dan tong so sach dang muon ");
Console.WriteLine(" 14.Xuat ra man hinh danh sach sach khoa hoc theo thu tu gia giam dan ");
Console.WriteLine(" 15.Xuat ra man hinh danh sach tat ca cac ban hop dong ");
Console.Write(" Chon: ");
ChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChon)
{
case 1:
{
Console.WriteLine("/n Danh sach sach khoa hoc dang trong tinh trang bi muon:");
DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachKHDaDuocMuon);
ds();
break;
}
case 2:
{
Console.WriteLine("/n Danh sach sach khoa hoc dang nam trong thu vien:");
DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachKHNamTrongThuVien);
ds();
break;
}
case 3:
{
Console.WriteLine("/n Danh sach sach giao trinh dang trong tinh trang bi muon:");
DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachGTDaDuocMuon);
ds();
break;
}
case 4:
{
Console.WriteLine("/n Danh sach sach giao trinh dang nam trong thu vien:");
DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachGTNamTrongThuVien);
ds();
break;
}
case 5:
{
Console.WriteLine("/n Danh sach sach doc gia trong thu vien:");
DanhSach ds = new DanhSach(thuvien.XuatRaDanhSachNguoiDoc);
ds();
break;
}
case 6:
{
double tien;
Console.Write("Hay nhap vao so tien: ");
tien = Convert.ToDouble(Console.ReadLine());
Tien t = new Tien(thuvien.SachLonHonTienCuThe);
t(tien);
break;
}
case 7:
{
DanhSach ds = new DanhSach(thuvien.SachLonSapToiHanTra);
ds();
break;
}
case 8:
{
DanhSach ds = new DanhSach(thuvien.NguoiDocSapHetHanThe);
ds();
break;
}
case 9:
{
DanhSach ds = new DanhSach(thuvien.NguoiDocMuonNhieuNhat);
ds();
break;
}
case 10:
{
DanhSach ds = new DanhSach(thuvien.ThongKeSoSach);
ds();
break;
}
case 11:
{
thuvien.SortIncreasingTheThoiGianOfCustomer(0, thuvien.DSNguoiDoc.Count - 1);
DanhSach ds = new DanhSach(thuvien.XuatRaDanhSachNguoiDoc);
ds();
break;
}
case 12:
{
DanhSach ds = (thuvien.SapXepDanhSachSachGTTheoGiaTangDan);
ds();
break;
}
case 13:
{
CongViec cv = new CongViec(thuvien.SapXepNguoiDocTheoSoSachMuonTangDan);
cv(thuvien.DSHDMuon.Count);
break;
}
case 14:
{
DanhSach ds = new DanhSach(thuvien.SapXepDanhSachSachKHTheoGiaGiamDan);
ds();
break;
}
case 15:
{
DanhSach ds = new DanhSach(thuvien.TatCaHopDong);
ds();
break;
}
}
break;
}
case 5:
{
Console.WriteLine("Cac lua chon:");
Console.WriteLine(" 1.Them sach ");
Console.WriteLine(" 2.Xoa bot sach ");
Console.Write("Nhap vao lua chon: ");
int ChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChon)
{
case 1:
{
Console.WriteLine(" Lua chon them sach GT hay sach KH (0 la khoa hoc, 1 la giao trinh): ");
Console.Write(" Chon:");
int ChonChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonChon)
{
case 0:
{
Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
string Ma_Temp = Console.ReadLine();
Them th = new Them(thuvien.ThemSachKH);
th(Ma_Temp);
break;
}
case 1:
{
Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
string Ma_Temp = Console.ReadLine();
Them th = new Them(thuvien.ThemSachGT);
th(Ma_Temp);
break;
}
default:
{
Console.WriteLine("Nhap sai ");
break;
}
}
break;
}
case 2:
{
Console.WriteLine(" Lua chon xoa sach GT hay sach KH (0 la khoa hoc, 1 la giao trinh): ");
Console.Write(" Chon:");
int ChonChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonChon)
{
case 0:
{
Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
string Ma_Temp = Console.ReadLine();
Them th = new Them(thuvien.XoaSachKH);
th(Ma_Temp);
break;
}
case 1:
{
Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
string Ma_Temp = Console.ReadLine();
Them th = new Them(thuvien.XoaSachGT);
th(Ma_Temp);
break;
}
default:
{
Console.WriteLine("Nhap sai ");
break;
}
}
break;
}
default:
{
Console.WriteLine("Nhap sai ");
break;
}
}
break;
}
case 6:
{
DanhSach ds = new DanhSach(thuvien.XuatTatCaThuThu);
ds();
Console.WriteLine(" Nhap them nhan vien(0 la thoat, 1 la nhap): ");
int ChonChonChon = Convert.ToInt32(Console.ReadLine());
switch (ChonChonChon)
{
case 0:
{
break;
}
case 1:
{
thuvien.DangKyThuThuMoi();
break;
}
default:
{
break;
}
}
break;
}
default:
{
Console.WriteLine("Nhap sai ");
break;
}
}
Console.Write("\n Nhan phim so 0 + Enter de ket thuc or Nhan phim so khac 0 + Enter de tro ve Menu: ");
Temp = Convert.ToInt32(Console.ReadLine());
Console.Write("\n\n");
} while (Temp != 0);
}
