public static List <CHITIETSD> LoadCTSD()
{
QLCDTEntities db = new QLCDTEntities();
var result = (
from t in db.CHITIETSDs
select new
{
ID = t.ID,
IDSIM = t.IDSIM,
TGBD = t.TGBD,
TGKT = t.TGKT,
SOPHUTSD = t.SOPHUTSD,
CUOCPHI = t.CUOCPHI
}).ToList();
List <CHITIETSD> listReturn = new List <CHITIETSD>();
foreach (var item in result)
{
CHITIETSD kh_list = new CHITIETSD();
kh_list.ID = item.ID;
kh_list.IDSIM = item.IDSIM;
kh_list.TGBD = item.TGBD;
kh_list.TGKT = item.TGKT;
kh_list.SOPHUTSD = item.SOPHUTSD;
kh_list.CUOCPHI = item.CUOCPHI;
listReturn.Add(kh_list);
}
return(listReturn);
}
private void btnSave_Click(object sender, EventArgs e)
{
string[] t = tbData.Text.Split('\n');
ChiTietSuDungBUS bus = new ChiTietSuDungBUS();
try
{
foreach (string s in t)
{
string[] parts = s.Trim().Split('\t');
CHITIETSD ctsd = new CHITIETSD();
ctsd.IDSIM = parts[0];
ctsd.TGBD = DateTime.Parse(parts[1]);
ctsd.TGKT = DateTime.Parse(parts[2]);
ctsd.SOPHUTSD = FunctionsBUS.SoPhut(parts[1], parts[2]);
ctsd.CUOCPHI = FunctionsBUS.TinhCuoc(parts[1], parts[2]);
bus.AddCTSD(ctsd);
}
if (callback != null)
{
callback();
}
MessageBox.Show("Thêm danh sách cuộc gọi thành công", "Thông báo!");
}
catch
{
MessageBox.Show("Không thêm được", "Thông báo!");
}
}
public void DeleteCTSD(int id)
{
CHITIETSD t = new CHITIETSD();
t = db.CHITIETSDs.Single(c => c.ID == id);
db.CHITIETSDs.Remove(t);
db.SaveChanges();
}
public void EditCTSD(CHITIETSD t)
{
this.tts = (from c in db.CHITIETSDs
where c.ID == t.ID
select c).Single();
this.tts.ID = t.ID;
this.tts.TGBD = t.TGBD;
this.tts.TGKT = t.TGKT;
this.tts.SOPHUTSD = t.SOPHUTSD;
this.tts.CUOCPHI = t.CUOCPHI;
db.SaveChanges();
}
public void AddCTSD(CHITIETSD t)
{
db.CHITIETSDs.Add(t);
db.SaveChanges();
}
public void EditCTSD(CHITIETSD t)
{
ctsdDAO.EditCTSD(t);
}
public void AddCTSD(CHITIETSD t)
{
ctsdDAO.AddCTSD(t);
}
