public List <Company> getAllCompanies()
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "SELECT"))
{
helper.Close();
helper = new SqlHelper();
CompanyDAL dal = new CompanyDAL(helper);
var companies = dal.getAllcompanies();
helper.Close();
return(companies);
}
}catch (Exception ex)
{
log(ex);
}
}
return(null);
}
public void updateUser(String uid, String login, String password,
String firstName, String lastName,
String rsa, bool active = true,
String role = null, String company = null)
{
if (isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(signIn.UID, "USER"))
{
UserDAL dal = new UserDAL(helper);
dal.updateUser(uid, login, password, firstName, lastName,
rsa, active, role, company);
log(200, "Update is successfull");
}
else
{
log(600, "(PW)Permission denied");
}
}
catch (Exception ex)
{
log(ex);
}
}
}
public User getUser(String uid)
{
if (isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SignIN.UID, "SELECT"))
{
helper.Close();
helper = new SqlHelper();
UserDAL dal = new UserDAL(helper);
User user = dal.getUser(uid);
helper.Close();
return(user);
}
}catch (Exception ex)
{
log(ex);
}
}
return(null);
}
public Role getUserRole(String uid)
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "USER"))
{
RoleDAL dal = new RoleDAL(helper);
log(200, "A role is successfully got");
return(dal.getUserRole(uid));
}
else
{
log(600, "Permission denied");
}
}catch (Exception ex)
{
log(ex);
}
}
return(null);
}
public void createInvoice(Record document)
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "UPDATE") &&
sdal.hasPermission(SafeUser.SignIN.UID, "DELETE"))
{
ProductInventoryDAL piDAL = new ProductInventoryDAL(helper);
ProductDocumentDAL pdDAL = new ProductDocumentDAL(helper);
ProductTypeDAL ptDAL = new ProductTypeDAL(helper);
InventoryDocumentationDAL idDAL = new InventoryDocumentationDAL(helper);
ProductType type = ptDAL.getProductType(document.ProductType);
if (type == null)
{
ptDAL.addProductType(document.ProductType);
type = ptDAL.getProductType(document.ProductType);
}
ProductInventory product = piDAL.getProduct(document.ProductName, type.TID);
if (product != null && product.TotalQuantity - document.ProductQuantity >= 0)
{
product.TotalQuantity += document.ProductQuantity;
piDAL.updateProduct(product);
}
else
{
log(404, "No such product");
return;
}
ProductDocument delivery = new ProductDocument();
delivery.Name = document.DocumentName;
delivery.PrID = product.PrID;
delivery.Description = document.Description;
delivery.Quantity = document.ProductQuantity;
pdDAL.addDocument(delivery);
delivery = pdDAL.getDocument(document.DocumentName, product.PrID,
document.ProductQuantity, document.Description);
idDAL.assignDocument(SafeUser.SignIN.UID, delivery.DocumentID);
}
}catch (Exception ex)
{
log(ex);
}
}
}
public List <Permiso> GetAllPermisosByIdUsuario(int idUsuario)
{
string keyCache = KEY_PERIMISOS_BY_USUARIO_ID + idUsuario;
List <Permiso> permisos = CacheLayer.Get <List <Permiso> >(keyCache);
if (permisos == null)
{
permisos = SecurityDAL.GetAllPermisos(idUsuario);
if (permisos != null)
{
CacheLayer.Add(permisos, keyCache);
}
}
return(permisos);
}
/// <summary>Gets the list of roles.</summary>
/// <returns>List of AdminRole.</returns>
public List <SecurityRole> GetRoles()
{
Logging.LogDebugMessage("Method: GetRoles, MethodType: Get, Layer: SecurityBL, Parameters: No Input Parameters");
using (SecurityDAL roles = new SecurityDAL())
{
try
{
return(roles.GetRoles());
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: GetRoles, Layer: SecurityBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: GetRoles, Layer: SecurityBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
/// <summary>Gets the list of all role privileges.</summary>
/// <param name="roleId">The RoleID Object.</param>
/// <returns>List of SecurityRole.</returns>
public List <SecurityRole> GetAllRolePrivileges(RoleID roleId)
{
Logging.LogDebugMessage("Method: GetAllRolePrivileges, MethodType: Post, Layer: SecurityBL, Parameters: roleId = " + JsonConvert.SerializeObject(roleId));
using (SecurityDAL rolePrivileges = new SecurityDAL())
{
try
{
return(rolePrivileges.GetAllRolePrivileges(roleId));
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: GetAllRolePrivileges, Layer: SecurityBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: GetAllRolePrivileges, Layer: SecurityBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
/// <summary>Gets the list of all role privileges by role identifier.</summary>
/// <param name="roleId">The Integer Object.</param>
/// <returns>List of SecurityRole.</returns>
public List <SecurityRole> GetAllRolePrivilegesByRoleID(int roleId)
{
Logging.LogDebugMessage("Method: GetAllRolePrivilegesByRoleID, MethodType: Get, Layer: SecurityBL, Parameters: roleId = " + roleId);
using (SecurityDAL rolePrivilegesById = new SecurityDAL())
{
try
{
return(rolePrivilegesById.GetAllRolePrivilegesByRoleID(roleId));
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: GetAllRolePrivilegesByRoleID, Layer: SecurityBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: GetAllRolePrivilegesByRoleID, Layer: SecurityBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
/// <summary>Gets the list of user roles by UserId.</summary>
/// <param name="userId">The Long object.</param>
/// <returns>List of UserRoles.</returns>
public List <UserRoles> GetUserRoles(Int64 userId)
{
Logging.LogDebugMessage("Method: GetUserRoles, MethodType: Get, Layer: SecurityBL, Parameters: userId = " + userId.ToString());
using (SecurityDAL userRoles = new SecurityDAL())
{
try
{
return(userRoles.GetUserRoles(userId));
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: GetUserRoles, Layer: SecurityBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: GetUserRoles, Layer: SecurityBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
/// <summary>Insert the UserRole in bulk.</summary>
/// <param name="privilegeList">The List of InsertRoleUser Objects.</param>
/// <param name="createdByUserID">The Integer Object for CreatedByUserId.</param>
/// <param name="updatedByUserID">The Integer Object for UpdatedByUserId.</param>
/// <returns>Boolean Object.</returns>
public bool UserRoleInsertBulk(List <InsertRoleUser> privilegeList, int createdByUserID, int updatedByUserID)
{
Logging.LogDebugMessage("Method: UserRoleInsertBulk, MethodType: Post, Layer: SecurityBL, Parameters: privilegeList = " + JsonConvert.SerializeObject(privilegeList) + ",createdByUserID = " + createdByUserID.ToString() + ",updatedByUserID = " + updatedByUserID.ToString());
using (SecurityDAL userRoleInsert = new SecurityDAL())
{
try
{
return(userRoleInsert.UserRoleInsertBulk(privilegeList, createdByUserID, updatedByUserID));
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: UserRoleInsertBulk, Layer: SecurityBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: UserRoleInsertBulk, Layer: SecurityBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
/// <summary>Insert or Update UserRole.</summary>
/// <param name="privilegeList">The List of AddRoleUser Object.</param>
/// <param name="rolePrivilege">The RoleUserlist Object.</param>
/// <returns>Boolean Object.</returns>
public bool UserRoleUpsert(List <AddRoleUser> privilegeList, RoleUserlist rolePrivilege)
{
Logging.LogDebugMessage("Method: UserRoleUpsert, MethodType: Post, Layer: SecurityBL, Parameters: privilegelist = " + JsonConvert.SerializeObject(privilegeList) + ",rolePrivilege = " + JsonConvert.SerializeObject(rolePrivilege));
using (SecurityDAL useRoleUpsert = new SecurityDAL())
{
try
{
return(useRoleUpsert.UserRoleUpsert(privilegeList, rolePrivilege));
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: UserRoleUpsert, Layer: SecurityBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: UserRoleUpsert, Layer: SecurityBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
public void deleteRole(int rid)
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "USER"))
{
RoleDAL dal = new RoleDAL(helper);
dal.removeRole(rid);
log(200, "Role is removed successfully");
}
else
{
log(600, "(SP) Permission denied");
}
}catch (Exception ex)
{
log(ex);
}
}
}
public void createRole(String name)
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "USER"))
{
RoleDAL dal = new RoleDAL(helper);
dal.createRole(name);
log(200, "Role is created successfully");
}
else
{
log(600, "(SR) Permission denied");
}
}catch (Exception ex)
{
log(ex);
}
}
}
public List <Role> getAllRoles()
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "USER"))
{
RoleDAL dal = new RoleDAL(new SqlHelper());
return(dal.getAllRoles());
}
else
{
log(600, "(SP) Permission denied");
}
}catch (Exception ex)
{
log(ex);
}
}
return(null);
}
public void deleteUser(String uid)
{
if (isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SignIN.UID, "USER"))
{
UserDAL dal = new UserDAL(helper);
dal.removeUser(uid);
}
else
{
log(600, "(PW)Permission denied");
}
}
catch (Exception ex)
{
log(ex);
}
}
}
public List <User> getAllUsers()
{
if (isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SignIN.UID, "SELECT"))
{
UserDAL dal = new UserDAL(helper);
List <User> users = dal.getAllUsers();
helper.Close();
return(users);
}
}
catch (Exception ex)
{
log(ex);
}
}
return(null);
}
public void revokePermissions(int rid, int pid)
{
if (SafeUser != null && SafeUser.isLoggedIn())
{
try
{
SqlHelper helper = new SqlHelper();
SecurityDAL sdal = new SecurityDAL(helper);
if (sdal.hasPermission(SafeUser.SignIN.UID, "USER"))
{
RolePermissionsDAL dal = new RolePermissionsDAL(helper);
dal.revokePermission(rid, pid);
log(200, "A permission is succesfully revoked");
}
else
{
log(600, "(SP) Permission denied");
}
}catch (Exception ex)
{
log(ex);
}
}
}
public SecurityBll()
{
mSecurityDAL = new SecurityDAL();
}
