public static Model.mdlResult DeleteVehicle(Model.mdlVehicleParam lParam)
{
var mdlResult = new Model.mdlResult();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@VehicleID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleID
}
};
string query = "Delete From Vehicle WHERE VehicleID = @VehicleID";
mdlResult.Result = "|| " + "Delete Vehicle " + lParam.VehicleID + " || " + Manager.DataFacade.DTSQLVoidCommand(query, sp);
return(mdlResult);
}
public static Model.mdlResult UpdateVehicle(Model.mdlVehicleParam lParam)
{
var mdlResult = new Model.mdlResult();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@VehicleID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleID
},
new SqlParameter()
{
ParameterName = "@VehicleName", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleName
},
new SqlParameter()
{
ParameterName = "@VehicleNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleNumber
},
new SqlParameter()
{
ParameterName = "@STNKDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.STNKDate
},
new SqlParameter()
{
ParameterName = "@YearManufacturing", SqlDbType = SqlDbType.NVarChar, Value = lParam.YearManufacturing
},
new SqlParameter()
{
ParameterName = "@KIRNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.KIRNumber
},
new SqlParameter()
{
ParameterName = "@EngineNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.EngineNumber
},
new SqlParameter()
{
ParameterName = "@VehicleTypeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleTypeID
},
new SqlParameter()
{
ParameterName = "@SubVehicleTypeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.SubVehicleTypeID
},
new SqlParameter()
{
ParameterName = "@PlantID", SqlDbType = SqlDbType.NVarChar, Value = lParam.PlantID
},
new SqlParameter()
{
ParameterName = "@CapacityVolume", SqlDbType = SqlDbType.NVarChar, Value = lParam.CapacityVolume
},
new SqlParameter()
{
ParameterName = "@CapacityWeight", SqlDbType = SqlDbType.NVarChar, Value = lParam.CapacityWeight
},
new SqlParameter()
{
ParameterName = "@Brand", SqlDbType = SqlDbType.NVarChar, Value = lParam.Brand
}
};
string query = "UPDATE Vehicle SET VehicleName = @VehicleName, VehicleNumber = @VehicleNumber, STNKDate = @STNKDate, YearManufacturing = @YearManufacturing, KIRNumber = @KIRNumber, EngineNumber = @EngineNumber, VehicleTypeID = @VehicleTypeID, SubVehicleTypeID = @SubVehicleTypeID, PlantID = @PlantID, CapacityVolume = @CapacityVolume, CapacityWeight = @CapacityWeight, Brand = @Brand WHERE VehicleID = @VehicleID";
mdlResult.Result = "|| " + "Update Vehicle " + lParam.VehicleID + " || " + Manager.DataFacade.DTSQLVoidCommand(query, sp);
return(mdlResult);
}
public static Model.mdlResult InsertVehicle(Model.mdlVehicleParam lParam)
{
var mdlResult = new Model.mdlResult();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@VehicleID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleID
},
new SqlParameter()
{
ParameterName = "@VehicleName", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleName
},
new SqlParameter()
{
ParameterName = "@VehicleNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleNumber
},
new SqlParameter()
{
ParameterName = "@STNKDate", SqlDbType = SqlDbType.NVarChar, Value = lParam.STNKDate
},
new SqlParameter()
{
ParameterName = "@YearManufacturing", SqlDbType = SqlDbType.NVarChar, Value = lParam.YearManufacturing
},
new SqlParameter()
{
ParameterName = "@KIRNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.KIRNumber
},
new SqlParameter()
{
ParameterName = "@EngineNumber", SqlDbType = SqlDbType.NVarChar, Value = lParam.EngineNumber
},
new SqlParameter()
{
ParameterName = "@VehicleTypeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.VehicleTypeID
},
new SqlParameter()
{
ParameterName = "@SubVehicleTypeID", SqlDbType = SqlDbType.NVarChar, Value = lParam.SubVehicleTypeID
},
new SqlParameter()
{
ParameterName = "@PlantID", SqlDbType = SqlDbType.NVarChar, Value = lParam.PlantID
},
new SqlParameter()
{
ParameterName = "@CapacityVolume", SqlDbType = SqlDbType.NVarChar, Value = lParam.CapacityVolume
},
new SqlParameter()
{
ParameterName = "@CapacityWeight", SqlDbType = SqlDbType.NVarChar, Value = lParam.CapacityWeight
},
new SqlParameter()
{
ParameterName = "@Brand", SqlDbType = SqlDbType.NVarChar, Value = lParam.Brand
}
};
string query = "INSERT INTO Vehicle (VehicleID,VehicleName,VehicleNumber,STNKDate,YearManufacturing,KIRNumber,EngineNumber,VehicleTypeID,SubVehicleTypeID,PlantID,CapacityVolume,CapacityWeight,Brand) " +
"VALUES (@VehicleID,@VehicleName,@VehicleNumber,@STNKDate,@YearManufacturing,@KIRNumber,@EngineNumber,@VehicleTypeID,@SubVehicleTypeID,@PlantID,@CapacityVolume,@CapacityWeight,@Brand) ";
mdlResult.Result = "|| " + "Insert Vehicle " + lParam.VehicleID + " || " + Manager.DataFacade.DTSQLVoidCommand(query, sp);
return(mdlResult);
}
