public static void Save_dispinfo(int dispid, string pid, string cmpno, string sdt, string edt, string comments, string isdisp, string crtby, string crtdt) { using (License_ConnectionDataContext ldb = new License_ConnectionDataContext()) { tbl_DisciplineInfo obj = new tbl_DisciplineInfo(); if (dispid != 0) { obj = ldb.tbl_DisciplineInfos.Where(c => c.Disp_Info_ID == dispid).SingleOrDefault(); } obj.Complaint_Number = cmpno; obj.Person_ID = pid; if (sdt != "") { obj.Start_Date = Convert.ToDateTime(sdt); } if (edt != "") { obj.End_Date = Convert.ToDateTime(edt); } obj.Comments = comments; obj.IS_Discipline = isdisp; if (dispid == 0) { obj.CreatedBy = crtby; obj.CreatedDate = Convert.ToDateTime(crtdt); ldb.tbl_DisciplineInfos.InsertOnSubmit(obj); } else { obj.ModifiedBy = crtby; obj.ModifiedDate = Convert.ToDateTime(crtdt); } ldb.SubmitChanges(); } }
public static void Delete_dispinfo(int dispid) { using (License_ConnectionDataContext ldb = new License_ConnectionDataContext()) { tbl_DisciplineInfo obj = ldb.tbl_DisciplineInfos.Where(c => c.Disp_Info_ID == dispid).SingleOrDefault(); ldb.tbl_DisciplineInfos.DeleteOnSubmit(obj); ldb.SubmitChanges(); } }