//load by model param
public static Model.mdlVehicleList LoadVehicleByBranch(Model.mdlVehicleBranchParam lParam)
{
var mdlVehicleListnew = new Model.mdlVehicleList();
var mdlVehicleList = new List <Model.mdlVehicle>();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lParam.BranchID
},
};
DataTable dtVehicle = Manager.DataFacade.DTSQLCommand("select vehicleid,VehicleNumber from Vehicle where VehicleNumber <> '' and SUBSTRING(VehicleID,5,3) = @BranchID", sp);
foreach (DataRow drVehicle in dtVehicle.Rows)
{
var mdlVehicle = new Model.mdlVehicle();
mdlVehicle.VehicleID = drVehicle["VehicleID"].ToString();
mdlVehicle.VehicleNumber = drVehicle["VehicleNumber"].ToString();
mdlVehicleList.Add(mdlVehicle);
}
mdlVehicleListnew.VehicleList = mdlVehicleList;
return(mdlVehicleListnew);
}
public static Model.mdlVehicleList LoadVehicle()
{
//var customerList = DataContext.Customers.Where(fld => fld.PlantID.Equals(json.BranchID)).ToList();
var mdlVehicleListnew = new Model.mdlVehicleList();
var mdlVehicleList = new List <Model.mdlVehicle>();
List <SqlParameter> sp = new List <SqlParameter>()
{
};
DataTable dtVehicle = Manager.DataFacade.DTSQLCommand("SELECT * FROM Vehicle", sp);
foreach (DataRow drVehicle in dtVehicle.Rows)
{
var mdlVehicle = new Model.mdlVehicle();
mdlVehicle.VehicleID = drVehicle["VehicleID"].ToString();
mdlVehicle.VehicleName = drVehicle["VehicleName"].ToString();
mdlVehicle.VehicleNumber = drVehicle["VehicleNumber"].ToString();
mdlVehicle.STNKDate = drVehicle["STNKDate"].ToString();
mdlVehicle.YearManufacturing = drVehicle["YearManufacturing"].ToString();
mdlVehicle.KIRNumber = drVehicle["KIRNumber"].ToString();
mdlVehicle.EngineNumber = drVehicle["EngineNumber"].ToString();
mdlVehicle.VehicleTypeID = drVehicle["VehicleTypeID"].ToString();
mdlVehicle.SubVehicleTypeID = drVehicle["SubVehicleTypeID"].ToString();
mdlVehicle.PlantID = drVehicle["PlantID"].ToString();
mdlVehicle.CapacityVolume = drVehicle["CapacityVolume"].ToString();
mdlVehicle.CapacityWeight = drVehicle["CapacityWeight"].ToString();
mdlVehicle.Brand = drVehicle["Brand"].ToString();
mdlVehicleList.Add(mdlVehicle);
}
mdlVehicleListnew.VehicleList = mdlVehicleList;
return(mdlVehicleListnew);
}
