//lay ma chuyen muc lon nhat public string GetMaTLMax() { SQLDataContext.CreateDataContext(); string theloai = ""; try { //string masach = ""; int maso; SQLDataContext.SQLData.sp_getMaTLMax(ref theloai); maso = int.Parse(theloai.Substring(2)) + 1; if (maso.ToString().Length == 1) { theloai = "TL00" + maso.ToString(); } else if (maso.ToString().Length == 2) { theloai = "TL0" + maso.ToString(); } else { theloai = "TL" + maso.ToString(); } PHANLOAISACH tl = new PHANLOAISACH(); tl.MALOAI = theloai; SQLDataContext.SQLData.PHANLOAISACHes.InsertOnSubmit(tl); SQLDataContext.SQLData.SubmitChanges(); return(theloai); } catch { return("demo"); } }
public bool XoaTL(PHANLOAISACH tl) { try { SQLDataContext.SQLData.SP_XOATHELOAI(tl.MALOAI); return(true); } catch { return(false); } }
public bool ThemTL(PHANLOAISACH tl) { try { SuaTL(tl); return(true); } catch { return(false); } }
public bool SuaTL(PHANLOAISACH tl) { try { SQLDataContext.SQLData.SP_SUATHELOAI(tl.MALOAI, tl.TENLOAI, tl.MACHUYENMUC); return(true); } catch { return(false); } }
//delete ma sach rong public void DeleteMaTLMax() { try { PHANLOAISACH phanloaisach = SQLDataContext.SQLData.PHANLOAISACHes.Single(tl => tl.TENLOAI == null); SQLDataContext.SQLData.PHANLOAISACHes.DeleteOnSubmit(phanloaisach); SQLDataContext.SQLData.SubmitChanges(); } catch { } }