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