/// <summary>
/// Get all protection of menu entry
/// </summary>
/// <returns>Menu entry dataset</returns>
public DataSet GetAllProtection()
{
var dsSysMenuEntry = new Sys_Menu_EntryDS();
DataSet dstData = dsSysMenuEntry.GetAllProtection();
return(dstData);
}
/// <summary>
/// Update data table
/// </summary>
public void UpdateDataTable(DataTable pdtbData)
{
const string METHOD_NAME = THIS + ".Delete()";
try
{
using (var trans = new TransactionScope())
{
var dsMenuEntry = new Sys_Menu_EntryDS();
dsMenuEntry.UpdateDataTable(pdtbData);
trans.Complete();
}
}
catch (SqlException ex)
{
if (ex.Errors.Count > 1)
{
if (ex.Number == ErrorCode.SQLDUPLICATE_UNIQUE_KEYCODE)
{
throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex);
}
throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex);
}
throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex);
}
}
/// <summary>
/// We need to check this menu is already have transaction or not.
/// If have transaction, unable to delete.
/// If have no transaction, delete it
/// </summary>
public void Delete(int menuId)
{
const string METHOD_NAME = THIS + ".Delete()";
try
{
using (var trans = new TransactionScope())
{
var dcPCS = new PCSDataContext(Utils.Instance.ConnectionString);
var menu = dcPCS.Sys_Menu_Entries.SingleOrDefault(m => m.Menu_EntryID == menuId);
var objRights = dcPCS.Sys_Rights.SingleOrDefault(m => m.Menu_EntryID == menuId);
var dsMenuEntry = new Sys_Menu_EntryDS();
// we need to check this menu is already have transaction or not
int intNumOfTrans = 0;
if (menu.TableName != null)
{
if (menu.TableName.Trim() != string.Empty && menu.TransNoFieldName.Trim() != string.Empty)
{
intNumOfTrans = dsMenuEntry.GetAllTransactions(menu);
}
}
// if have transaction, unable to delete
if (intNumOfTrans > 0)
{
throw new PCSBOException(ErrorCode.MESSAGE_COULD_NOT_DELETE_MENU, METHOD_NAME, new Exception());
}
// update button caption
var subMenus = dcPCS.Sys_Menu_Entries.Where(
m => m.Parent_Shortcut == menu.Shortcut && m.Button_Caption > menu.Button_Caption).OrderBy(
m => m.Button_Caption).ToList();
subMenus.ForEach(m => m.Button_Caption = m.Button_Caption - 1);
// if have no transction, delete it
if (objRights != null)
{
dcPCS.Sys_Rights.DeleteOnSubmit(objRights);
}
dcPCS.Sys_Menu_Entries.DeleteOnSubmit(menu);
// submit changes
dcPCS.SubmitChanges();
trans.Complete();
}
}
catch (SqlException ex)
{
if (ex.Errors.Count > 1)
{
if (ex.Number == ErrorCode.SQLCASCADE_PREVENT_KEYCODE)
{
throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex);
}
throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex);
}
throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex);
}
}
/// <summary>
/// Get all menu items with image fields
/// </summary>
/// <param name="pobjCulture">Current culture</param>
/// <returns>ArrayList object</returns>
/// <author> Duong NA - Sep 23, 2005</author>
public ArrayList GetAllMenusWithImageFields(CultureInfo pobjCulture)
{
var dsSys_Menu_Entry = new Sys_Menu_EntryDS();
return(dsSys_Menu_Entry.GetAllMenusWithImageFields(pobjCulture));
}
/// <summary>
/// Get all menu items with image fields by specific user
/// </summary>
/// <param name="pobjCulture">Current culture</param>
/// <param name="pstrUserName">User name</param>
/// <returns>ArrayList object</returns>
/// <author> Duong NA - Sep 23, 2005</author>
public List <Sys_Menu_Entry> GetAllMenusWithImageFields(CultureInfo pobjCulture, string pstrUserName)
{
var dsSys_Menu_Entry = new Sys_Menu_EntryDS();
return(dsSys_Menu_Entry.GetAllMenusWithImageFields(pobjCulture, pstrUserName));
}
/// <summary>
/// Get all menu items in current culture of a specified user
/// </summary>
/// <param name="pobjCulture">Current culture</param>
/// <param name="pstrUserName">Current user</param>
/// <returns></returns>
/// <author> Tuan DM - Jan 14, 2005</author>
public ArrayList GetAllMenus(CultureInfo pobjCulture, string pstrUserName)
{
var dsSys_Menu_Entry = new Sys_Menu_EntryDS();
return(dsSys_Menu_Entry.GetAllMenus(pobjCulture, pstrUserName));
}
/// <summary>
/// Get menu by its short cut
/// </summary>
/// <param name="pstrShortCut">Shortcut of menu</param>
/// <returns>SysMenu</returns>
public object GetMenuByShortCut(string pstrShortCut)
{
var dsMenuEntry = new Sys_Menu_EntryDS();
return(dsMenuEntry.GetMenuByShortCut(pstrShortCut));
}
