public void ThemSIM(string tensim, string sosim, string hddky) { var res = Convert.ToInt32(hddky); SIM sim = new SIM(); sim.TenSim = tensim; sim.SoSim = sosim; sim.HoaDonDangKyID = res; sim.Flag = true; db.SIMs.Add(sim); db.SaveChanges(); }
public void ThemKH(string tenkh, string cmnd, string nghenghiep, string chucvu, string diachi, string email) { KhachHang kh = new KhachHang(); kh.TenKH = tenkh; kh.CMND = cmnd; kh.NgheNghiep = nghenghiep; kh.ChucVu = chucvu; kh.DiaChi = diachi; kh.Email = email; kh.Flag = true; db.KhachHangs.Add(kh); db.SaveChanges(); }
public static void docFile() { db.Database.ExecuteSqlCommand("TRUNCATE TABLE [FileLogSIM]"); string[] lines = System.IO.File.ReadAllLines(@"C:\test\test.txt"); foreach (string line in lines) { // Use a tab to indent each line of the file. string[] split = line.Split('\t'); DateTime dateBD = DateTime.ParseExact(split[1], "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); DateTime dateKT = DateTime.ParseExact(split[2], "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); db.FileLogSIMs.Add(new FileLogSIM() { SIMID = Convert.ToInt32(split[0]), ThoiGianBD = dateBD, ThoiGianKT = dateKT }); db.SaveChanges(); } }
public void ThemHDDK(string makh, string ngaydk, string chiphi, string tttt) { HoaDonDangKy hd = new HoaDonDangKy(); var res1 = Convert.ToInt32(makh); var res2 = Convert.ToInt32(chiphi); hd.KhachHangID = res1; hd.NgayDK = Convert.ToDateTime(ngaydk); hd.ChiPhiDK = res2; if (tttt == "True") { hd.TinhTrangThanhToan = true; } else { hd.TinhTrangThanhToan = false; } hd.Flag = true; db.HoaDonDangKies.Add(hd); db.SaveChanges(); }