public MainViewModel GenerateMainViewModel()
{
try
{
HomeViewDataService carouselDS = new HomeViewDataService();
DataSet ds = new DataSet();
MainViewModel viewModel = new MainViewModel();
ds = carouselDS.GetMainHomePage();
if (ds != null)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
viewModel.MainId = Convert.ToInt32(ds.Tables[0].Rows[0]["MainId"]);
viewModel.MainTitle = Convert.ToString(ds.Tables[0].Rows[0]["MainTitle"]);
viewModel.MainSubTitle = Convert.ToString(ds.Tables[0].Rows[0]["MainSubTitle"]);
viewModel.MainParagraph = Convert.ToString(ds.Tables[0].Rows[0]["MainParagraph"]);
}
}
}
return viewModel;
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateMainHomePage(MainViewModel mvm)
{
try
{
Database db = GetFactoryProvider();
DbCommand dbcomm = db.GetStoredProcCommand("UpdateMainHomePage");
db.AddInParameter(dbcomm, "@MainTitle", DbType.String, mvm.MainTitle);
db.AddInParameter(dbcomm, "@MainSubTitle", DbType.String, mvm.MainSubTitle);
db.AddInParameter(dbcomm, "@MainParagraph", DbType.String, mvm.MainParagraph);
db.ExecuteNonQuery(dbcomm);
}
catch (Exception ex)
{
throw ex;
}
}
