public bool ForecastVehicleSave(ForecastVehicle obj) { bool retVal = true; string procName = (obj.Id == 0 ? "dbo.ForecastVehicle_New" : "dbo.ForecastVehicle_Edit"); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_ForecastVehicleId", obj.ForecastVehicleId, dbType: DbType.Int32); para.Add("@p_ProgrammeId", obj.ProgrammeId, dbType: DbType.Int32); para.Add("@p_VehicleId", obj.VehicleId, dbType: DbType.Int32); para.Add("@p_GatewayId", obj.GatewayId, dbType: DbType.Int32); if (obj.Id == 0) { para.Add("@p_Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { para.Add("@p_Id", obj.Id, dbType: DbType.Int32); } conn.Execute(procName, para, commandType: CommandType.StoredProcedure); if (obj.Id == 0) { obj.Id = para.Get<int>("@p_Id"); } } catch (Exception ex) { AppHelper.LogError("ForecastVehicleDataStore.ForecastVehicleSave", ex.Message, CurrentCDSID); retVal = false; } } return retVal; }
public bool ForecastVehicleSave(ForecastVehicle obj) { bool retVal = true; string procName = (obj.Id == 0 ? "dbo.ForecastVehicle_New" : "dbo.ForecastVehicle_Edit"); using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_ForecastVehicleId", obj.ForecastVehicleId, dbType: DbType.Int32); para.Add("@p_ProgrammeId", obj.ProgrammeId, dbType: DbType.Int32); para.Add("@p_VehicleId", obj.VehicleId, dbType: DbType.Int32); para.Add("@p_GatewayId", obj.GatewayId, dbType: DbType.Int32); if (obj.Id == 0) { para.Add("@p_Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { para.Add("@p_Id", obj.Id, dbType: DbType.Int32); } conn.Execute(procName, para, commandType: CommandType.StoredProcedure); if (obj.Id == 0) { obj.Id = para.Get <int>("@p_Id"); } } catch (Exception ex) { AppHelper.LogError("ForecastVehicleDataStore.ForecastVehicleSave", ex.Message, CurrentCDSID); retVal = false; } } return(retVal); }
public ForecastVehicle ForecastVehicleGet(int id) { ForecastVehicle retVal = null; using (IDbConnection conn = DbHelper.GetDBConnection()) { try { var para = new DynamicParameters(); para.Add("@p_Id", id, dbType: DbType.Int32); retVal = conn.Query <ForecastVehicle>("dbo.ForecastVehicle_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { AppHelper.LogError("ForecastVehicleDataStore.ForecastVehicleGet", ex.Message, CurrentCDSID); } } return(retVal); }