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();
}
}
