Exemplo n.º 1
0
 /// <summary>
 /// Change max-number of SONOTOIDA in LOAIDL
 /// </summary>
 /// <param name="maloaidl"></param>
 /// <param name="sonotoida"></param>
 /// <returns></returns>
 public bool ChangeMaxNumOfTienNo(int maloaidl, int sonotoida)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         LOAIDL loaidl = db.LOAIDLs.Where(p => p.MALOAI == maloaidl).Single();
         loaidl.SONOTOIDA = sonotoida;
         db.SaveChanges();
         return(true);
     }
 }
Exemplo n.º 2
0
 /// <summary>
 /// insert a record into table LOAIDL- increament number of LOAIDL
 /// </summary>
 /// <param name="tenloai"></param>
 /// <param name="sonotoida"></param>
 /// <returns></returns>
 public bool InsertLoaiDL(string tenloai, int sonotoida)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         LOAIDL dl = new LOAIDL();
         dl.TENLOAI   = tenloai;
         dl.SONOTOIDA = sonotoida;
         db.LOAIDLs.Add(dl);
         db.SaveChanges();
         //insert suceed
         return(true);
     }
 }
Exemplo n.º 3
0
 /// <summary>
 /// delete a record into table LOAIDL - descreament number of LOAIDL
 /// </summary>
 /// <param name="loaidl"></param>
 /// <returns></returns>
 public bool DeleteLAOIDL(int loaidl)
 {
     using (QLDLEntities db = new QLDLEntities())
     {
         if (db.DAILies.Where(p => p.LOAIDL == loaidl).Count() <= 0)
         {
             LOAIDL ldl = db.LOAIDLs.Where(p => p.MALOAI == loaidl).Single();
             db.LOAIDLs.Remove(ldl);
             db.SaveChanges();
             //delete succeed
             return(true);
         }
         //delete false
         return(false);
     }
 }