public ActionResult Create([Bind(Include = "IDSIM,SoDienThoai,NgayDangKy,NgayHetHan,Flag,MaKH")] ThongTinSIM thongTinSIM)
{
if (ModelState.IsValid)
{
db.ThongTinSIMs.Add(thongTinSIM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", thongTinSIM.MaKH);
return(View(thongTinSIM));
}
public ActionResult Create([Bind(Include = "MaHDTC,IDSIM,TuNgay,DenNgay,PhiHangThang,TongTien,NgayXuat,ThanhToan,Flag")] HoaDonTinhCuoc hoaDonTinhCuoc)
{
if (ModelState.IsValid)
{
db.HoaDonTinhCuocs.Add(hoaDonTinhCuoc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDSIM = new SelectList(db.ThongTinSIMs, "IDSIM", "SoDienThoai", hoaDonTinhCuoc.IDSIM);
return(View(hoaDonTinhCuoc));
}
public ActionResult Create([Bind(Include = "ID,IDSIM,TGBD,TGKT,SoPhutSD7h23h,SoPhutSD23h7h")] ChiTietSuDung chiTietSuDung)
{
if (ModelState.IsValid)
{
db.ChiTietSuDungs.Add(chiTietSuDung);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDSIM = new SelectList(db.ThongTinSIMs, "IDSIM", "SoDienThoai", chiTietSuDung.IDSIM);
return(View(chiTietSuDung));
}
public bool ThemThongTinSim(ThongTinSIM thongtin)
{
try
{
ThongTinSIM sim = new ThongTinSIM();
sim.IDSIM = thongtin.IDSIM;
sim.SoDienThoai = thongtin.SoDienThoai;
sim.NgayDangKy = thongtin.NgayDangKy;
sim.NgayHetHan = thongtin.NgayHetHan;
sim.MaKH = thongtin.MaKH;
db.ThongTinSIMs.Add(sim);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ThemHoaDon(HoaDonDangKy hoadon)
{
try
{
HoaDonDangKy hd = new HoaDonDangKy();
ThongTinSIM sim = db.ThongTinSIMs.Find(hoadon.IDSIM);
hd.MaHDDK = hoadon.MaHDDK;
hd.IDSIM = hoadon.IDSIM;
hd.NgayDangKy = hoadon.NgayDangKy;
hd.ChiPhiDangKy = hoadon.ChiPhiDangKy;
sim.Flag = true;
db.HoaDonDangKies.Add(hd);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ThemKhachHang(KhachHang khachhang)
{
try
{
KhachHang kh = new KhachHang();
kh.MaKH = khachhang.MaKH;
kh.ChucVu = khachhang.ChucVu;
kh.CMND = khachhang.CMND;
kh.DiaChi = khachhang.DiaChi;
kh.Email = khachhang.Email;
kh.NgheNghiep = khachhang.NgheNghiep;
kh.TenKH = khachhang.TenKH;
kh.NgayDangKy = khachhang.NgayDangKy;
db.KhachHangs.Add(kh);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool CapNhatThanhToan(int mahd)
{
try
{
HoaDonTinhCuoc hd = db.HoaDonTinhCuocs.Find(mahd);
hd.ThanhToan = true;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ImportFile(string[] data)
{
try
{
foreach (string line in data)
{
int id = db.ChiTietSuDungs.Max(item => item.ID);
decimal sophutSD7h23h = 0;
decimal sophutSD23h7h = 0;
string[] split = line.Split('\t');
DateTime dateBD = DateTime.ParseExact(split[1], "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
DateTime dateKT = DateTime.ParseExact(split[2], "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
DateTime tmp23 = dateBD.Date.AddHours(23);
DateTime tmp7 = dateBD.Date.AddHours(7);
if ((dateBD.Hour < 23 && dateBD.Hour >= 7) && (dateKT.Hour >= 23 || dateKT.Hour < 7))
{
sophutSD23h7h = Math.Round((decimal)(dateKT - tmp23).TotalMinutes);
sophutSD7h23h = Math.Round((decimal)(tmp23 - dateBD).TotalMinutes);
}
else
if (dateBD.Hour < 7 && (dateKT.Hour >= 7 && dateKT.Hour < 23))
{
sophutSD7h23h = Math.Round((decimal)(dateKT - tmp7).TotalMinutes);
sophutSD23h7h = Math.Round((decimal)(tmp7 - dateBD).TotalMinutes);
}
else
if (dateBD.Hour >= 7 && dateKT.Hour < 23)
{
sophutSD7h23h = Math.Round((decimal)(dateKT - dateBD).TotalMinutes);
}
else
{
sophutSD23h7h = Math.Round((decimal)(dateKT - dateBD).TotalMinutes);
}
/*TimeSpan time = dateKT - dateBD;
* decimal phut = Math.Round((decimal)time.TotalMinutes);
*
* if (7 < dateKT.Hour && dateKT.Hour < 24)
* {
* sophutSD7h23h = phut;
* }
* else
* {
* sophutSD23h7h = phut;
* }*/
db.ChiTietSuDungs.Add(new ChiTietSuDung()
{
ID = id + 1, IDSIM = split[0], TGBD = dateBD, TGKT = dateKT, SoPhutSD7h23h = sophutSD7h23h, SoPhutSD23h7h = sophutSD23h7h
});
db.SaveChanges();
}
TinhHoaDonTinhCuoc();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
