protected List <MasterDataModel.MasterDataKendaraan> ListVehicle() { List <MasterDataModel.MasterDataKendaraan> _ListVehicle = new List <MasterDataModel.MasterDataKendaraan>(); _ListVehicle = DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("dbo.sp_GetMasterDataVehicle", true); return(_ListVehicle); }
protected void gridInvoiceItem_DataBinding(object sender, EventArgs e) { //initialize parameter BootstrapGridView grid = (BootstrapGridView)sender; List <InvoiceModel.InvoiceItem> ListInvoiceItem = new List <InvoiceModel.InvoiceItem>(); string InvoiceNumber = Session["InvoiceNumber"].ToString() ?? string.Empty; //set datagrid detail ListInvoiceItem = DbTransaction.DbToList <InvoiceModel.InvoiceItem>("dbo.sp_GetInvoice_Items", new { InvoiceNumber = InvoiceNumber }, true); grid.DataSource = ListInvoiceItem; }
public List <UserModel> GetDataUser() { try { var Data = dbTrans.DbToList <UserModel>("USP_Get_User", true); return(Data); } catch (Exception ex) { throw ex; } }
protected List <SP3MModel.SP3MProduct> ListSP3MItemBySPP(int SPP_ID) { List <SP3MModel.SP3MProduct> _ListSP3MItemBySPP = new List <SP3MModel.SP3MProduct> (); _ListSP3MItemBySPP = DbTransaction.DbToList <SP3MModel.SP3MProduct>("sp_GetSPPItemByIDSPP", new { SPP_ID = SPP_ID }, true); //set data to session JsonProductItem = JsonConvert.SerializeObject(_ListSP3MItemBySPP); Session["JsonProductItem"] = JsonProductItem; return(_ListSP3MItemBySPP); }
public List <ReportModel.OAT> GetDataOAT(DateTime PeriodeStart, DateTime PeriodeEnd, Int32 TBBM, string Force, string Unity) { List <ReportModel.OAT> list = new List <ReportModel.OAT>(); list = DbTransaction.DbToList <ReportModel.OAT>("dbo.sp_RepOAT_Transporter", new { Start = PeriodeStart, End = PeriodeEnd, TBBM = TBBM, Force = Force, Unity = Unity }, true); return(list); }
protected List <SP3MModel.SP3M> ListSP3M() { List <SP3MModel.SP3M> _ListSP3M = new List <SP3MModel.SP3M>(); _ListSP3M = DbTransaction.DbToList <SP3MModel.SP3M>("dbo.sp_GetSP3M_ForSPP", true); //add null items _ListSP3M.Add(new SP3MModel.SP3M { SP3M_ID_PK = 0, NoSP3M = string.Empty }); return(_ListSP3M); }
protected List <MasterDataModel.MasterDataRole> ListRole() { List <MasterDataModel.MasterDataRole> listrole = new List <MasterDataModel.MasterDataRole>(); listrole = DbTransaction.DbToList <MasterDataModel.MasterDataRole>("dbo.sp_GetMasterDataRoles", new { }, true); //for (int i = 1; i < 4; i++) //{ // listrole.Add(new MasterDataModel.MasterDataRole() // { // RoleID = Guid.NewGuid(), // RoleName = "USER_ADMIN" // }); //} return(listrole); }
protected List <MasterDataModel.MasterDataDriver> ListDriver(int?TransportirId) { List <MasterDataModel.MasterDataDriver> _ListDriver = new List <MasterDataModel.MasterDataDriver>(); _ListDriver = DbTransaction.DbToList <MasterDataModel.MasterDataDriver>("dbo.sp_GetMasterDataDriver_CMB", new { transporter_ID = TransportirId }, true); //add null items _ListDriver.Add(new MasterDataModel.MasterDataDriver { Driver_ID = 0, Name = "" }); //hf["driver"] = Newtonsoft.Json.JsonConvert.SerializeObject(_ListDriver); return(_ListDriver); }
protected List <MasterDataModel.MasterDataKendaraan> ListVehicle(int?TransportirId) { List <MasterDataModel.MasterDataKendaraan> _ListVehicle = new List <MasterDataModel.MasterDataKendaraan>(); _ListVehicle = DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("dbo.sp_GetMasterDataVehicleNumber_CMB", new { transporter_ID = TransportirId }, true); //add null items _ListVehicle.Add(new MasterDataModel.MasterDataKendaraan { Vehicle_ID = 0, Number = "" }); //hf["vehicle"] = Newtonsoft.Json.JsonConvert.SerializeObject(_ListVehicle); return(_ListVehicle); }
protected List <MasterDataModel.MasterDataUser> ListUser() { List <MasterDataModel.MasterDataUser> listuser = new List <MasterDataModel.MasterDataUser>(); listuser = DbTransaction.DbToList <MasterDataModel.MasterDataUser>("dbo.sp_GetMasterDataUsers", new { }, true); //for (int i = 1; i < 20; i++) //{ // listuser.Add(new MasterDataModel.MasterDataUser() // { // UserID = Guid.NewGuid(), // Username = "******" + i, // Password = "******", // Email = "admin_" + i + "@mail.com", // Telephone = "0818081208" + i, // IsActive = true, // CreationBy = "arie", // CreationDate = DateTime.Now, // UpdateBy = "wibowo", // UpdateDate = DateTime.Now // }); //} return(listuser); }
public static List <MasterDataModel.MasterDataKendaraan> GetMasterDataVehicleType_CMB() { return(DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("sp_GetMasterDataVehicleType_CMB", true)); }
public static List <MasterDataModel.MasterDataKendaraan> GetMasterDataVehicleNumber_CMB(int transporter_ID, int vehicleType_ID) { return(DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("sp_GetMasterDataVehicleNumber_CMB", new { transporter_ID = transporter_ID, vehicleType_ID = vehicleType_ID }, true)); }
public List <InvoiceModel.InvoiceReport> GetInvoice_Report(string Year) { return(DbTransaction.DbToList <InvoiceModel.InvoiceReport>("dbo.sp_GetInvoice_Report", new { Year = Year }, true)); }
public List <InvoiceModel.InvoiceHeader> GetInvoice_Header(string InvoiceNumber) { return(DbTransaction.DbToList <InvoiceModel.InvoiceHeader>("dbo.sp_GetInvoice_HeaderByNumber", new { InvoiceNumber = InvoiceNumber }, true)); }
protected List <InvoiceModel.InvoiceItem> GetDatainvoiceItem(string InvoiceNumber) { ListInvoiceItem = DbTransaction.DbToList <InvoiceModel.InvoiceItem>("dbo.sp_GetInvoice_Items", new { InvoiceNumber = InvoiceNumber }, true); return(ListInvoiceItem); }
public static List <MasterDataModel.MasterDataDistance> GetMasterDataDistance() { return(DbTransaction.DbToList <MasterDataModel.MasterDataDistance>("sp_GetMasterDataDistance", true)); }
public static List <MasterDataModel.MasterDataUnity> GetMasterDataUnity() { return(DbTransaction.DbToList <MasterDataModel.MasterDataUnity>("sp_GetMasterDataUnity", true)); }
public static List <MasterDataModel.MasterDataKendaraan> GetMasterDataVehicleType_CMB(int transporter_ID, int quantityVolume) { return(DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("sp_GetMasterDataVehicleType_CMB", new { transporter_ID = transporter_ID, quantityVolume = quantityVolume }, true)); }
public static List <MasterDataModel.MasterDataKendaraan> GetMasterDataUnitCapacity_CMB() { return(DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("sp_GetMasterDataUnitCapacity_CMB", true)); }
public static List <MasterDataModel.MasterDataDriver> GetMasterDataDriverByTransporterID_CMB(int transporter_ID) { return(DbTransaction.DbToList <MasterDataModel.MasterDataDriver>("sp_GetMasterDataDriver_CMB", new { transporter_ID = transporter_ID }, true)); }
public List <MasterDataModel.MasterDataProduct> GetMasterDataProduct() { return(DbTransaction.DbToList <MasterDataModel.MasterDataProduct>("dbo.sp_GetMasterDataProduct", true)); }
public static List <MasterDataModel.MasterDataTransporterFee> GetMasterDataTransporterFee() { return(DbTransaction.DbToList <MasterDataModel.MasterDataTransporterFee>("sp_GetMasterDataTransporterFee", true)); }
public static List <MasterDataModel.MasterDataDistance> GetMasterDataDistance(CommonDataModel.ActiveType activetype) { return(DbTransaction.DbToList <MasterDataModel.MasterDataDistance>("sp_GetMasterDataDistance", new { ActiveType = (int)activetype }, true)); }
public static List <MasterDataModel.MasterDataTransporterFee> GetMasterDataTransporterFee(int transporter_ID) { return(DbTransaction.DbToList <MasterDataModel.MasterDataTransporterFee>("sp_GetMasterDataTransporterFee", new { Transporter_ID = transporter_ID }, true)); }
public List <InvoiceModel.InvoiceHeader> GetInvoice_Header() { return(DbTransaction.DbToList <InvoiceModel.InvoiceHeader>("dbo.sp_GetInvoice_Header", true)); }
public static List <MasterDataModel.MasterDataTransporterFee> GetMasterDataTransporterFee(int transporter_ID, CommonDataModel.ActiveType activetype) { return(DbTransaction.DbToList <MasterDataModel.MasterDataTransporterFee>("sp_GetMasterDataTransporterFee", new { Transporter_ID = transporter_ID, ActiveType = (int)activetype }, true)); }
public List <LOModel.LOItem> GetLO_ToInvoice() { return(DbTransaction.DbToList <LOModel.LOItem>("dbo.sp_GetLO_ToInvoice", true)); }
public static List <MasterDataModel.MasterDataDriver> GetMasterDataVehicle() { return(DbTransaction.DbToList <MasterDataModel.MasterDataDriver>("sp_GetMasterDataVehicle", true)); }
public List <SP3MModel.SP3MRealization> GetRealization(string Year) { return(DbTransaction.DbToList <SP3MModel.SP3MRealization>("dbo.sp_GetRealization_Report", new { Year = Year }, true)); }
public static List <MasterDataModel.MasterDataKendaraan> GetMasterDataVehicle(CommonDataModel.ActiveType activetype) { return(DbTransaction.DbToList <MasterDataModel.MasterDataKendaraan>("sp_GetMasterDataVehicle", new { ActiveType = (int)activetype }, true)); }