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