protected void btnSubmit_Click(object sender, EventArgs e)
{
string tag = _tag + "[btnSubmit_Click]";
MenuBOL obj = new MenuBOL()
{
Name_VN = tbxNameVN.Text,
Description_VN = tbxDesVN.Text,
Name_EN = tbxNameEN.Text,
Description_EN = tbxDesEN.Text,
InsertDate = DateTime.Now,
UpdatedDate = DateTime.Now
};
if (_menuId > 0)
{
obj.Id = _menuId;
}
else if (_parentId > 0)
{
obj.ParentId = _parentId;
}
var result = MenuDAL.InsertOrUpdate(obj);
if (result.Code < 0)
{
LogHelpers.WriteError(tag, result.ErrorMessage);
}
else
{
GoBackPage();
}
}
public static AllCategoriesModel GetAll(bool removeRoot = false)
{
string stored = "sp_GetAllData_WithType";
ResultData <DataSet> result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, new { });
if (result.Code < 0)
{
_log.Error(result.Message);
}
AllCategoriesModel model = new AllCategoriesModel();
if (result.Data != null && result.Data.Tables.Count > 1)
{
foreach (DataRow row in result.Data.Tables[0].Rows)
{
MenuBOL menu = new MenuBOL(row);
if (removeRoot && menu.ParentId <= 0)
{
continue;
}
model.Roots.Add(menu);
}
foreach (DataRow row in result.Data.Tables[1].Rows)
{
model.News.Add(new NewsBOL(row));
}
}
return(model);
}
private void StartLoadMenuInfo(int id)
{
if (id <= 0)
{
return;
}
var result = MenuDAL.Get(id);
if (result.Code < 0)
{
return;
}
MenuBOL menuBOL = new MenuBOL(result.Data.Tables[0].Rows[0]);
tbxNameVN.Text = menuBOL.Name_VN;
tbxDesVN.Text = menuBOL.Description_VN;
tbxNameEN.Text = menuBOL.Name_EN;
tbxDesEN.Text = menuBOL.Description_EN;
//---
if (menuBOL.ParentId > 0)
{
_parentId = menuBOL.ParentId;
}
}
public void StartLoadMenuDetail(int id, bool enableEdit = true)
{
string tag = _tag + "[St-artLoadMenuDetail]";
if (id <= 0)
{
return;
}
var result = MenuDAL.Get(id);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
hfMenuId.Value = id.ToString();
//---
try
{
if (!enableEdit)
{
this.btnAddSubMenu.Visible = false;
this.btnDeleteSubMenu.Visible = false;
}
MenuBOL menu = new MenuBOL(result.Data.Tables[0].Rows[0]);
btnAddSubMenu.Attributes.Add("data-id", menu.Id.ToString());
tbxNameVN.Text = menu.Name_VN;
tbxDesVN.Text = menu.Description_VN;
tbxNameEN.Text = menu.Name_EN;
tbxDesEN.Text = menu.Description_EN;
if (!string.IsNullOrEmpty(menu.Image))
{
imgImage.ImageUrl = "~/" + Path.Combine(Utilities.GetDirectory("ImagesDir"), menu.Image);
//imgImage.Visible = true;
}
//else
//{
// imgImage.Visible = false;
//}
//---
//if (menu.ParentId <= 0)
//{
// tbxNameVN.Enabled = false;
// tbxNameEN.Enabled = false;
//}
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
//---
lbError.InnerText = ex.Message;
lbError.Visible = true;
}
}
public static ResultBOL <int> InsertOrUpdate(MenuBOL obj)
{
string stored = "sp_Menu_Insert_Update";
var result = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters());
return(result);
}
private void CreateMenuBar()
{
var result = MenuDAL.GetAll();
if (result.Code < 0 || result.Data == null || result.Data.Tables.Count == 0)
{
return;
}
foreach (DataRow row in result.Data.Tables[0].Rows)
{
MenuBOL menu = new MenuBOL(row);
if (menu.ParentId > 0)
{
continue;
}
//---
_parentUrl = menu.RedirectUrl;
HtmlGenericControl li = new HtmlGenericControl("li");
li.InnerHtml = string.Format("<a href='{0}'>{1}</a>", menu.RedirectUrl, menu.Name_VN);
StartAddMenuItem(li, menu.Id, result.Data.Tables[0].Rows);
this.ulMenuBar.Controls.Add(li);
}
}
public static ResultBOL <int> InsertOrUpdate(MenuBOL obj)
{
//string type = GetType(obj.ParentId);
//if (!string.IsNullOrEmpty(type))
//{
// switch (type)
// {
// case "DichVu":
// return NewsDAL.InsertOrUpdate(new NewsBOL() {
// Name_EN = obj.Name_EN,
// Name_VN = obj.Name_VN,
// ImageLink = obj.Image,
// Type = type,
// ParentId = obj.ParentId
// });
// default:
// break;
// }
//}
string stored = "sp_Menu_Insert_Update";
var result = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters());
return(result);
}
public void StartLoadMenuDetail(int id)
{
string tag = _tag + "[StartLoadMenuDetail]";
if (id <= 0)
{
return;
}
var result = MenuDAL.Get(id);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
hfMenuId.Value = id.ToString();
//---
try
{
MenuBOL menu = new MenuBOL(result.Data.Tables[0].Rows[0]);
btnAddSubMenu.Attributes.Add("data-id", menu.Id.ToString());
tbxNameVN.Text = menu.Name_VN;
tbxDesVN.Text = menu.Description_VN;
tbxNameEN.Text = menu.Name_EN;
tbxDesEN.Text = menu.Description_EN;
//---
//if (menu.ParentId <= 0)
//{
// tbxNameVN.Enabled = false;
// tbxNameEN.Enabled = false;
//}
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
//---
lbError.InnerText = ex.Message;
lbError.Visible = true;
}
}
public static AllCategoriesModel GetAllServices(int id = 0)
{
#if DEBUG
_log.Debug("=================== Start ==================");
#endif
string stored = "sp_GetAllData_WithType";
object obj = new {
Type = "DichVu",
Id = id
};
ResultData <DataSet> result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
_log.Error(result.Message);
}
AllCategoriesModel model = new AllCategoriesModel();
if (result.Data != null && result.Data.Tables.Count > 1)
{
foreach (DataRow row in result.Data.Tables[0].Rows)
{
MenuBOL menu = new MenuBOL(row);
if (menu.ParentId > 0)
{
model.Roots.Add(menu);
}
}
foreach (DataRow row in result.Data.Tables[1].Rows)
{
NewsBOL news = new NewsBOL(row);
if (!news.Disable)
{
model.News.Add(news);
}
}
}
return(model);
}
private void UpdateMenuProcessing()
{
string tag = _tag + "[UpdateMenuProcessing]";
LogHelpers.WriteStatus(tag, "Start...");
try
{
MenuBOL menu = new MenuBOL()
{
Id = string.IsNullOrEmpty(hfMenuId.Value) ? 0 : int.Parse(hfMenuId.Value),
Name_VN = tbxNameVN.Text,
Name_EN = tbxNameEN.Text,
Image = StartUploadImage(),
Description_VN = tbxDesVN.Text,
Description_EN = tbxDesEN.Text,
InsertDate = DateTime.Now,
UpdatedDate = DateTime.Now
};
var result = MenuDAL.InsertOrUpdate(menu);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
//---
lbError.InnerText = ex.Message;
lbError.Visible = true;
}
finally
{
LogHelpers.WriteStatus(tag, "End.");
}
}
private void CreateMenuBar()
{
var result = MenuDAL.GetAll();
if (result.Code < 0 || result.Data == null || result.Data.Tables.Count == 0)
{
return;
}
foreach (DataRow row in result.Data.Tables[0].Rows)
{
MenuBOL menu = new MenuBOL(row);
if (menu.ParentId > 0)
{
continue;
}
//---
_parentUrl = menu.RedirectUrl;
HtmlGenericControl li = new HtmlGenericControl("li");
//---
if (!string.IsNullOrEmpty(menu.RedirectUrl) && menu.RedirectUrl.Contains("About.aspx"))
{
li.InnerHtml = string.Format("<a href='{0}'>{1}</a>",
"Introductions.aspx",
menu.Name_VN);
}
else
{
li.InnerHtml = string.Format("<a href='{0}'>{1}</a>",
menu.RedirectUrl,
menu.Name_VN);
}
StartAddMenuItem(li, menu.Id, result.Data.Tables[0].Rows);
this.ulMenuAdmin.Controls.Add(li);
}
//---
StartAddMenuOther();
}
private void StartAddMenuItem(HtmlGenericControl ctrlRoot, int parentId, DataRowCollection rows)
{
HtmlGenericControl ul = new HtmlGenericControl("ul");
foreach (DataRow row in rows)
{
MenuBOL menu = new MenuBOL(row);
if (menu.ParentId == parentId)
{
HtmlGenericControl li = new HtmlGenericControl("li");
li.InnerHtml = string.Format("<a href='{0}?MenuId={1}'>{2}</a>", _parentUrl, menu.Id, menu.Name_VN);
//---
ul.Controls.Add(li);
StartAddMenuItem(li, menu.Id, rows);
}
}
if (ul.Controls.Count > 0)
{
ctrlRoot.Controls.Add(ul);
}
}
public void ProcessRequest(HttpContext context)
{
string tag = "[AddSubMenuHandler][ProcessRequest]";
var jsonString = string.Empty;
context.Request.InputStream.Position = 0;
try
{
var inputStream = new StreamReader(context.Request.InputStream);
jsonString = inputStream.ReadToEnd();
inputStream.Close();
//--
MenuBOL menu = JsonConvert.DeserializeObject <MenuBOL>(jsonString);
menu.InsertDate = DateTime.Now;
menu.UpdatedDate = DateTime.Now;
var result = MenuDAL.InsertOrUpdate(menu);
//---
object obj = new {
Code = result.Code,
Message = result.ErrorMessage,
Id = result.DbReturnValue,
Name = menu.Name_VN
};
//---
string responseString = JsonConvert.SerializeObject(obj);
context.Response.ContentType = "application/json";
context.Response.Write(responseString);
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
}
}
private void StartAddSubMenuItem(HtmlGenericControl ctrlRoot, int parentId, DataRowCollection rows)
{
HtmlGenericControl ul = new HtmlGenericControl("ul");
foreach (DataRow row in rows)
{
MenuBOL menu = new MenuBOL(row);
if (menu.ParentId == parentId)
{
HtmlGenericControl li = new HtmlGenericControl("li");
if (menu.Childrens > 0)
{
li.InnerHtml = string.Format("<a href='{0}?MenuId={1}'>{2}</a>",
_parentUrl,
menu.Id,
Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN);
}
else
{
li.InnerHtml = string.Format("<a href='#'>{0}</a>",
Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN);
}
//---
ul.Controls.Add(li);
StartAddSubMenuItem(li, menu.Id, rows);
_menuFooter.Add(menu);
}
}
if (ul.Controls.Count > 0)
{
ctrlRoot.Controls.Add(ul);
}
}
public static AllCategoriesModel GetAllWithTypeGetAll(bool removeRoot = false)
{
string controller = HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString();
string type = "";
switch (controller)
{
case "About":
type = "GioiThieu";
break;
case "News":
type = "TinTuc";
break;
case "Train":
type = "DaoTao";
break;
case "Gallery":
type = "ThuVienHinh";
break;
default:
type = "DichVu";
break;
}
#if DEBUG
_log.Debug("type: {0}", type);
#endif
string stored = "sp_GetAllData_WithType";
object obj = new
{
Type = type
};
ResultData <DataSet> result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj);
if (result.Code < 0)
{
_log.Error(result.Message);
}
AllCategoriesModel model = new AllCategoriesModel();
model.PageType = (controller == "Home" || string.IsNullOrEmpty(controller)) ? "Service" : controller;
if (result.Data != null && result.Data.Tables.Count > 1)
{
foreach (DataRow row in result.Data.Tables[0].Rows)
{
MenuBOL menu = new MenuBOL(row);
if (removeRoot && menu.ParentId <= 0)
{
continue;
}
model.Roots.Add(menu);
}
if (controller.ToLower() != "gallery")
{
foreach (DataRow row in result.Data.Tables[1].Rows)
{
model.News.Add(new NewsBOL(row));
}
}
}
return(model);
}
public List <MenuBOL> CreateMenuBar()
{
//---
HtmlGenericControl liHome = new HtmlGenericControl("li");
string nameHome = Utilities.IsLangueEN() ? "Home" : "Trang Chủ";
liHome.InnerHtml = string.Format("<a href='{0}'>{1}</a>",
"Home.aspx",
nameHome);
//---
ulMenuBar.Controls.Add(liHome);
//----
var result = MenuDAL.GetAll();
if (result.Code < 0 || result.Data == null || result.Data.Tables.Count == 0)
{
return(null);
}
_menuFooter = new List <MenuBOL>();
foreach (DataRow row in result.Data.Tables[0].Rows)
{
MenuBOL menu = new MenuBOL(row);
if (menu.ParentId > 0)
{
continue;
}
this._menuFooter.Add(menu);
//---
_parentUrl = menu.RedirectUrl;
HtmlGenericControl li = new HtmlGenericControl("li");
//--
if (menu.Childrens > 0 || menu.Type == "DuAn")
{
li.InnerHtml = string.Format("<a href='{0}'>{1}</a>",
menu.RedirectUrl,
Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN);
}
else
{
li.InnerHtml = string.Format("<a href='#'>{0}</a>",
Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN);
}
if (menu.Type == "GioiThieu")
{
StartAddSubItemAbout(li, menu.Id);
}
else if (menu.Type == "LienHe")
{
StartAddSubMenuContact(li, menu.Id);
}
else
{
StartAddSubMenuItem(li, menu.Id, result.Data.Tables[0].Rows);
}
this.ulMenuBar.Controls.Add(li);
}
return(_menuFooter);
}
