/// <summary>
/// Gets the User rights from the u_UserRights table according to MenuTag
/// </summary>
/// <param name="objURight">Object of a u_UserRights class in smartOffice_Models</param>
/// <returns>DataTable filled with User rights</returns>
public DataTable GetUserRightsToMenuTag(u_UserRights objURight)
{
try
{
if (objURight.User.strUserID == "")
{
strQuery = "select t.menuId as [Menu ID],t.description as [Menu Name],t.menuRights as [Menu Rights],t.mainOrder,t.subOrder from u_MenuTag t";
}
else
{
strQuery = "select u.roleId as [Role ID],url.description as [Role Name], ur.userId as [User ID]," +
"ur.menuId as [Menu ID],ur.menuRights as [Menu Rights],m.description as [Menu Name] " +
"from u_UserRights ur inner join u_MenuTag m on m.menuId=ur.menuId " +
"inner join u_User u on u.userId=ur.userId " +
"right outer join u_UserRoles url on url.roleId=u.roleId " +
"where ur.userId='" + objURight.User.strUserID + "' and ur.menuId='" + objURight.MenuTag.strMenuID + "'";
}
DataTable dtURights = u_DBConnection.ReturnDataTable(strQuery, CommandType.Text);
return(dtURights);
}
catch (Exception ex)
{
throw ex;
}
}
public static u_UserRights_DL GetUserRightObj(string formID, string user)
{
u_UserRights objUserRight = new u_UserRights();
objUserRight.User = new u_User();
objUserRight.MenuTag = new u_MenuTag();
objUserRight.User.strUserID = Globals.g_strUser;
objUserRight.MenuTag.strMenuID = formID.Trim();
u_UserRights_DL objURightDL = new u_UserRights_DL();
u_UserRights_DL dtAllMenuItems = objURightDL.GetUserRightsForOneMenu(objUserRight);
return(dtAllMenuItems);
}
/// <summary>
/// Update the Data in the u_UserRights table in the database
/// </summary>
/// <param name="objUserRight">Object of a u_UserRights class in smartOffice_Models</param>
/// <returns>If Updated Successfully,returns true, else false</returns>
public bool UpdateRights(u_UserRights objUserRight)
{
try
{
strQuery = "update u_UserRights set menuRights='" + objUserRight.strMenuRights + "' " +
"where userId='" + objUserRight.User.strUserID + "' and " +
"menuId=(select menuId from u_MenuTag where description='" + objUserRight.MenuTag.strDescription + "')";
u_DBConnection.ExecuteNonQuery(strQuery);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Save the Data in the u_UserRights table in the database
/// </summary>
/// <param name="objUserRight">Object of a u_UserRights class in smartOffice_Models</param>
/// <returns>If saved Successfully,returns true, else false</returns>
public bool SaveUserRights(u_UserRights objUserRight)
{
try
{
strQuery = "insert into u_UserRights(userId,menuId,menuRights) " +
"values('" + objUserRight.User.strUserID + "',(select menuId from u_MenuTag where description='" + objUserRight.MenuTag.strDescription + "')," +
"'" + objUserRight.strMenuRights + "')";
u_DBConnection.ExecuteNonQuery(strQuery);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//select ur.menuRights as [Menu Rights] from u_UserRights ur inner join u_MenuTag m on m.menuId=ur.menuId inner join u_User u on u.userId=ur.userId right outer join u_UserRoles url on url.roleId=u.roleId where ur.userId='Admin' and ur.menuId = 'A0003'
/// <summary>
/// Gets the User rights from the u_UserRoleRights table
/// </summary>
/// <param name="objURight">Object of a u_UserRights class in smartOffice_Models</param>
/// <returns>DataTable filled with User Role rights</returns>
public DataTable GetUserRoleRightsToUserID(u_UserRights objURight)
{
try
{
strQuery = "select ur.roleId as [Role ID],ur.menuId as [Menu ID],ur.menuRights as [Menu Rights],m.description as [Menu Name],url.description as [Role Name] " +
"from u_UserRoleRights ur inner join u_MenuTag m on m.menuId=ur.menuId inner join u_UserRoles url on url.roleId=ur.roleId " +
"where ur.roleId=(select roleId from u_User where userId='" + objURight.User.strUserID + "')";
DataTable dtURights = u_DBConnection.ReturnDataTable(strQuery, CommandType.Text);
return(dtURights);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get MenuRights for each userId and MenuID
/// </summary>
/// <param name="UserID">Logged user id</param>
/// <returns>DataTable filled with menu rights</returns>
public static DataTable CheckMenuaccess(string UserID)
{
try
{
u_UserRights objUserRight = new u_UserRights();
objUserRight.User = new u_User();
objUserRight.MenuTag = new u_MenuTag();
u_UserRights_BL objUserRghtsBL = new u_UserRights_BL();
objUserRight.User.strUserID = UserID;
objUserRight.MenuTag.strMenuID = g_MenuId;
DataTable dt = objUserRghtsBL.GetUserRightsToMenuTag(objUserRight);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public u_UserRights_DL GetUserRightsForOneMenu(u_UserRights objURight)
{
try
{
strQuery = "select ur.menuRights as [Menu Rights] from u_UserRights ur inner join u_MenuTag m on m.menuId=ur.menuId inner join u_User u on u.userId=ur.userId" +
" right outer join u_UserRoles url on url.roleId=u.roleId where ur.userId='" +
objURight.User.strUserID.Trim() +
"' and ur.menuId = '" +
objURight.MenuTag.strMenuID.Trim() + "'";
DataTable dtURights = u_DBConnection.ReturnDataTable(strQuery, CommandType.Text);
return(CreateUserRights_DL(dtURights));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Check whether user enterd UserID and menuID is exist or not
/// </summary>
/// <param name="objUserRight">Object of a u_UserRights class in smartOffice_Models</param>
/// <returns>If exist in the database,returns true, else false</returns>
public bool ExistingUserRights(u_UserRights objUserRight)
{
try
{
strQuery = "select menuRights from u_UserRights where userId='" + objUserRight.User.strUserID + "'" +
" and menuId=(select menuId from u_MenuTag where description='" + objUserRight.MenuTag.strDescription + "')";
DataRow drUserRight = u_DBConnection.ReturnDataRow(strQuery);
if (drUserRight != null)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
/*FunctionButtonStatus Was created by Asanga Chandrakumara on 12:18 PM 6/24/2015*/
/// <summary>
/// THis function will enable and disable the button status as required
/// </summary>
/// <param name="typex">Enumaration to function type</param>
public void FunctionButtonStatus(xEnums.PerformanceType typex)
{
u_UserRights objUserRight = new u_UserRights();
objUserRight.User = new u_User();
objUserRight.MenuTag = new u_MenuTag();
objUserRight.User.strUserID = Globals.g_strUser;
objUserRight.MenuTag.strMenuID = formID.Trim();
u_UserRights_DL objURightDL = new u_UserRights_DL();
u_UserRights_DL dtAllMenuItems = objURightDL.GetUserRightsForOneMenu(objUserRight);
switch (typex)
{
case xEnums.PerformanceType.Save:
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
btn_cancel.Enabled = false;
btn_save.Enabled = false;
btn_delete.Enabled = dtAllMenuItems.boolDelete;
btn_edit.Enabled = dtAllMenuItems.boolModify;
btn_print.Enabled = dtAllMenuItems.boolPrint;
}
else
{
btn_cancel.Enabled = false;
btn_save.Enabled = false;
btn_new.Enabled = true;
btn_delete.Enabled = dtAllMenuItems.boolDelete;
btn_edit.Enabled = dtAllMenuItems.boolModify;
btn_print.Enabled = dtAllMenuItems.boolPrint;
}
break;
case xEnums.PerformanceType.Delete: //when press the delete button
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
}
else
{
btn_cancel.Enabled = false;
btn_save.Enabled = false;
btn_new.Enabled = true;
btn_delete.Enabled = false;
btn_edit.Enabled = false;
btn_print.Enabled = false;
}
break;
case xEnums.PerformanceType.Existing: //enter existing item to system
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
}
else
{
btn_cancel.Enabled = true;
btn_save.Enabled = false;
btn_new.Enabled = false;
btn_delete.Enabled = dtAllMenuItems.boolDelete;
btn_edit.Enabled = dtAllMenuItems.boolModify;
btn_print.Enabled = dtAllMenuItems.boolPrint;
}
break;
case xEnums.PerformanceType.Edit: //enter existing item to system and press edit
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
btn_cancel.Enabled = true;
btn_save.Enabled = true;
btn_new.Enabled = dtAllMenuItems.boolCreate;
btn_delete.Enabled = dtAllMenuItems.boolDelete;
btn_edit.Enabled = false;
btn_print.Enabled = dtAllMenuItems.boolPrint;
}
else
{
btn_cancel.Enabled = true;
btn_save.Enabled = true;
btn_new.Enabled = false;
btn_delete.Enabled = false;
btn_edit.Enabled = false;
btn_print.Enabled = false;
}
break;
case xEnums.PerformanceType.Exit:
break;
case xEnums.PerformanceType.New:
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
}
else
{
btn_cancel.Enabled = true;
btn_save.Enabled = true;
btn_new.Enabled = false;
btn_delete.Enabled = false;
btn_edit.Enabled = false;
btn_print.Enabled = false;
}
break;
case xEnums.PerformanceType.Default:
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
btn_delete.Enabled = dtAllMenuItems.boolDelete;
btn_edit.Enabled = dtAllMenuItems.boolModify;
btn_print.Enabled = dtAllMenuItems.boolPrint;
btn_save.Enabled = false;
btn_cancel.Enabled = false;
}
else
{
btn_cancel.Enabled = false;
btn_save.Enabled = false;
btn_new.Enabled = true;
btn_delete.Enabled = dtAllMenuItems.boolDelete;
btn_edit.Enabled = dtAllMenuItems.boolModify;
btn_print.Enabled = dtAllMenuItems.boolPrint;
}
break;
case xEnums.PerformanceType.Cancel:
if (dtAllMenuItems.boolCreate == false)
{
btn_new.Enabled = false;
}
else
{
btn_cancel.Enabled = false;
btn_save.Enabled = false;
btn_new.Enabled = true;
btn_delete.Enabled = false;
btn_edit.Enabled = false;
btn_print.Enabled = false;
}
break;
}
}
/// <summary>
/// This will disable menues if they don't have acccess to incoming user searched by the Menu ID
/// So when ever you change the text of the form will not effect to this method
/// just put the tlStrpMenuItem_ +menu ID to the menu name and all done
/// </summary>
public void MenuStripItemsVisible()
{
u_UserRights objUserRight = new u_UserRights();
objUserRight.User = new u_User();
objUserRight.MenuTag = new u_MenuTag();
u_UserRights_BL objUserRghtsBL = new u_UserRights_BL();
objUserRight.User.strUserID = Globals.g_strUser;
objUserRight.MenuTag.strMenuID = Globals.g_MenuId;
u_UserRights_DL objURightDL = new u_UserRights_DL();
DataTable dtAllMenuItems = objURightDL.GetUserRights(objUserRight);
//DataTable dtAllMenuItems = objUserRghtsBL.GetUserRights(objUserRight);
if (Globals.g_strUser.Trim().ToUpper() != "ADMIN")
{
if (dtAllMenuItems.Rows.Count != 0)
{
for (int i = 0; i < dtAllMenuItems.Rows.Count; i++)
{
if (Convert.ToBoolean(dtAllMenuItems.Rows[i]["dtAccess"].ToString()) == false)
{
string strEditUIName = (dtAllMenuItems.Rows[i]["Code"].ToString()).Replace(" ", "");
string strtlStrpMenuItemName = strEditUIName;
List <ToolStripMenuItem> myItems = GetItems(this.menuStrip);
foreach (var item in myItems)
{
item.ForeColor = Color.FromArgb(126, 26, 29);
item.Text = item.Text.ToUpper();
if (item.Name == strtlStrpMenuItemName)
{
item.Enabled = false;
}
}
foreach (ToolStripItem ctrl in this.toolStrip.Items)
{
ctrl.Text = ctrl.Text.ToUpper();
if (ctrl.Name.Trim().ToUpper() == "T" + strtlStrpMenuItemName.Trim().ToUpper())
{
ctrl.Enabled = false;
}
}
foreach (ToolStripItem ctrl in this.contextMenuStrip1.Items)
{
ctrl.Text = ctrl.Text.ToUpper();
ctrl.ForeColor = Color.FromArgb(126, 26, 29);
if (ctrl.Name.Trim().ToUpper() == "C" + strtlStrpMenuItemName.Trim().ToUpper())
{
ctrl.Enabled = false;
}
}
}
else
{
string strEditUIName = (dtAllMenuItems.Rows[i]["Code"].ToString()).Replace(" ", "");
string strtlStrpMenuItemName = strEditUIName;
List <ToolStripMenuItem> myItems = GetItems(this.menuStrip);
foreach (var item in myItems)
{
item.ForeColor = Color.FromArgb(126, 26, 29);
item.Text = item.Text.ToUpper();
if (item.Name == strtlStrpMenuItemName)
{
item.Enabled = true;
}
}
foreach (ToolStripItem ctrl in this.toolStrip.Items)
{
ctrl.Text = ctrl.Text.ToUpper();
if (ctrl.Name.Trim().ToUpper() == "T" + strtlStrpMenuItemName.Trim().ToUpper())
{
ctrl.Enabled = true;
}
}
foreach (ToolStripItem ctrl in this.contextMenuStrip1.Items)
{
ctrl.Text = ctrl.Text.ToUpper();
ctrl.ForeColor = Color.FromArgb(126, 26, 29);
if (ctrl.Name.Trim().ToUpper() == "C" + strtlStrpMenuItemName.Trim().ToUpper())
{
ctrl.Enabled = true;
}
}
}
}
}
else
{
//implement locking system
List <ToolStripMenuItem> myItems = GetItems(this.menuStrip);
foreach (var item in myItems)
{
item.ForeColor = Color.FromArgb(126, 26, 29);
item.Text = item.Text.ToUpper();
item.Enabled = false;
}
foreach (ToolStripItem ctrl in this.toolStrip.Items)
{
if (ctrl.Name.Trim().ToUpper() == "shutdown_ToolBar".Trim().ToUpper())
{
}
else
{
ctrl.Text = ctrl.Text.ToUpper();
ctrl.Enabled = false;
}
}
foreach (ToolStripItem ctrl in this.contextMenuStrip1.Items)
{
ctrl.Text = ctrl.Text.ToUpper();
ctrl.ForeColor = Color.FromArgb(126, 26, 29);
ctrl.Enabled = false;
}
}
}
else
{
// if login user is administrator
}
}
