private static List <MicroMenu> GetMicroMenusByLoginName()
{
List <MicroMenu> MicroMenuList = new List <MicroMenu>();
DataTable MicroMenuTable = MicroMenuDataAccess.GetInstance.GetMicroMenusByLoginName();
foreach (DataRow dr in MicroMenuTable.Rows)
{
MicroMenu TheMicroMenu = DataRowToObject(dr);
MicroMenuList.Add(TheMicroMenu);
}
return(MicroMenuList);
}
public static MicroMenu GetMicroMenuByID(int menuID)
{
MicroMenu TheMicroMenu;
DataRow MicroMenuDataRow = MicroMenuDataAccess.GetInstance.GetMicroMenuByID(menuID);
if (MicroMenuDataRow != null)
{
TheMicroMenu = DataRowToObject(MicroMenuDataRow);
}
else
{
TheMicroMenu = new MicroMenu();
}
return(TheMicroMenu);
}
public static MicroMenu DataRowToObject(DataRow dr)
{
MicroMenu TheMicroMenu = new MicroMenu
{
MenuID = int.Parse(dr["MenuID"].ToString()),
MenuItemName = dr["MenuItemName"].ToString(),
ShortCutKey = dr["ShortCutKey"].ToString(),
ShortCutDisplayString = dr["ShortCutDisplayString"].ToString(),
ParentMenuID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentMenuID"].ToString())),
ModuleID = int.Parse(dr["ModuleID"].ToString()),
FormID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["FormID"].ToString())),
FormName = dr["FormName"].ToString(),
ActualFormName = dr["ActualFormName"].ToString(),
ActualFormClassName = dr["ActualFormClassName"].ToString(),
DisplayOrder = int.Parse(dr["DisplayOrder"].ToString()),
IsActive = bool.Parse(dr["IsActive"].ToString()),
IsDeleted = bool.Parse(dr["IsDeleted"].ToString())
};
return(TheMicroMenu);
}
public int UpdateMenu(MicroMenu theMenu)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@MenuID", SqlDbType.Int, theMenu.MenuID));
UpdateCommand.Parameters.Add(GetParameter("@ParentMenuID", SqlDbType.Int, theMenu.ParentMenuID));
UpdateCommand.Parameters.Add(GetParameter("@MenuItemName", SqlDbType.VarChar, theMenu.MenuItemName));
UpdateCommand.Parameters.Add(GetParameter("@ShortcutKey", SqlDbType.VarChar, theMenu.ShortCutKey));
UpdateCommand.Parameters.Add(GetParameter("@ShortcutDisplayString", SqlDbType.VarChar, theMenu.ShortCutDisplayString));
UpdateCommand.Parameters.Add(GetParameter("@DisplayOrder", SqlDbType.Int, theMenu.DisplayOrder));
UpdateCommand.Parameters.Add(GetParameter("@ModuleID", SqlDbType.Int, theMenu.ModuleID));
UpdateCommand.Parameters.Add(GetParameter("@FormID", SqlDbType.Int, theMenu.FormID));
UpdateCommand.Parameters.Add(GetParameter("@isActive", SqlDbType.Bit, theMenu.IsActive));
UpdateCommand.CommandText = "pADM_MenuItems_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int InsertMenu(MicroMenu theMenu)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@ParentMenuID", SqlDbType.Int, theMenu.ParentMenuID));
InsertCommand.Parameters.Add(GetParameter("@MenuItemName", SqlDbType.VarChar, theMenu.MenuItemName));
InsertCommand.Parameters.Add(GetParameter("@ShortcutKey", SqlDbType.VarChar, theMenu.ShortCutKey));
InsertCommand.Parameters.Add(GetParameter("@ShortcutDisplayString", SqlDbType.VarChar, theMenu.ShortCutDisplayString));
InsertCommand.Parameters.Add(GetParameter("@DisplayOrder", SqlDbType.Int, theMenu.DisplayOrder));
InsertCommand.Parameters.Add(GetParameter("@ModuleID", SqlDbType.Int, theMenu.ModuleID));
InsertCommand.Parameters.Add(GetParameter("@FormID", SqlDbType.Int, theMenu.FormID));
InsertCommand.Parameters.Add(GetParameter("@IsActive", SqlDbType.Bit, theMenu.IsActive));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pADM_MenuItems_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int UpdateMenu(MicroMenu theMenu)
{
return(MicroMenuIntegration.UpdateMenu(theMenu));
}
public int InsertMenu(MicroMenu theMenu)
{
return(MicroMenuIntegration.InsertMenu(theMenu));
}
public static int UpdateMenu(MicroMenu theMenu)
{
return(MicroMenuDataAccess.GetInstance.UpdateMenu(theMenu));
}
public static int InsertMenu(MicroMenu theMenu)
{
return(MicroMenuDataAccess.GetInstance.InsertMenu(theMenu));
}
