public DataTable LoadDesigners()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx],CONCAT([fname] ,' - ',[EpfNo]) as usrInfo FROM [dbo].[Auth_Users] where SectionId=350"));
}
}
public DataSet LoadData()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("LoadShipment", objDIc));
}
}
public DataTable LoadPlanData()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("LoadPlanOrder", objDIc));
}
}
public DataTable LoadFabForPO()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("LoadForFabCon", objDIc));
}
}
public DataSet SelectMastItmsCat()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Merchandiser_Select_Itms_Cat", objDIc));
}
}
public DataTable LoadSubItems(int itm_id)
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT sb_itm_id, word FROM [erpWarehouse].[dbo].[load_view_itmsub] WHERE (itm_id= '" + itm_id.ToString() + "')"));
}
}
public DataSet Load_Mast_data()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("Merchandiser_Loadt_Mast", objDIc));
}
}
public DataTable LoadingInvTyp()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id] ,[inv_typ] ,[IsActive] FROM [dbo].[_Mechandiser_MAST_Inv_typ]"));
}
}
public DataTable LoadingPaymntTrms()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id],[Pay_terms] ,[IsActive] FROM [dbo].[_Merchandiser_MAST_Pymnt_terms]"));
}
}
public DataTable LoadBuyerCatergory()
{
{
//var objDIc = new Dictionary<string, object>(); SELECT [Idx],[id] ,[buyer] ,[buyer_category],[buyer_code] ,[buyer_po_code]FROM [dbo].[VIEW_Merchandiser_Buyer_details]
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx],[id] ,[buyer] ,[buyer_category],[buyer_code] ,[buyer_po_code] ,[address1],[address2],[address3],[city] ,[state] ,[postal_code] ,[country],[invoice_name],[invoice_address1] ,[invoice_address2] ,[invoice_address3] ,[contract_title],[contract_name],[email_address],[m_num] ,[p_num],[extention] ,[port] ,[c_account_no],[vat],[svat] ,[fax_no],[paymnt_terms] ,[Pay_terms],[currency] ,[credit_limit],[payment_name],[paymnt_email],[paymnt_mobile_no],[email_paymnt_inv] ,[email_shipment] ,[shipment_terms] ,[shipmet_terms],[inv_typ],[invtyp],[img1],[img2],[img3],[img4] FROM [dbo].[VIEW_Merchandiser_Buyer_details]"));
}
}
public DataTable LoadBuyer()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx],[id] ,[buyer] ,[buyer_category],[buyer_code] ,[buyer_po_code]FROM [dbo].[VIEW_Merchandiser_Buyer_details]"));
}
}
public DataSet Load_MAST_Type()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Get_Merch_MAST_SMVData", objDIc));
}
}
public DataSet LoadCostingDt()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Merchandiser_costing_details", objDIc));
}
}
public DataTable LoadPrintmachinRep()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx] ,[id],[machine_mode],[serial_no],CONVERT(DATE,[purchase_date]) as purchase_date,[purch_value],[supplier] ,[owner],[ip_address],[img] ,0 as cs ,[machine_no] FROM [dbo].[_PrintSec_machine] order by id"));
}
}
public DataTable LoadAssignSparemachn()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT sp.[idx] ,sp.[id] ,sp.[machineIdx],prntmchn.[machine_mode],prntmchn.[serial_no],sp.[assigndate] ,sp.[spartsId] ,sp.[spartsname] ,sp.[spartSerialNo],sp.[pcount],sp.[isActive] FROM [dbo].[_PrintSec_machine_spareparts] sp INNER JOIN [dbo].[_PrintSec_machine] prntmchn on sp.[machineIdx]=prntmchn.Idx"));
}
}
public DataSet Load_req_fab_info()
{//_Load_warehouse_req_fab_info
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Load_warehouse_req_fab_info", objDIc));
}
}
public DataTable LoadItems()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT itm_id,CONCAT(sup_item_code,' - ' ,sup_item_nme) as itmnms , sup_item_code,sup_item_nme FROM [erpWarehouse].[dbo].[itm_lgr_transa_stock] WHERE (isdeleted = 0) AND (actve = 1) and ([cat_id]=1094 or [cat_id]=8 ) order by itm_id"));
}
}
public DataTable LoadSizes()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [sizes_category_id],[size_names],[sort_ordr] FROM [dbo].[mercha_size_master_breakdown]"));
}
}
public DataTable Get_Items_Cat()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("_Itms_cate_sub_master", objDIc));
}
}
public DataTable SavePrintDt()
{
string pc_name = Environment.MachineName;
UserName = Environment.UserName;
string Usr = UserName.ToString() + "/" + pc_name.ToString();
{
var objDIc = new Dictionary <string, object> {
{ "Trns_Date", Trns_Date },
{ "PlantId", PlantId },
{ "PrintSecId", PrintSecId },
{ "roomId", roomId },
{ "OrdId", OrdId },
{ "size", sizeRn },
{ "Prod_Qnty", Prod_Qnty },
{ "Prod_Shift", Prod_Shift },
{ "printComment", printComment },
{ "ProdOption", ProdOption },
//{"Psection",Psection},
{ "CreatedBy", CreatedBy }
};
return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("SavePrintOrder", objDIc));
}
}
public DataSet Load_PatternDt_data()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("Get_Pattern_dt", objDIc));
}
}
public DataTable LoadSparepart()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [sb_itm_id] ,[sb_itm_nme] ,[itm_id],[stock_qty],([stock_qty]-[sqnty]) as sqnty , 0 as expanded,[img],[blncqnty] FROM [erpWarehouse].[dbo].[itm_lgr_transa_stock$sub] where (itm_id=6043 or itm_id=6010) and [stock_qty] >0 order by itm_id"));
}
}
public DataTable LoadingPatten()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("Select DISTINCT pattern_id,CONCAT( pattern_name ,' - ', pattern_description )as pttn from dbo.system_view_mercha_podata where despathed_date between (SELECT CONVERT ( date, DATEADD(M, DATEDIFF(M, 0, GETDATE()) -2, 20))) and (SELECT CONVERT ( date, DATEADD(M, DATEDIFF(M, 0, GETDATE()) +3, 0)))"));
}
}
public DataTable LoadSpartSerial()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [idx],[spart_serial_Idx],[itm_id],[sb_itm_id] ,[stock_qty],[s_qty] ,[serial_no] ,[sb_itm_nme],[isActive] FROM [dbo].[VIEW_Print_Sec_sparepart_Serial]"));
}
}
public DataSet LoadFabByPttn()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("FabConsumBypttn", objDIc));
}
}
public DataTable LoadColor()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [idx],[id] ,[colors],[isActive] FROM [dbo].[_PrintSec_machine_colors] order by id"));
}
}
public DataSet GetAllInvoice()
{
{
var objDIc = new Dictionary <string, object>();
return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("AllInvBill", objDIc));
}
}
public DataTable LoadUnit()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id],[unit] FROM [dbo].[_PrintSec_Units]"));
}
}
public DataTable LoadSublimct()
{
{
//var objDIc = new Dictionary<string, object>();
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [subli_cat_id],[sublimation_category]FROM [dbo].[mercha_prodct_master_sublimacat]"));
}
}
public DataTable Date_SecPlanSave()
{
{
var objDIc = new Dictionary <string, object>
{
// {"designPln_date",designPln_date},
// {"printingPln_date",printingPln_date},
// {"hPrintingPln_date",hPrintingPln_date},
// {"devPln_date",devPln_date},
// // {"scPritingPln_date",scPritingPln_date},
// {"reCutPln_date",reCutPln_date},
//// {"cutPln_date",cutPln_date},
// // {"diCutPln_date",diCutPln_date},
// {"packingPln_date",packingPln_date},
// // {"embPln_date",embPln_date},
// {"sewPln_date",sewPln_date},
// {"tp_date",tp_date},
// {"tc_date",tc_date},
// {"num_date",num_date},
// {"inp_date",inp_date},
{ "pln_sec", new pln_sec("").InvItemListToDataTable(pln_sec) },
{ "planItem", new planItem("").InvItemListToDataTable(planItem) },
{ "Usr", Usr }
};
return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("Plan_section_wise", objDIc));
}
}