public static List <VW_lkp_license_type> GetLicensetype()
{
using (ReportToolDataContext rtdc = new ReportToolDataContext())
{
return(rtdc.VW_lkp_license_types.ToList());
}
}
public static List <USP_Gettabs2displayResult> Gettabs(string utype)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_Gettabs2display(utype).ToList());
}
}
public static List <USP_GetsublistResult> Getsubmenu(string menuid, string utype)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_Getsublist(Convert.ToInt32(menuid), utype).ToList());
}
}
public static List <vw_allview> Getallviews_frm()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.vw_allviews.Where(c => c.view_name.Contains("print")).ToList());
}
}
public static List <USP_Getsublink2displayResult> Getsublinks(string utype, string mid)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_Getsublink2display(utype, Convert.ToInt32(mid)).ToList());
}
}
public static List <VW_dash_feetypecollect> Getfeetypecollect()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.VW_dash_feetypecollects.ToList());
}
}
public static tbl_print Get_printdetails(string prntid)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_prints.Where(c => c.PrintID == Convert.ToInt32(prntid)).SingleOrDefault());
}
}
public static List <USP_GetrocResult> GetROC(int type, DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_Getroc(type, sdt, edt).ToList());
}
}
public static List <USP_Getroc_detailsResult> GetROCDetails(int type, DateTime sdt, int id, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_Getroc_details(type, sdt, id, edt).ToList());
}
}
public static List <USP_applicationtypecountResult> Getapplications(DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_applicationtypecount(sdt, edt).ToList());
}
}
public static List <USP_ComplaintByCategoryResult> getcomplaintsbycategory(DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_ComplaintByCategory(sdt, edt).ToList());
}
}
public static List <USP_LicenseIssueCountResult> Getlicenseissue(DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_LicenseIssueCount(sdt, edt).ToList());
}
}
public static List <tbl_Sub_Menu> GetsubmenuMenus(string mid)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_Sub_Menus.Where(c => c.Menu_ID == Convert.ToInt32(mid)).ToList());
}
}
public static List <tbl_Menu> GetMenus()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_Menus.ToList());
}
}
public static List <VW_dash_outstandingfee> GetOutStandingFee()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.VW_dash_outstandingfees.ToList());
}
}
public static List <USP_FeeTypeCollectResult> Getfeetype(DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_FeeTypeCollect(sdt, edt).ToList());
}
}
public static List <VW_dash_licenseissuecount> Getlicissuecount()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.VW_dash_licenseissuecounts.ToList());
}
}
public static List <USP_getresoleddaysResult> Getresolvedays(DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_getresoleddays(sdt, edt).ToList());
}
}
public static List <vw_alltable> Getalltables()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.vw_alltables.ToList());
}
}
public static List <USP_getrsolutionResult> GetResolution(DateTime sdt, DateTime edt)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_getrsolution(sdt, edt).ToList());
}
}
public static List <tbl_print> Get_printbytype(string type)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_prints.Where(c => c.Folder == Convert.ToInt32(type)).ToList());
}
}
public static List <tbl_rpt_detail> getallreports()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_rpt_details.ToList());
}
}
public static List <USP_getallcolumnsResult> Getallcolumns(string obj)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_getallcolumns(obj).ToList());
}
}
public static List <tbl_print> getprintsbytype(int fld)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_prints.Where(c => c.Folder == fld).ToList());
}
}
public static List <USP_GetLicensingComplaintsResult> GetComplaintsDateReceived1(DateTime fromdate, DateTime todate, string lictype, string usp795, string usp797)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_GetLicensingComplaints(fromdate, todate, lictype, usp797, usp795).ToList());
}
}
public static List <VW_dash_cmpbycategory> Getcmpbycategory()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.VW_dash_cmpbycategories.ToList());
}
}
public static List <tbl_tabinfo> Gettabs()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.tbl_tabinfos.ToList());
}
}
public static List <VW_dash_myfile> GetMyFiles()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.VW_dash_myfiles.ToList());
}
}
public static List <USP_GetPDMPResult> GetPDMPDetails()
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
return(rdb.USP_GetPDMP().ToList());
}
}
public static void Insert_tabinfo(int auid, string utype, int tabid, Boolean selval, Boolean iswrite, Boolean isdel, string uid)
{
using (ReportToolDataContext rdb = new ReportToolDataContext())
{
tbl_user_tab obj = new tbl_user_tab();
if (auid != 0)
{
obj = rdb.tbl_user_tabs.Where(c => c.utab_id == auid).SingleOrDefault();
}
obj.Usertype = utype;
obj.tabid = tabid;
obj.Isselect = selval;
obj.Iswrite = iswrite;
obj.Isdelete = isdel;
if (auid == 0)
{
obj.createdby = uid;
obj.createddt = DateTime.Now;
rdb.tbl_user_tabs.InsertOnSubmit(obj);
}
else
{
obj.modifiedby = uid;
obj.modifieddt = DateTime.Now;
}
rdb.SubmitChanges();
}
}
