public ActionResult Create(PageBannerViewModel pageBannerModel, string ReturnUrl)
{
ActionResult action;
try
{
if (!base.ModelState.IsValid)
{
base.ModelState.AddModelError("", MessageUI.ErrorMessage);
return(base.View(pageBannerModel));
}
else
{
PageBanner pageBanner = Mapper.Map <PageBannerViewModel, PageBanner>(pageBannerModel);
this._pageBannerService.Create(pageBanner);
base.Response.Cookies.Add(new HttpCookie("system_message", string.Format(MessageUI.CreateSuccess, FormUI.PageBanner)));
if (!base.Url.IsLocalUrl(ReturnUrl) || ReturnUrl.Length <= 1 || !ReturnUrl.StartsWith("/") || ReturnUrl.StartsWith("//") || ReturnUrl.StartsWith("/\\"))
{
action = base.RedirectToAction("Index");
}
else
{
action = this.Redirect(ReturnUrl);
}
}
}
catch (Exception exception1)
{
Exception exception = exception1;
ExtentionUtils.Log(string.Concat("PageBanner.Create: ", exception.Message));
base.ModelState.AddModelError("", exception.Message);
return(base.View(pageBannerModel));
}
return(action);
}
public static List<PageBanner> getAllListMenuBanner(string connString)
{
#region code
List<PageBanner> lists = new List<PageBanner>();
using (SqlConnection conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_get_all_page_banner";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
PageBanner banner = new PageBanner();
banner.Id = (int)reader["id"];
banner.BannerId = (int)reader["bannerId"];
banner.PageId = (int)reader["pageId"];
banner.Created = (DateTime)reader["created"];
banner.Updated = (DateTime)reader["updated"];
lists.Add(banner);
}
}
}
}
catch (Exception ex)
{
return new List<PageBanner>();
}
}
return lists;
#endregion
}
public static PageBanner getPageBannerById(int id, string connString)
{
PageBanner rs = new PageBanner();
using (SqlConnection conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_get_pagebanner_by_id";
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
rs.Id = (int)reader["id"];
rs.PageId = (int)reader["parentId"];
rs.BannerId = (int)reader["bannerId"];
rs.Created = (DateTime)reader["created"];
rs.Updated = (DateTime)reader["updated"];
break;
}
}
}
}
catch (Exception ex)
{
return rs;
}
}
return rs;
}
