public static int licChecklistInsert_Values(int licchecklistid, string lictype, string action, string checklist, string status, string ismandatory) { using (AdminDataContext pdetalinsert = new AdminDataContext()) { tbl_lkp_LicenseCheckList checklistdetail; if (licchecklistid == 0) { checklistdetail = new tbl_lkp_LicenseCheckList(); } else { checklistdetail = pdetalinsert.tbl_lkp_LicenseCheckLists.Where(c => c.License_CheckList_ID == licchecklistid).SingleOrDefault(); } checklistdetail.License_CheckList_ID = licchecklistid; checklistdetail.License_Type_ID = lictype; checklistdetail.Action = action; checklistdetail.CheckList_ID = checklist; checklistdetail.Status = status; checklistdetail.Is_Mandatory = ismandatory; if (licchecklistid == 0) { pdetalinsert.tbl_lkp_LicenseCheckLists.InsertOnSubmit(checklistdetail); } pdetalinsert.SubmitChanges(); return(checklistdetail.License_CheckList_ID); } }
public static void Delete_licChecklist(int licchecklistid) { using (AdminDataContext db = new AdminDataContext()) { tbl_lkp_LicenseCheckList obj = db.tbl_lkp_LicenseCheckLists.Where(c => c.License_CheckList_ID == licchecklistid).SingleOrDefault(); db.tbl_lkp_LicenseCheckLists.DeleteOnSubmit(obj); db.SubmitChanges(); } }