public List <EntityAccessRights> Listusername(string searchtext)
{
List <EntityAccessRights> EntityAccesslist = new List <EntityAccessRights>();
EntityAccessRights objEntityAccessRights = null;
IDbConnection conn = null;
IDbCommand cmd = null;
IDataReader reader;
using (conn = DataFactory.CreateConnection())
{
conn.Open();
cmd = conn.CreateCommand();
using (cmd = DataFactory.CreateCommand("sp_EntityAccessRights_list", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(DataFactory.CreateParameter("@UserName", searchtext));
reader = cmd.ExecuteReader();
while (reader.Read())
{
objEntityAccessRights = new EntityAccessRights();
objEntityAccessRights.UserId = Convert.ToInt64(reader["UserId"]);
objEntityAccessRights.Username = Convert.ToString(reader["Username"]);
EntityAccesslist.Add(objEntityAccessRights);
}
}
return(EntityAccesslist);
}
}
public List <EntityAccessRights> ModuleList()
{
IDbConnection conn = null;
IDbCommand cmd = null;
IDataReader reader = null;
List <EntityAccessRights> objModuleList = new List <EntityAccessRights>();
EntityAccessRights ModuleList = null;
using (conn = DataFactory.CreateConnection())
{
conn.Open();
cmd = conn.CreateCommand();
using (cmd = DataFactory.CreateCommand("Sp_ListModule", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
reader = cmd.ExecuteReader();
while (reader.Read())
{
ModuleList = new EntityAccessRights();
ModuleList.Modulename = DBNull.Value.Equals(reader["ModuleTypeName"]) ? string.Empty : Convert.ToString(reader["ModuleTypeName"]);
ModuleList.ModuleTypeID = DBNull.Value.Equals(reader["ModuleTypeId"]) ? 0 : Convert.ToInt32(reader["ModuleTypeId"]);
objModuleList.Add(ModuleList);
}
reader.Close();
}
return(objModuleList);
}
}
public List <EntityAccessRights> GetEntityRightsForMenu(Int64 userID, Int64 roleID)
{
List <EntityAccessRights> objEntityAccessRightsList = new List <EntityAccessRights>();
EntityAccessRights objEntityAccessRights = null;
IDbConnection conn = null;
IDbCommand cmd = null;
IDataReader reader;
using (conn = DataFactory.CreateConnection())
{
conn.Open();
cmd = conn.CreateCommand();
using (cmd = DataFactory.CreateCommand("Sp_GetEntityAccessRightsForMenu", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(DataFactory.CreateParameter("UserID", userID));
cmd.Parameters.Add(DataFactory.CreateParameter("RoleID", roleID));
reader = cmd.ExecuteReader();
while (reader.Read())
{
objEntityAccessRights = new EntityAccessRights();
objEntityAccessRights.RoleId = Convert.ToInt64(reader["RoleId"]);
objEntityAccessRights.Modulename = Convert.ToString(reader["ModuleTypeName"]);
objEntityAccessRights.EntityName = Convert.ToString(reader["EntityName"]);
objEntityAccessRights.Rolename = Convert.ToString(reader["Rolename"]);
objEntityAccessRights.EntityDelete = Convert.ToBoolean(reader["EntityDelete"]);
objEntityAccessRightsList.Add(objEntityAccessRights);
}
reader.Close();
}
}
return(objEntityAccessRightsList);
}
public string Create(EntityAccessRights objEntityAccessRights)
{
IDbConnection conn = null;
IDbCommand cmd = null;
int RecordsAffected = 0;
using (conn = DataFactory.CreateConnection())
{
conn.Open();
cmd = conn.CreateCommand();
using (cmd = DataFactory.CreateCommand("sp_EntityAccessRights", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(DataFactory.CreateParameter("IsSave", true));
cmd.Parameters.Add(DataFactory.CreateParameter("EntityAccessId", DBNull.Value));
cmd.Parameters.Add(DataFactory.CreateParameter("EntityId", objEntityAccessRights.EntityID));
cmd.Parameters.Add(DataFactory.CreateParameter("moduletypeID", objEntityAccessRights.ModuleTypeID));
cmd.Parameters.Add(DataFactory.CreateParameter("roleid", objEntityAccessRights.RoleId));
cmd.Parameters.Add(DataFactory.CreateParameter("entitycreate", objEntityAccessRights.EntityCreate));
cmd.Parameters.Add(DataFactory.CreateParameter("entityread", objEntityAccessRights.EntityRead));
cmd.Parameters.Add(DataFactory.CreateParameter("entitydelete", objEntityAccessRights.EntityDelete));
cmd.Parameters.Add(DataFactory.CreateParameter("entityupdate", objEntityAccessRights.EntityUpdate));
cmd.Parameters.Add(DataFactory.CreateParameter("entityprint", objEntityAccessRights.EntityPrint));
cmd.Parameters.Add(DataFactory.CreateParameter("createdby", objEntityAccessRights.CreatedBy));
cmd.Parameters.Add(DataFactory.CreateParameter("entitydescription", objEntityAccessRights.Entitydescription));
IDbDataParameter param = DataFactory.CreateParameter("@@guid", DBNull.Value);
param.DbType = DbType.Int64;
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
RecordsAffected = cmd.ExecuteNonQuery();
}
if (RecordsAffected > 0)
{
return(Convert.ToString(objEntityAccessRights.EntityAccessId));
}
else
{
return(Convert.ToString(objEntityAccessRights.EntityAccessId));
}
}
}
public List <EntityAccessRights> EntityListgrid(Int64 pageNo, Int64 rowsperpage, string SearchText)
{
IDbConnection conn = null;
IDbCommand cmd = null;
IDataReader reader = null;
Int64 TotalRecords = 0;
List <EntityAccessRights> objEntityUserRights = new List <EntityAccessRights>();
EntityAccessRights objlist = null;
using (conn = DataFactory.CreateConnection())
{
conn.Open();
cmd = conn.CreateCommand();
using (cmd = DataFactory.CreateCommand("Sp_entityaccessright_search", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(DataFactory.CreateParameter("@Pageno", pageNo));
cmd.Parameters.Add(DataFactory.CreateParameter("@RowsPerPage", rowsperpage));
cmd.Parameters.Add(DataFactory.CreateParameter("@SearchText", SearchText));
//cmd.Parameters.Add(DataFactory.CreateParameter("@ClientID", ClientID));
reader = cmd.ExecuteReader();
while (reader.Read())
{
TotalRecords = Convert.ToInt64(reader["TotalRecords"]);
}
if (reader.NextResult())
{
while (reader.Read())
{
objlist = new EntityAccessRights();
objlist.Modulename = DBNull.Value.Equals(reader["ModuleTypeName"]) ? string.Empty : Convert.ToString(reader["ModuleTypeName"]);
objlist.ModuleTypeID = DBNull.Value.Equals(reader["ModuleTypeId"]) ? 0 : Convert.ToInt32(reader["ModuleTypeId"]);
objlist.RoleId = DBNull.Value.Equals(reader["RoleId"]) ? 0 : Convert.ToInt32(reader["RoleId"]);
objlist.Rolename = DBNull.Value.Equals(reader["RoleName"]) ? string.Empty : Convert.ToString(reader["RoleName"]);
objEntityUserRights.Add(objlist);
}
}
reader.Close();
}
return(objEntityUserRights);
}
}
public string Create(EntityAccessRights objEntityAccessRights)
{
EntityAccessRightsDBO objEntityAccessRightsDB = new EntityAccessRightsDBO();
return(objEntityAccessRightsDB.Create(objEntityAccessRights));
}
