private void btnAdd_Click(object sender, EventArgs e)
{
THONGTINSIM tts = new THONGTINSIM();
tts.IDSIM = tbIDSIM.Text;
tts.SDT = tbIDSIM.Text;
tts.TINHTRANG = true;
SimBUS bus = new SimBUS();
try
{
if (tts.IDSIM.Length == 0)
{
throw new Exception("");
}
bus.AddSim(tts);
if (callback != null)
{
callback();
}
MessageBox.Show("Thêm SIM thành công", "Thông báo!");
}
catch
{
MessageBox.Show("Không thêm được", "Thông báo!");
}
}
public static List <THONGTINSIM> LoadNotUsedTTS()
{
QLCDTEntities db = new QLCDTEntities();
var result = (
from t in db.THONGTINSIMs
where !(
from w in db.HDDKs
select w.IDSIM
).Contains(t.IDSIM)
select new
{
IDSIM = t.IDSIM,
SDT = t.SDT,
TINHTRANG = t.TINHTRANG
}).ToList();
List <THONGTINSIM> listReturn = new List <THONGTINSIM>();
foreach (var item in result)
{
THONGTINSIM kh_list = new THONGTINSIM();
kh_list.IDSIM = item.IDSIM;
kh_list.SDT = item.SDT;
kh_list.TINHTRANG = item.TINHTRANG;
listReturn.Add(kh_list);
}
return(listReturn);
}
public void DeleteTTS(string id)
{
THONGTINSIM t = new THONGTINSIM();
t = db.THONGTINSIMs.Single(c => c.IDSIM == id);
db.THONGTINSIMs.Remove(t);
db.SaveChanges();
}
public void EditTTS(THONGTINSIM t)
{
this.tts = (from c in db.THONGTINSIMs
where c.IDSIM == t.IDSIM
select c).Single();
this.tts.IDSIM = t.IDSIM;
this.tts.SDT = t.SDT;
this.tts.TINHTRANG = t.TINHTRANG;
db.SaveChanges();
}
public void delete_thongtinSim(THONGTINSIM b)
{
dao.delete_thongtinSim(b);
}
public void update_Thongtinsim(THONGTINSIM a)
{
dao.update_Thongtinsim(a);
}
////public bool Exits_KH_bySIM(string ma)
////{
//// if (GetBySIM(ma) == null)
//// {
//// return false;
//// }
//// return true;
////}
////public string Ma_of_Sim(string ma)
////{
//// QLCDTDataContext db = new QLCDTDataContext();
//// KHACHHANG x = db.KHACHHANGs.Where(a => a.IDSim == ma).SingleOrDefault();
//// return x.IDKHACHHANG;
////}
////public IEnumerable<String> getTenDaily()
////{
//// QLVESODataContext db = new QLVESODataContext();
//// return db.DaiLies.AsEnumerable().Select(s => s.MaDaiLy);
////}
public void insert_Thongtinsim(THONGTINSIM a)
{
dao.insert_Thongtinsim(a);
}
public void AddTTS(THONGTINSIM t)
{
db.THONGTINSIMs.Add(t);
db.SaveChanges();
}
public void EditSim(THONGTINSIM t)
{
simDAO.EditTTS(t);
}
public void AddSim(THONGTINSIM t)
{
simDAO.AddTTS(t);
}
