public static List <EmployeeFuel> GetEmployeeFuelList(int employeeId) { List <EmployeeFuel> list = new List <EmployeeFuel>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeFuelList"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeFuel employeeFuel = new EmployeeFuel(); employeeFuel.EmployeeFuelId = Convert.ToInt32(dataReader["EmployeeFuelId"]); employeeFuel.EmployeeVehicleId = Convert.ToInt32(dataReader["EmployeeVehicleId"]); employeeFuel.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]); employeeFuel.DateOfFuel = Convert.ToDateTime(dataReader["DateOfFuel"]); employeeFuel.PaymentType = dataReader["PaymentType"].ToString(); employeeFuel.Value = Convert.ToDouble(dataReader["Value"]); employeeFuel.Litres = Convert.ToDouble(dataReader["Litres"]); employeeFuel.KMReading = Convert.ToDouble(dataReader["KMReading"]); employeeFuel.Registration = dataReader["Registration"].ToString(); employeeFuel.Type = dataReader["Type"].ToString(); employeeFuel.VINNumber = dataReader["VINNumber"].ToString(); employeeFuel.Model = dataReader["Model"].ToString(); employeeFuel.Attachment = dataReader["Attachment"].ToString(); list.Add(employeeFuel); } } return(list); }
public static EmployeeFuel GetEmployeeFuelByEmployeeFuelId(int employeeFuelId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeFuelByEmployeeFuelId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeFuelId", DbType.Int32, employeeFuelId); db.AddOutParameter(dbCommand, "@EmployeeId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@EmployeeVehicleId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@VehicleId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@DateOfFuel", DbType.DateTime, 8); db.AddOutParameter(dbCommand, "@PaymentTypeId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@Value", DbType.Double, 8); db.AddOutParameter(dbCommand, "@Litres", DbType.Double, 8); db.AddOutParameter(dbCommand, "@KMReading", DbType.Double, 8); db.AddOutParameter(dbCommand, "@Attachment", DbType.String, 1000); db.ExecuteNonQuery(dbCommand); EmployeeFuel employeeFuel = new EmployeeFuel(); employeeFuel.EmployeeFuelId = employeeFuelId; employeeFuel.EmployeeId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeId")); employeeFuel.EmployeeVehicleId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeVehicleId")); employeeFuel.VehicleId = Convert.ToInt32(db.GetParameterValue(dbCommand, "VehicleId")); employeeFuel.DateOfFuel = Convert.ToDateTime(db.GetParameterValue(dbCommand, "DateOfFuel")); employeeFuel.PaymentTypeId = Convert.ToInt32(db.GetParameterValue(dbCommand, "PaymentTypeId")); employeeFuel.Value = Convert.ToDouble(db.GetParameterValue(dbCommand, "Value")); employeeFuel.Litres = Convert.ToDouble(db.GetParameterValue(dbCommand, "Litres")); employeeFuel.KMReading = Convert.ToDouble(db.GetParameterValue(dbCommand, "KMReading")); employeeFuel.Attachment = db.GetParameterValue(dbCommand, "Attachment").ToString(); return(employeeFuel); }
public static EmployeeFuel GetEmployeeFuelByVehicleIdEmployeeId(int vehicleId, int employeeId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeFuelByVehicleIdEmployeeId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@VehicleId", DbType.Int32, vehicleId); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); db.AddOutParameter(dbCommand, "@EmployeeFuelId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@EmployeeVehicleId", DbType.Int32, 4); db.ExecuteNonQuery(dbCommand); EmployeeFuel employeeFuel = new EmployeeFuel(); employeeFuel.EmployeeFuelId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeFuelId")); employeeFuel.EmployeeVehicleId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeVehicleId")); return(employeeFuel); }