/// <summary>
/// Method to Delete UserRights
/// </summary>
/// <param name="argEn">UserRights Entity is an Input.UserGroup as Input Property.</param>
/// <returns>Returns Boolean</returns>
public bool Delete(UserRightsEn argEn)
{
bool lbRes = false;
string sqlCmd = "DELETE FROM UR_UserRights WHERE UserGroupId =@UserGroupID";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@UserGroupId", DbType.Int32, argEn.UserGroup);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Insertion Failed! No Row has been updated...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Insert UserGroupsMenu
/// </summary>
/// <param name="argEn">UserGroups Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool InsertUserGroupMenu(UserGroupsEn argEn)
{
List <UserRightsEn> loEnList = new List <UserRightsEn>();
string sqlCmd = "select * from UR_MenuMaster ";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
UserRightsEn loItem = new UserRightsEn();
loItem.MenuID = GetValue <int>(loReader, "MenuID");
loItem.UserGroup = argEn.UserGroupId;
loItem.LastUser = argEn.LastUpdatedBy;
loItem.LastDtTm = argEn.LastUpdatedDtTm;
loEnList.Add(loItem);
}
loReader.Close();
}
UserRightsDAL userRights = new UserRightsDAL();
userRights.InsertUserRights(loEnList);
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
/// <summary>
/// Method to Get UserRights Entity
/// </summary>
/// <param name="argEn">UserRights Entity is an Input.</param>
/// <returns>Returns UserRights Entity</returns>
public UserRightsEn GetItem(UserRightsEn argEn)
{
UserRightsEn loItem = new UserRightsEn();
string sqlCmd = "Select * FROM UR_UserRights ";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
if (loReader != null)
{
loReader.Read();
loItem = LoadObject(loReader);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loItem);
}
/// <summary>
/// Method to Get List of Active UserRights
/// </summary>
/// <param name="argEn">UserRights Entity as an Input.</param>
/// <returns>Returns List of UserRights</returns>
public List <UserRightsEn> GetList(UserRightsEn argEn)
{
List <UserRightsEn> loEnList = new List <UserRightsEn>();
string sqlCmd = "select * from UR_UserRights";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
UserRightsEn loItem = LoadObject(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Get List of All UserRights by UserGroupID
/// </summary>
/// <param name="UserGroupID">UserGroupID as an Input.</param>
/// <returns>Returns List of UserRights</returns>
/// edited by Hafiz @ 30/9/2016
/// remove "UR_MenuMaster.MenuID <> 114 AND"
public List <UserRightsEn> GetUserMenu(int UserGroupID)
{
List <UserRightsEn> loEnList = new List <UserRightsEn>();
string sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_UserRights.IsAdd, " +
"UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, UR_UserRights.IsPost, UR_UserRights.IsOthers, UR_UserRights.IsPrint," +
"UR_UserRights.DefaultMode,UR_UserRights.UserGroupId FROM UR_MenuMaster INNER JOIN " +
"UR_UserRights ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE " +
"UR_MenuMaster.Status = true AND " +
"UR_UserRights.UserGroupId =" + UserGroupID + " order by UR_MenuMaster.MenuName desc";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
UserRightsEn loItem = LoadObject(loReader);
loItem.MenuName = GetValue <string>(loReader, "MenuName");
loItem.PageName = GetValue <string>(loReader, "PageName");
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
private UserRightsEn LoadURMenu(IDataReader argReader)
{
UserRightsEn loItem = new UserRightsEn();
loItem.MenuID = GetValue <int>(argReader, "MenuID");
loItem.MenuName = GetValue <string>(argReader, "MenuName");
loItem.PageName = GetValue <string>(argReader, "PageName");
return(loItem);
}
/// <summary>
/// Method to Get UserRights Entity
/// </summary>
/// <param name="argEn">UserRights Entity is an Input.</param>
/// <returns>Returns UserRights Entity</returns>
public UserRightsEn GetItem(UserRightsEn argEn)
{
try
{
UserRightsDAL loDs = new UserRightsDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get List of All UserRights by UserGroupID
/// </summary>
/// <param name="argEn">UserGroupID as an Input.</param>
/// <returns>Returns List of UserRights</returns>
public List <UserRightsEn> GetList(UserRightsEn argEn)
{
try
{
UserRightsDAL loDs = new UserRightsDAL();
return(loDs.GetList(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Check Validation
/// </summary>
/// <param name="argEn">UserRights Entity as Input.</param>
/// <returns>Returns a Boolean</returns>
public bool IsValid(UserRightsEn argEn)
{
try
{
//if (argEn.UserGroup == null || argEn.UserGroup.ToString().Length <= 0)
if (argEn.UserGroup.ToString().Length <= 0)
{
throw new Exception("UserGroup Is Required!");
}
//if (argEn.MenuID == null || argEn.MenuID.ToString().Length <= 0)
if (argEn.MenuID.ToString().Length <= 0)
{
throw new Exception("MenuID Is Required!");
}
//if (argEn.IsAdd == null || argEn.IsAdd.ToString().Length <= 0)
if (argEn.IsAdd.ToString().Length <= 0)
{
throw new Exception("IsAdd Is Required!");
}
//if (argEn.IsEdit == null || argEn.IsEdit.ToString().Length <= 0)
if (argEn.IsEdit.ToString().Length <= 0)
{
throw new Exception("IsEdit Is Required!");
}
//if (argEn.IsDelete == null || argEn.IsDelete.ToString().Length <= 0)
if (argEn.IsDelete.ToString().Length <= 0)
{
throw new Exception("IsDelete Is Required!");
}
//if (argEn.IsView == null || argEn.IsView.ToString().Length <= 0)
if (argEn.IsView.ToString().Length <= 0)
{
throw new Exception("IsView Is Required!");
}
//if (argEn.IsPrint == null || argEn.IsPrint.ToString().Length <= 0)
if (argEn.IsPrint.ToString().Length <= 0)
{
throw new Exception("IsPrint Is Required!");
}
//if (argEn.IsAddModeDefault == null || argEn.IsAddModeDefault.ToString().Length <= 0)
if (argEn.IsAddModeDefault.ToString().Length <= 0)
{
throw new Exception("IsAddModeDefault Is Required!");
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Insert UserRights
/// </summary>
/// <param name="argEn">UserRights Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Insert(UserRightsEn argEn)
{
bool lbRes = false;
string sqlCmd;
try
{
//Checking for Duplicates
sqlCmd = "INSERT INTO UR_UserRights(UserGroupId,MenuID,IsAdd,IsEdit,IsDelete,IsView,IsPrint,IsPost,IsOthers,DefaultMode,LastUpdatedBy,LastUpdatedDtTm) VALUES (@UserGroupId,@MenuID,@IsAdd,@IsEdit,@IsDelete,@IsView,@IsPrint,@IsPost,@IsOthers,@DefaultMode,@LastUpdatedBy,@LastUpdatedDtTm) ";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@UserGroupId", DbType.Int32, argEn.UserGroup);
_DatabaseFactory.AddInParameter(ref cmd, "@MenuID", DbType.Int32, argEn.MenuID);
_DatabaseFactory.AddInParameter(ref cmd, "@IsAdd", DbType.Boolean, argEn.IsAdd);
_DatabaseFactory.AddInParameter(ref cmd, "@IsEdit", DbType.Boolean, argEn.IsEdit);
_DatabaseFactory.AddInParameter(ref cmd, "@IsDelete", DbType.Boolean, argEn.IsDelete);
_DatabaseFactory.AddInParameter(ref cmd, "@IsView", DbType.Boolean, argEn.IsView);
_DatabaseFactory.AddInParameter(ref cmd, "@IsPrint", DbType.Boolean, argEn.IsPrint);
_DatabaseFactory.AddInParameter(ref cmd, "@IsPost", DbType.Boolean, argEn.IsPost);
_DatabaseFactory.AddInParameter(ref cmd, "@IsOthers", DbType.Boolean, argEn.IsOthers);
_DatabaseFactory.AddInParameter(ref cmd, "@DefaultMode", DbType.Boolean, argEn.IsAddModeDefault);
_DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedBy", DbType.String, argEn.LastUser);
_DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedDtTm", DbType.DateTime, Helper.DateConversion(argEn.LastDtTm));
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Insertion Failed! No Row has been updated...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
private UserRightsEn LoadObjectUser(IDataReader argReader)
{
UserRightsEn loItem = new UserRightsEn();
loItem.MenuID = GetValue <int>(argReader, "MenuID");
loItem.MenuName = GetValue <string>(argReader, "MenuName");
loItem.PageName = GetValue <string>(argReader, "PageName");
loItem.IsAdd = GetValue <bool>(argReader, "IsAdd");
loItem.IsEdit = GetValue <bool>(argReader, "IsEdit");
loItem.IsDelete = GetValue <bool>(argReader, "IsDelete");
loItem.IsView = GetValue <bool>(argReader, "IsView");
loItem.IsPrint = GetValue <bool>(argReader, "IsPrint");
loItem.IsPost = GetValue <bool>(argReader, "IsPost");
loItem.IsOthers = GetValue <bool>(argReader, "IsOthers");
loItem.IsAddModeDefault = GetValue <bool>(argReader, "DefaultMode");
return(loItem);
}
/// <summary>
/// Method to Delete UserRights
/// </summary>
/// <param name="argEn">UserRights Entity is an Input.UserGroup as Input Property.</param>
/// <returns>Returns Boolean</returns>
public bool Delete(UserRightsEn argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
UserRightsDAL loDs = new UserRightsDAL();
flag = loDs.Delete(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
protected void LoadUserRights()
{
UsersBAL usersBal = new UsersBAL();
UserRightsEn userRightsEn = new UserRightsEn();
userRightsEn = usersBal.GetUserRights(Convert.ToInt32(Request.QueryString["Menuid"]), Convert.ToInt32(Session[Helper.UserGroupSession]));
if (userRightsEn.IsAdd)
{
ibtnSave.Enabled = true;
}
else
{
ibtnNew.Enabled = false;
ibtnNew.ImageUrl = "../images/gAdd.png";
ibtnNew.ToolTip = "Access Denied";
ibtnDelete.Enabled = false;
ibtnDelete.ImageUrl = "../images/gdelete.png";
ibtnDelete.ToolTip = "Access Denied";
ibtnFirst.Enabled = false;
ibtnLast.Enabled = false;
ibtnPrevs.Enabled = false;
ibtnNext.Enabled = false;
ibtnFirst.ToolTip = "Access Denied";
ibtnLast.ToolTip = "Access Denied";
ibtnPrevs.ToolTip = "Access Denied";
ibtnNext.ToolTip = "Access Denied";
ibtnFirst.ImageUrl = "../images/gnew_first.png";
ibtnLast.ImageUrl = "../images/gnew_last.png";
ibtnPrevs.ImageUrl = "../images/gnew_Prev.png";
ibtnNext.ImageUrl = "../images/gnew_next.png";
ibtnSave.Enabled = false;
ibtnSave.ImageUrl = "../images/gsave.png";
ibtnSave.ToolTip = "Access Denied";
}
if (userRightsEn.IsEdit)
{
Session["EditFlag"] = true;
}
else
{
Session["EditFlag"] = false;
}
ibtnView.Enabled = userRightsEn.IsView;
if (userRightsEn.IsView)
{
ibtnView.ImageUrl = "../images/find.png";
ibtnView.Enabled = true;
}
else
{
ibtnView.ImageUrl = "../images/gfind.png";
ibtnView.ToolTip = "Access Denied";
}
ibtnPrint.Enabled = userRightsEn.IsPrint;
if (userRightsEn.IsPrint)
{
ibtnPrint.Enabled = true;
ibtnPrint.ImageUrl = "../images/print.png";
ibtnPrint.ToolTip = "Print";
}
else
{
ibtnPrint.Enabled = false;
ibtnPrint.ImageUrl = "../images/gprint.png";
ibtnPrint.ToolTip = "Access Denied";
}
if (userRightsEn.IsOthers)
{
ibtnOthers.Enabled = true;
ibtnOthers.ImageUrl = "../images/others.png";
ibtnOthers.ToolTip = "Others";
}
else
{
ibtnOthers.Enabled = false;
ibtnOthers.ImageUrl = "../images/gothers.png";
ibtnOthers.ToolTip = "Access Denied";
}
if (userRightsEn.IsPost)
{
ibtnPosting.Enabled = true;
ibtnPosting.ImageUrl = "../images/posting.png";
ibtnPosting.ToolTip = "Posting";
}
else
{
ibtnPosting.Enabled = false;
ibtnPosting.ImageUrl = "../images/gposting.png";
ibtnPosting.ToolTip = "Access Denied";
}
}
/// <summary>
/// Method to Get List of All UserRights by UserID
/// </summary>
/// <param name="UserGroupID">UserID as an Input.</param>
/// <returns>Returns List of UserRights</returns>
public List <UserRightsEn> GetMenuByUser(int UserID)
{
List <UserRightsEn> loEnList = new List <UserRightsEn>();
string sqlCmd = null;
//Create Instances - Start
MenuMasterEn MenuDetails = new MenuMasterEn();
List <MenuMasterEn> MenuList = new List <MenuMasterEn>();
//Create Instances - Stop
if (UserID > 0)
{
//sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_UserRights.IsAdd, " +
//"UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, UR_UserRights.IsPost, UR_UserRights.IsPrint," +
//"UR_UserRights.DefaultMode FROM UR_MenuMaster INNER JOIN " +
//"UR_UserRights ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE " +
//"UR_MenuMaster.Status = true AND UR_MenuMaster.MenuID <> 114 AND " +
//"UR_UserRights.UserId =" + UserID + " order by UR_MenuMaster.MenuName desc";
//sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " +
sqlCmd = "SELECT UR_MenuMaster.MenuID " +
"FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " +
"AND UR_MenuMaster.MenuID IN (SELECT MenuID from ur_usermenu WHERE UserId = " + UserID + ") " +
"ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder";
}
else
{
sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " +
"FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " +
"ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder";
}
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
if (UserID > 0)
{
UserRightsEn loItem = new UserRightsEn();
loItem.MenuID = GetValue <int>(loReader, "MenuID");
//loItem.MenuName = GetValue<string>(loReader, "MenuName");
//loItem.PageName = GetValue<string>(loReader, "PageName");
loEnList.Add(loItem);
}
else
{
UserRightsEn loMenuItem = LoadURMenu(loReader);
loMenuItem.MenuID = GetValue <int>(loReader, "MenuID");
loMenuItem.MenuName = GetValue <string>(loReader, "MenuName");
loMenuItem.PageName = GetValue <string>(loReader, "PageName");
//loMenuItem.IsAdd = false;
//loMenuItem.IsEdit = false;
//loMenuItem.IsDelete = false;
//loMenuItem.IsView = false;
//loMenuItem.IsPrint = false;
//loMenuItem.IsPost = false;
//loMenuItem.IsAddModeDefault = false;
loEnList.Add(loMenuItem);
}
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Update UserRights
/// </summary>
/// <param name="argEn">UserRights Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Update(UserRightsEn argEn)
{
bool lbRes = false;
int iOut = 0;
string sqlCmd = "Select count(*) as cnt From UR_UserRights WHERE UserGroupId = @UserGroupId";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader dr = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
if (dr.Read())
{
iOut = clsGeneric.NullToInteger(dr["cnt"]);
}
if (iOut > 0)
{
throw new Exception("Record Already Exist");
}
}
if (iOut == 0)
{
sqlCmd = "UPDATE UR_UserRights SET UserGroupId = @UserGroupId, MenuID = @MenuID, IsAdd = @IsAdd, IsEdit = @IsEdit, IsDelete = @IsDelete, IsView = @IsView, IsPrint = @IsPrint, IsPost = @IsPost, IsOthers = @IsOthers, DefaultMode = @DefaultMode, LastUpdatedBy = @LastUpdatedBy, LastUpdatedDtTm = @LastUpdatedDtTm WHERE ";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@UserGroupId", DbType.Int32, argEn.UserGroup);
_DatabaseFactory.AddInParameter(ref cmd, "@MenuID", DbType.Int32, argEn.MenuID);
_DatabaseFactory.AddInParameter(ref cmd, "@IsAdd", DbType.Boolean, argEn.IsAdd);
_DatabaseFactory.AddInParameter(ref cmd, "@IsEdit", DbType.Boolean, argEn.IsEdit);
_DatabaseFactory.AddInParameter(ref cmd, "@IsDelete", DbType.Boolean, argEn.IsDelete);
_DatabaseFactory.AddInParameter(ref cmd, "@IsView", DbType.Boolean, argEn.IsView);
_DatabaseFactory.AddInParameter(ref cmd, "@IsPrint", DbType.Boolean, argEn.IsPrint);
_DatabaseFactory.AddInParameter(ref cmd, "@IsPost", DbType.Boolean, argEn.IsPost);
_DatabaseFactory.AddInParameter(ref cmd, "@IsOthers", DbType.Boolean, argEn.IsOthers);
_DatabaseFactory.AddInParameter(ref cmd, "@DefaultMode", DbType.Boolean, argEn.IsAddModeDefault);
_DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedBy", DbType.String, argEn.LastUser);
_DatabaseFactory.AddInParameter(ref cmd, "@LastUpdatedDtTm", DbType.DateTime, argEn.LastDtTm);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Update Failed! No Row has been updated...");
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
