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();
}
