public CongNoDaiLy(CONGNODAILY congno)
{
MaSoSach = congno.masosach;
MaSoDaiLy = congno.masodaily;
SoLuong = congno.soluong;
DonGia = congno.dongia;
Thang = congno.thang;
}
public static int add(CongNoDaiLy congno)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
CONGNODAILY cn;
cn = (from c in db.CONGNODAILies
where c.masodaily.Equals(congno.MaSoDaiLy)
&& c.masosach.Equals(congno.MaSoSach)
&& c.thang.Month.Equals(congno.Thang.Month)
&& c.thang.Year.Equals(congno.Thang.Year)
select c).SingleOrDefault();
if (cn != null)
{
cn.soluong += congno.SoLuong;
db.SubmitChanges();
return 1;
}
else
{
cn = new CONGNODAILY();
cn.masodaily = congno.MaSoDaiLy;
cn.masosach = congno.MaSoSach;
cn.soluong = congno.SoLuong;
cn.dongia = congno.DonGia;
cn.thang = congno.Thang;
db.CONGNODAILies.InsertOnSubmit(cn);
db.SubmitChanges();
return 1;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return 0;
}
}
partial void DeleteCONGNODAILY(CONGNODAILY instance);
partial void UpdateCONGNODAILY(CONGNODAILY instance);
partial void InsertCONGNODAILY(CONGNODAILY instance);
private void detach_CONGNODAILies(CONGNODAILY entity)
{
this.SendPropertyChanging();
entity.SACH = null;
}
private void attach_CONGNODAILies(CONGNODAILY entity)
{
this.SendPropertyChanging();
entity.DAILY = this;
}
public CongNoDaiLy(CONGNODAILY congno, DAILY daily, SACH sach)
: this(congno,daily)
{
Sach = new Sach(sach);
}
public CongNoDaiLy(CONGNODAILY congno, SACH sach)
: this(congno)
{
Sach = new Sach(sach);
}
public CongNoDaiLy(CONGNODAILY congno, DAILY daily)
: this(congno)
{
DaiLy = new DaiLy(daily);
}
