public static void Delete_LicenseLookupData(int lkpid)
{
AdminLinq.AdminDataContext pdb = new AdminLinq.AdminDataContext();
AdminLinq.tbl_lkp_License obj = pdb.tbl_lkp_Licenses.Where(c => c.LicenseType_ID == lkpid).SingleOrDefault();
pdb.tbl_lkp_Licenses.DeleteOnSubmit(obj);
pdb.SubmitChanges();
}
public static List <tbl_monthlyboardupdate> Getmonthlyupdate()
{
using (AdminDataContext db = new AdminLinq.AdminDataContext())
{
return(db.tbl_monthlyboardupdates.ToList());
}
}
public static void Deletemonthlyupdate(int auid)
{
using (AdminDataContext db = new AdminLinq.AdminDataContext())
{
tbl_monthlyboardupdate obj = db.tbl_monthlyboardupdates.Where(c => c.auid == auid).FirstOrDefault();
db.tbl_monthlyboardupdates.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
public static void Insert_monthlyupdate(string firstname, string lastname, string email)
{
using (AdminDataContext db = new AdminLinq.AdminDataContext())
{
tbl_monthlyboardupdate obj = new AdminLinq.tbl_monthlyboardupdate();
obj.FirstName = firstname;
obj.LastName = lastname;
obj.Email = email;
obj.Submission = DateTime.Now;
db.tbl_monthlyboardupdates.InsertOnSubmit(obj);
db.SubmitChanges();
}
}
public static int Insertion_LicenseLookup(int licid, string lictype, string licformat, string linkedlictype, string Exptype, string NumberforExp, string ExpDay, string ExpMonth, string Renewalstartday, string Renewalstartmonth, string RenewalEndDay, string RenewalEndMonth, string LicFee, string RenewalFee, string ReinstateFee, string LateRenewalFee, string isparentMust)
{
using (AdminLinq.AdminDataContext pdetalinsert = new AdminLinq.AdminDataContext())
{
tbl_lkp_License LicData;
if (licid == 0)
{
LicData = new tbl_lkp_License();
}
else
{
LicData = pdetalinsert.tbl_lkp_Licenses.Where(c => c.LicenseType_ID == licid).SingleOrDefault();
}
LicData.LicenseType_ID = licid;
LicData.License_Type = lictype;
LicData.License_Format = licformat;
LicData.Linked_LicenseType = linkedlictype;
LicData.ExpType = Exptype;
LicData.Numberfor_Exp = NumberforExp;
LicData.Exp_Day = ExpDay;
LicData.Exp_Month = ExpMonth;
LicData.Renewal_Start_Day = Renewalstartday;
LicData.Renewal_Start_Month = Renewalstartmonth;
LicData.Renewal_End_Day = RenewalEndDay;
LicData.Renewal_End_Month = RenewalEndMonth;
LicData.License_Fee = LicFee;
LicData.Renewal_Fee = RenewalFee;
LicData.Reinstate_Fee = ReinstateFee;
LicData.Late_Renewal_Fee = LateRenewalFee;
LicData.Is_ParentLicmust = isparentMust;
if (licid == 0)
{
pdetalinsert.tbl_lkp_Licenses.InsertOnSubmit(LicData);
}
pdetalinsert.SubmitChanges();
return(LicData.LicenseType_ID);
}
}
public static List <AdminLinq.tbl_lkp_License> Bind_LicenseLookupData()
{
AdminLinq.AdminDataContext pdb = new AdminLinq.AdminDataContext();
return(pdb.tbl_lkp_Licenses.OrderBy(c => c.License_Type).ToList());
}
