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);
}
