public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var i = 0;
var res = (from r in results
select new
{
Id = i++,
r.TableName,
r.CodeName,
r.Value1,
Value2 = r.Value2 ?? "",
Value3 = r.Value3 ?? "",
Order = r.DisplayOrder ?? "",
Status = r.Status ? "check colorGreen" : "close colorRed",
Protected = r.IsProtected ? "lock colorRed" : "unlock-alt colorGreen"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public EmployeeVm Init(long userId, long?id)
{
var user = BlUser.LoadSingle(userId);
var toRet = new EmployeeVm
{
Branches = BlBranch.GetLov(userId, true).ToDictionary(i => i.value, i => i.label),
Titles = BlCode.LoadTable(userId, "Title"),
Genders = BlCode.LoadTable(userId, "Gender"),
IdTypes = BlCode.LoadTable(userId, "IdType"),
Maritals = BlCode.LoadTable(userId, "Marital"),
Statuses = BlCode.LoadTable(userId, "Status"),
Levels = BlCode.LoadTable(userId, "EmployeeLevel"),
ActionMode = Enumerations.ActionMode.Add,
Employee = new Employee {
Status = "A", Entity = new Entity {
BranchId = user.BranchId, Nationality = 422, Status = "A"
}, Level = "0"
}
};
if (id != null)
{
var obj = LoadSingle(userId, Convert.ToInt64(id));
toRet.Employee = obj;
toRet.ActionMode = Enumerations.ActionMode.Edit;
toRet.Signature = BlCommon.GetSignature(toRet.Employee.UserId, toRet.Employee.EntryDate);
}
return(toRet);
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
ModuleId = r.Module.Id,
r.Action,
Text = r.Text ?? "",
User = r.UserId == 0 ? "" : BlUser.LoadSingle(r.UserId).UserName,
branch = BlBranch.GetBranchName(user.Id, r.BranchId),
LogDate = r.EntryDate.ToString(true)
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Gender = r.Entity.Gender == null ? "" : BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "Gender", r.Entity.Gender)),
Name = BlEntity.FormatFullName(r.Entity),
Number = r.Entity.IdType == "M" ? r.Entity.IdNum : "",
r.Entity.FullEnLongName,
Level = r.Level == null ? "" : BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "EmployeeLevel", r.Level)),
Status = r.Status == "A" ? "check colorGreen" : "close colorRed"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public static DdlVm.DdlOption LoadQs(long userId, long id, string parameters)
{
var user = BlUser.LoadSingle(userId);
var serializer = new JavaScriptSerializer();
var dict = serializer.Deserialize <Dictionary <string, object> >(parameters);
var returnPin = CheckEmpty.Boolean(ref dict, "returnPin");
var item = returnPin ? LoadByPin(userId, id) : LoadSingle(userId, id);
return(FormatForQs(user.LanguageId, item, returnPin));
}
private static IEnumerable <TreeItemVm> ConstructTreeNode(long userId, IEnumerable <Help> helps, bool allowView, bool allowAdd, bool allowEdit, bool allowDelete)
{
var user = BlUser.LoadSingle(userId);
var toRet = new List <TreeItemVm>();
foreach (var help in helps)
{
TreeItemVm treeNode;
var actions = "</span>";
actions += "<span id='actions_" + help.Id + "' style='display:none'> ";
actions += "<a class='treeAction' onclick='javascript:ViewAction(" + help.Id + ");'><span>" + BlDescription.GetDescription(Enumerations.DescriptionResources.Language, "lblView", user.LanguageId) + "</span></a> ";
if (allowAdd)
{
actions += "<a class='treeAction' onclick='javascript:AddAction(" + help.Id + ");'><span>" + BlDescription.GetDescription(Enumerations.DescriptionResources.Language, "lblAdd", user.LanguageId) + "</span></a> ";
}
if (allowEdit)
{
actions += "<a class='treeAction' onclick='javascript:EditAction(" + help.Id + ");'><span>" + BlDescription.GetDescription(Enumerations.DescriptionResources.Language, "lblEdit", user.LanguageId) + "</span></a> ";
}
if (allowDelete)
{
actions += "<a class='treeAction' onclick='javascript:DeleteAction(" + help.Id + ");'><span>" + BlDescription.GetDescription(Enumerations.DescriptionResources.Language, "lblDelete", user.LanguageId) + "</span></a> ";
}
actions += "<span>";
if (help.Id == 0)
{
treeNode = new TreeItemVm
{
id = "0",
parent = "#",
text = "<span onclick='ShowDetails(0);'>Root" + actions + "</span>",
icon = "fa fa-briefcase fa-lg colorMain",
state = "{\"opened\": \"true\"}",
li_attr = "{\"class\" : \"form-control-label\"}"
};
}
else
{
treeNode = new TreeItemVm
{
id = help.Id.ToUiString(),
parent = help.ParentId == null ? "0" : help.ParentId.ToString(),
text = "<span onclick='ShowDetails(" + help.Id + ");'>" + (help.Title == "" ? Path.GetFileNameWithoutExtension(help.Page) : help.Title) + actions + "</span>",
icon = "fa fa-info fa-lg colorMain",
li_attr = "{\"class\" : \"form-control-label\"}"
};
}
toRet.Add(treeNode);
}
return(toRet);
}
private static DdlVm.DdlOption FormatForQs(long userId, Code item)
{
var user = BlUser.LoadSingle(userId);
var toRet = new DdlVm.DdlOption
{
value = item.CodeName,
label = user.LanguageId == 1 ? item.Value1 : item.Value2
};
return(toRet);
}
public Log Create(long userId, Log toAdd)
{
using (var tran = new TransactionScope())
{
toAdd.UserId = userId;
toAdd.BranchId = BlUser.LoadSingle(toAdd.UserId).BranchId;
toAdd.EntryDate = BlCommon.GetServerDateTime();
var toRet = _repository.Create(toAdd);
tran.Complete();
return(toRet);
}
}
private static void PreSave(long userId, ref Xtra toSave, Enumerations.ActionMode action)
{
var user = BlUser.LoadSingle(userId);
if (action == Enumerations.ActionMode.Add)
{
//Check if previously exists
if (LoadSingle(userId, toSave.Object, toSave.Id, toSave.Property) != null)
{
throw new BusinessException("AlreadyExists1", BlDescription.GetDescription(Enumerations.DescriptionResources.Language, "lblProperty", user.LanguageId));
}
}
}
public static string GetBranchName(long userId, long branchId)
{
var user = BlUser.LoadSingle(userId);
var branch = BlBranch.LoadSingle(user.Id, branchId);
if (user.LanguageId == 1)
{
return(branch.Entity.FullEnShortName);
}
else
{
return(branch.Entity.FullArShortName);
}
}
public bool AddLocation(long userId, long employeeId, long locationId)
{
var user = BlUser.LoadSingle(userId);
using (var tran = new TransactionScope())
{
var employee = LoadSingle(userId, employeeId);
//Adjust the employee
Edit(userId, employee);
tran.Complete();
return(true);
}
}
public static List <DdlVm.DdlOption> GetLov(long userId, string operation, bool required, string relCode = "")
{
if (operation.ToUpper() == "CODETABLES")
{
return(GetLovTables(userId, required).ToList());
}
if (operation.ToUpper() == "BRANCHES")
{
return(BlBranch.GetLov(userId, required).ToList());
}
var user = BlUser.LoadSingle(userId);
var fieldName = user.LanguageId == 1 ? "Value1" : "Value2";
var blCode = new BlCode();
var predicate = PredicateBuilder.True <Code>();
predicate = predicate.And(p => p.TableName == operation);
if (relCode != "")
{
predicate = predicate.And(p => p.RelCode == relCode);
}
var result = blCode.LoadSearch(userId, predicate).ToList();
if (!result.Any())
{
return(null);
}
var results = (from a in result.Where(m => m.Status)
orderby a.DisplayOrder ascending
select new DdlVm.DdlOption
{
value = a.CodeName,
label = a.GetType().GetProperty(fieldName).GetValue(a, null).ToString()
}).ToList();
if (!required)
{
results.Insert(0, new DdlVm.DdlOption("...", ""));
}
return(results.ToList());
}
public static List <DdlVm.DdlOption> LoadQs(long userId, string parameters, string searchTerm, int pageSize, int pageNum, out long count)
{
var user = BlUser.LoadSingle(userId);
var blObject = new BlEmployee();
var serializer = new JavaScriptSerializer();
var dict = serializer.Deserialize <Dictionary <string, object> >(parameters);
var isActive = CheckEmpty.Boolean(ref dict, "isActive");
var gender = CheckEmpty.String(ref dict, "Gender");
var returnPin = CheckEmpty.Boolean(ref dict, "returnPin");
var locationId = CheckEmpty.Numeric(ref dict, "locationId");
var predicate = PredicateBuilder.True <Employee>();
predicate = predicate.And(p => p.Id != 1); //Exclude employee presidential palace
if (isActive)
{
predicate = predicate.And(c => c.Status == "A");
}
if (gender != "")
{
predicate = predicate.And(c => gender.Split(',').Contains(c.Entity.Gender));
}
if (CheckEmpty.String(searchTerm) != "")
{
var tokens = searchTerm.Tokens();
foreach (var token in tokens)
{
var predicate2 = PredicateBuilder.False <Employee>();
predicate2 = predicate2.Or(m => m.Entity.FirstName.Contains(token));
predicate2 = predicate2.Or(m => m.Entity.FatherName.Contains(token));
predicate2 = predicate2.Or(m => m.Entity.FamilyName.Contains(token));
predicate2 = predicate2.Or(m => m.Entity.ArFirstName.Contains(token));
predicate2 = predicate2.Or(m => m.Entity.ArFatherName.Contains(token));
predicate2 = predicate2.Or(m => m.Entity.ArFamilyName.Contains(token));
predicate = predicate.And(predicate2);
}
}
var items = blObject.LoadPaging(userId, predicate, pageSize, (pageNum - 1), out count);
return(items.Select(i => FormatForQs(user.LanguageId, i, returnPin)).ToList());
}
public bool Delete(long userId, Comment toDelete)
{
using (var tran = new TransactionScope())
{
//Only note owner and full administrator can delete
if (userId != toDelete.UserId && !BlUser.LoadSingle(userId).IsFullPermission)
{
throw new BusinessException("NoteCannotBeDeletedUnlessByOwner");
}
var toRet = _repository.Delete(toDelete);
BlLog.Log(userId, Module, "Delete comment", "CommentDleted", new object[] { toDelete.Text.ManageTextLength(100), toDelete.Reference });
tran.Complete();
return(toRet);
}
}
public EventVm Init(long userId, long id)
{
//Get current user
var user = BlUser.LoadSingle(userId);
var eventLog = LoadSingle(userId, id);
var toRet = new EventVm
{
Module = eventLog.Module.Id,
Action = eventLog.Action,
Text = eventLog.Text,
UserName = BlUser.LoadSingle(eventLog.UserId).UserName,
Branch = BlBranch.GetBranchName(user.Id, eventLog.BranchId),
Date = eventLog.EntryDate.ToString(true)
};
return(toRet);
}
public ErrorVm Init(long userId, long id)
{
//Get current user
var user = BlUser.LoadSingle(userId);
var error = LoadSingle(userId, id);
var toRet = new ErrorVm
{
Type = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "ErrorType", error.Type.ToUiString())),
Severity = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "ErrorSeverity", error.Severity.ToUiString())),
Source = error.Source,
Text = error.Text,
UserName = BlUser.LoadSingle(error.UserId).UserName,
Branch = BlBranch.GetBranchName(user.Id, error.BranchId),
Date = error.EntryDate.ToString(true)
};
return(toRet);
}
public bool DeleteLocation(long userId, long employeeId, long locationId)
{
var user = BlUser.LoadSingle(userId);
using (var tran = new TransactionScope())
{
var employee = LoadSingle(userId, employeeId);
//Check if employee location had some stock in it
//var blStock = new BlStock();
//var employeeLocationStock = blStock.LoadByLocationEmployee(userId, locationId, employee.Id, new[] { "I" });
//if (employeeLocationStock.Any())
//{ throw new BusinessException("CannotDeleteRelatedStock"); }
//Adjust the employee
Edit(userId, employee);
tran.Complete();
return(true);
}
}
public static List <DdlVm.DdlOption> GetLov(long userId, bool isMandatory = false)
{
var user = BlUser.LoadSingle(userId);
var canCrossBranch = BlPermission.CanDo(userId, Module, "CrossBranches");
var blBranch = new BlBranch();
var predicate = PredicateBuilder.True <Branch>();
predicate = predicate.And(p => p.Status == "A");
//Retrieve only user branch if cannot cross branch
if (!canCrossBranch)
{
predicate = predicate.And(p => p.Id == user.BranchId);
}
var result = blBranch.LoadSearch(userId, predicate).ToList();
if (!result.Any())
{
return(null);
}
var results = (from a in result
orderby a.Name ascending
select new DdlVm.DdlOption
{
value = a.Id.ToUiString(),
label = user.LanguageId == 1 ? a.Entity.FullEnShortName : a.Entity.FullArShortName
}).ToList();
//Add empty value if can cross branch
if (canCrossBranch && !isMandatory)
{
results.Insert(0, new DdlVm.DdlOption("...", ""));
}
return(results.ToList());
}
public static List <DdlVm.DdlOption> LoadDdl(long userId, string parameters, string searchTerm, int pageSize, int pageNum, out long count)
{
var user = BlUser.LoadSingle(userId);
var blObject = new BlEntity();
var serializer = new JavaScriptSerializer();
var dict = serializer.Deserialize <Dictionary <string, object> >(parameters);
var isActive = CheckEmpty.Boolean(ref dict, "isActive");
var gender = CheckEmpty.String(ref dict, "Gender");
var predicate = PredicateBuilder.True <Entity>();
if (isActive)
{
predicate = predicate.And(c => c.Status == "A");
}
if (gender != "")
{
predicate = predicate.And(c => gender.Split(',').Contains(c.Gender));
}
if (CheckEmpty.String(searchTerm) != "")
{
var predicate2 = PredicateBuilder.False <Entity>();
predicate2 = predicate2.Or(m => m.FirstName.Contains(searchTerm));
predicate2 = predicate2.Or(m => m.FatherName.Contains(searchTerm));
predicate2 = predicate2.Or(m => m.FamilyName.Contains(searchTerm));
predicate2 = predicate2.Or(m => m.ArFirstName.Contains(searchTerm));
predicate2 = predicate2.Or(m => m.ArFatherName.Contains(searchTerm));
predicate2 = predicate2.Or(m => m.ArFamilyName.Contains(searchTerm));
predicate = predicate.And(predicate2);
}
var items = blObject.LoadPaging(userId, predicate, pageSize, (pageNum - 1), out count);
return(items.Select(i => FormatForDdl(user.LanguageId, i)).ToList());
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadSearch(userId, CreateFilter(search));
totalRecords = results.Count();
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Name = r.Property,
r.Value
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Language = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "Language", r.LanguageId.ToUiString())),
Parent = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "DescriptionParent", r.Parent)),
r.Code,
r.Text
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Pin,
r.FullEnLongName,
name = FormatFullName(r),
EntryDate = r.EntryDate.ToString(true),
Status = r.Status == "A" ? "check colorGreen" : "close colorRed"
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public GridResults LoadPaging(long userId, string search, int pageIndex, out long totalRecords, string sortColumnName = "", string sortOrderBy = "")
{
//Get current user
var user = BlUser.LoadSingle(userId);
//Query paged data
var results = LoadPaging(userId, CreateFilter(search), user.PageSize, pageIndex - 1, out totalRecords);
//Convert results into display model
var res = (from r in results
select new
{
r.Id,
Url = "<a class='text-primary' href=" + BlCode.LoadSingle(userId, "_System", "DocumentsRootUrl").Value1 + "documents/" + r.Path + " target='_blank' >" + r.Name + "</a>",
Type = BlCode.GetCodeByLanguage(user, BlCode.LoadSingle(userId, "DocumentType", r.Type)),
EntryDate = r.EntryDate.ToString(true),
User = r.UserId == 0 ? "" : BlUser.LoadSingle(r.UserId).UserName,
}).ToList();
//Convert display model into json data
return(GridVm.FormatResult(res, user.PageSize, pageIndex, totalRecords));
}
public static Dictionary <string, string> LoadTable(long userId, string tableName, string toRetColumn = "Value1", string relCode = "")
{
var user = BlUser.LoadSingle(userId);
toRetColumn = (toRetColumn == "Value1" || CheckEmpty.String(toRetColumn) == "") ? user.LanguageId == 1 ? "Value1" : "Value2" : toRetColumn;
List <Code> results;
if (!CacheHelper.Get(Module + "_Table_" + tableName + "_" + relCode, out results))
{
var codeRepository = new CodeRepository();
var predicate = PredicateBuilder.True <Code>();
predicate = predicate.And(p => p.TableName == tableName);
predicate = predicate.And(p => p.Status);
if (relCode != "")
{
predicate = predicate.And(p => p.RelCode == relCode);
}
results = codeRepository.LoadSearch(predicate);
if (results != null)
{
CacheHelper.Add(Module + "_Table_" + tableName + "_" + relCode, results, BlCommon.DefaultTimeOut());
}
}
Dictionary <string, string> toRet = null;
if (results != null)
{
toRet = results.ToDictionary(k => k.CodeName, v => v.GetType().GetProperty(toRetColumn).GetValue(v, null).ToString());
}
return(toRet);
}
public static DdlVm.DdlOption LoadDdl(long userId, long pin)
{
var user = BlUser.LoadSingle(userId);
return(FormatForDdl(user.LanguageId, LoadSingle(userId, pin)));
}
