public List <TruckList> GetListByType(int VehicleType, string MobileNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTTRUCK, MapBuilder <TruckList> .BuildAllProperties(), VehicleType, MobileNo).ToList());
}
public void ThenCreateSprocAccessorWithNullParameterMapperThrows()
{
Database.CreateSprocAccessor <Product>("prodedure name", null, MapBuilder <Product> .BuildAllProperties());
}
public List <ARCreditNoteDetail> GetListByDocumentNo(string documentNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTARCREDITNOTEDETAIL, MapBuilder <ARCreditNoteDetail> .BuildAllProperties(), documentNo).ToList());
}
public List <Invoice> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTINVOICE, MapBuilder <Invoice> .BuildAllProperties()).ToList());
}
public void ThenCreateSqlStringAccessorWithNullDatabaseThrows()
{
new SqlStringAccessor <Product>(null, "SELECT 'test'", MapBuilder <Product> .BuildAllProperties());
}
public List <OperatorVehicle> GetOperatorVehicleListById(string OperatorVehicleID)
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORVEHICLETOTALLISTBYID, MapBuilder <OperatorVehicle> .BuildAllProperties(), OperatorVehicleID).ToList());
}
//public List<Customer> GetCustomerTableDataList(DataTableObject Obj)
//{
// return db.ExecuteSprocAccessor(DBRoutine.SELECTCUSTOMERTABLEDATA,
// MapBuilder<Customer>.BuildAllProperties(),
// Obj.limit, Obj.offset, Obj.sortColumn, Obj.sortType,Obj.BranchID).ToList();
//}
public List <Customer> GetCustomerTableDataList(DataTableObject Obj)
{
return(db.ExecuteSprocAccessor(DBRoutine.CUSTOMERPAGEVIEW,
MapBuilder <Customer> .BuildAllProperties(),
Obj.BranchID, Obj.limit, Obj.offset, Obj.sortColumn, Obj.sortType).ToList());
}
public List <CustomerLogin> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTCUSTOMERLOGIN, MapBuilder <CustomerLogin> .BuildAllProperties()).ToList());
}
public List <Address> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTADDRESS, MapBuilder <Address> .BuildAllProperties()).ToList());
}
public List <OperatorDriverList> GetOperatorDriverList(string DriverID)
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORCHECKDRIVERLIST, MapBuilder <OperatorDriverList> .BuildAllProperties(), DriverID).ToList());
}
public List <OperatorDriverList> GetOperatortotalDriverList()
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORDRIVERTOTALLIST, MapBuilder <OperatorDriverList> .BuildAllProperties()).ToList());
}
public List <OperatorVehuicleAttachedNo> GetVehicleNoList()
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTVEHICLENODETAILS, MapBuilder <OperatorVehuicleAttachedNo> .BuildAllProperties()).ToList());
}
public List <OperatorDriver> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTDRIVERDETAILS, MapBuilder <OperatorDriver> .BuildAllProperties()).ToList());
}
public List <OperatorDriverList> GetSelectList(string OperatorID)
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORDRIVERBYID, MapBuilder <OperatorDriverList> .BuildAllProperties(), OperatorID).ToList());
}
public List <LookUp> GetVehicleCategoryList()
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORVEHICLECATEGORYLIST, MapBuilder <LookUp> .BuildAllProperties()).ToList());
}
public List <OperatorAttachment> GetList(string OperatorID)
{
return(db.ExecuteSprocAccessor(DBRoutine.OPERATORATTACHMENTSLIST,
MapBuilder <OperatorAttachment> .BuildAllProperties(), OperatorID).ToList());
}
public List <OperatorVehicles> GetModelList()
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORVEHICLEMODELLIST, MapBuilder <OperatorVehicles> .BuildAllProperties()).ToList());
}
public List <VendorRMAOutwardDetail> GetList(short branchID, string documentNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTVENDORRMAOUTWARDDETAIL, MapBuilder <VendorRMAOutwardDetail> .BuildAllProperties(), branchID, documentNo).ToList());
}
public List <APTransaction> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTAPTRANSACTION, MapBuilder <APTransaction> .BuildAllProperties()).ToList());
}
protected virtual IRowMapper <T> BuildMapper()
{
return(MapBuilder <T> .BuildAllProperties());
}
public List <CBPaymentGlDetail> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTCBPAYMENTGLDETAIL, MapBuilder <CBPaymentGlDetail> .BuildAllProperties()).ToList());
}
public List <ProductCategory> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTPRODUCTCATEGORY, MapBuilder <ProductCategory> .BuildAllProperties()).ToList());
}
public List <GLJournalDetail> GetListByDocumentNo(string documentNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTGLJOURNALDETAIL, MapBuilder <GLJournalDetail> .BuildAllProperties(), documentNo).ToList());
}
public List <APCreditNoteDetail> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTAPCREDITNOTEDETAIL, MapBuilder <APCreditNoteDetail> .BuildAllProperties()).ToList());
}
public void ThenPassingNullParameterMapperThrows()
{
Database.CreateSqlStringAccessor <Product>("SELECT 'test'", null, MapBuilder <Product> .BuildAllProperties());
}
public List <SIDetail> GetList(string documentNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTSIDETAIL, MapBuilder <SIDetail> .BuildAllProperties(), documentNo).ToList());
}
public void ThenCreateSprocAccessorWithNullDatabaseThrows()
{
new SprocAccessor <Product>(null, "procedure name", MapBuilder <Product> .BuildAllProperties());
}
public List <LookUp> GetList()
{
return(db.ExecuteSprocAccessor(DBRoutine.SELECTOPERATORVEHICLETYPELIST, MapBuilder <LookUp> .BuildAllProperties()).ToList());
}
public List <CBPaymentDetail> GetListByDocumentNo(string documentNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTCBPAYMENTDETAIL, MapBuilder <CBPaymentDetail> .BuildAllProperties(), documentNo).ToList());
}
public List <TruckList> GetList(string MobileNo)
{
return(db.ExecuteSprocAccessor(DBRoutine.LISTTRUCK, MapBuilder <TruckList> .BuildAllProperties(), MobileNo).ToList());
}
