public App()
{
InitializeComponent();
MainPage = new ForecastView();
//MainPage = new MainPage();
}
public bool ForecastViewSave(ForecastView obj)
{
bool retVal = true;
string procName = (obj.Id == 0 ? "dbo.ForecastView_New" : "dbo.ForecastView_Edit");
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@p_ForecastId", obj.ForecastId, dbType: DbType.Int32);
para.Add("@p_CreatedOn", obj.CreatedOn, dbType: DbType.DateTime);
para.Add("@p_CreatedBy", obj.CreatedBy, dbType: DbType.String, size: 16);
para.Add("@p_VehicleId", obj.VehicleId, dbType: DbType.Int32);
para.Add("@p_ProgrammeId", obj.ProgrammeId, dbType: DbType.Int32);
para.Add("@p_GatewayId", obj.GatewayId, dbType: DbType.Int32);
para.Add("@p_Make", obj.Make, dbType: DbType.String, size: 500);
para.Add("@p_Code", obj.Code, dbType: DbType.String, size: 500);
para.Add("@p_Description", obj.Description, dbType: DbType.String, size: 1003);
para.Add("@p_ModelYear", obj.ModelYear, dbType: DbType.String, size: 50);
para.Add("@p_Gateway", obj.Gateway, dbType: DbType.String, size: 50);
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)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public ForecastView ForecastViewGet(int id)
{
ForecastView retVal = null;
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@p_Id", id, dbType: DbType.Int32);
retVal = conn.Query <ForecastView>("dbo.ForecastView_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
