protected override void ShowData(int menuCategoryId) { oDetailButtonPanel.SetId = SetId; var data = new MenuCategoryDataModel(); data.MenuCategoryId = menuCategoryId; var items = MenuCategoryDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblMenuCategoryId.Text = item.MenuCategoryId.ToString(); lblName.Text = item.Name.ToString(); lblDescription.Text = item.Description.ToString(); lblSortOrder.Text = item.SortOrder.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, menuCategoryId, "MenuCategoryId"); } else { Clear(); } }
public void Delete(string value) { var dataQuery = new MenuCategoryDataModel(); dataQuery.MenuCategoryId = int.Parse(value); MenuCategoryDataManager.Delete(dataQuery, SessionVariables.RequestProfile); }
public void LoadData(int menuCategoryId, bool showId) { Clear(); var data = new MenuCategoryDataModel(); data.MenuCategoryId = menuCategoryId; var items = MenuCategoryDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count != 1) { return; } var item = items[0]; SetData(item); if (!showId) { SystemKeyId = item.MenuCategoryId; oHistoryList.Setup(PrimaryEntity, menuCategoryId, PrimaryEntityKey); } else { CoreSystemKey.Text = String.Empty; } }
public override int?Save(string action) { var data = new MenuCategoryDataModel(); data.MenuCategoryId = SystemKeyId; data.Name = Name; data.Description = Description; data.SortOrder = SortOrder; if (action == "Insert") { var dtMenuCategory = MenuCategoryDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtMenuCategory.Rows.Count == 0) { MenuCategoryDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { MenuCategoryDataManager.Update(data, SessionVariables.RequestProfile); } return(data.MenuCategoryId); }
protected void btnDelete_Click(object sender, EventArgs e) { try { var notDeletableIds = new List <int>(); var deleteIndexList = DeleteIds.Split(','); foreach (var index in deleteIndexList) { var data = new MenuCategoryDataModel(); data.MenuCategoryId = int.Parse(index); if (!MenuCategoryDataManager.IsDeletable(data, SessionVariables.RequestProfile)) { notDeletableIds.Add((int)(data.MenuCategoryId)); } } if (notDeletableIds.Count == 0) { foreach (var index in deleteIndexList) { var data = new MenuCategoryDataModel(); data.MenuCategoryId = int.Parse(index); MenuCategoryDataManager.Delete(data, SessionVariables.RequestProfile); } } else { var msg = String.Empty; foreach (var id in notDeletableIds) { if (!string.IsNullOrEmpty(msg)) { msg += ", <br/>"; } msg += "MenuCategoryId: " + id + " has detail records"; } foreach (string index in deleteIndexList) { var data = new MenuCategoryDataModel(); data.MenuCategoryId = int.Parse(index); MenuCategoryDataManager.DeleteChildren(data, SessionVariables.RequestProfile); MenuCategoryDataManager.Delete(data, SessionVariables.RequestProfile); } } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
public MenuCategoryDataModel GetById(string value) { var dataQuery = new MenuCategoryDataModel(); dataQuery.MenuCategoryId = int.Parse(value); var result = MenuCategoryDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile, 1); return(result[0]); }
private DataTable GetData(string name) { var data = new MenuCategoryDataModel(); data.Name = name; var dt = MenuCategoryDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
// GET api/summary/GetList public IEnumerable <MenuCategoryDataModel> GetList(string value, string value1) { var settingCategory = value1; var searchString = value; var dictionaryObject = JsonConvert.DeserializeObject <Dictionary <string, string> >(searchString); // save search filter parameters in user preference if (dictionaryObject != null) { foreach (var searchFilterColumnName in dictionaryObject.Keys) { var searchFilterValue = dictionaryObject[searchFilterColumnName]; PerferenceUtility.UpdateUserPreference(settingCategory, searchFilterColumnName, dictionaryObject[searchFilterColumnName]); } } var dataQuery = JsonConvert.DeserializeObject <MenuCategoryDataModel>(searchString); return(MenuCategoryDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile)); }
// GET api/summary/GetList public IEnumerable <string> GetAutoCompleteList(string value, string value1) { var primaryEntity = value; var searchField = value1; var lstOptions = new List <string>(); if (primaryEntity.Equals("MenuCategory", StringComparison.InvariantCultureIgnoreCase)) { if (searchField == "Name") { var dt = MenuCategoryDataManager.GetList(SessionVariables.RequestProfile); lstOptions = (from row in dt.AsEnumerable() select row["Name"].ToString().Trim()).ToList(); } } else if (primaryEntity.Equals("Question", StringComparison.InvariantCultureIgnoreCase)) { if (searchField == "QuestionPhrase") { var dt = QuestionDataManager.GetList(SessionVariables.RequestProfile); lstOptions = (from row in dt.AsEnumerable() select row["QuestionPhrase"].ToString().Trim()).ToList(); } } else if (primaryEntity.Equals("Log4Net", StringComparison.InvariantCultureIgnoreCase)) { if (searchField == "Computer") { lstOptions = Framework.Components.LogAndTrace.Log4NetDataManager.GetComputerDetails(SessionVariables.RequestProfile); } if (searchField == "ConnectionKey") { lstOptions = Framework.Components.LogAndTrace.Log4NetDataManager.GetConnectionKeyList(SessionVariables.RequestProfile); } } return(lstOptions); }
public void Update([FromBody] MenuCategoryDataModel data) { MenuCategoryDataManager.Update(data, SessionVariables.RequestProfile); }
protected override DataTable GetData() { var dt = MenuCategoryDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile); return(dt); }