public ListQueryResult <Department> GetByQuery(ListQuery <Department> query)
{
var result = new ListQueryResult <Department>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "depName")
{
foreach (var item in dbcontext.Divisions.Where(o => o.DivisionName == p.Value).OrderBy(it => it.DivisionName))
{
if (result.Items == null)
{
result.Items = new List <Department>();
}
result.Items.Add(_DepartmentMapper.Map(item));
}
}
else if (p.Name == "DealerDivision")
{
foreach (var item in dbcontext.Divisions.Where(o => o.DivisionName == "CC" || o.DivisionName == "COMMON-RURBAN/EXPORT" || o.DivisionName == "CP - ASF" || o.DivisionName == "CP - MNT" || o.DivisionName == "FV").OrderBy(it => it.DivisionName))
{
if (result.Items == null)
{
result.Items = new List <Department>();
}
result.Items.Add(_DepartmentMapper.Map(item));
}
}
}
}
else
{
foreach (var item in dbcontext.Divisions.OrderBy(it => it.DivisionName))
{
if (result.Items == null)
{
result.Items = new List <Department>();
}
result.Items.Add(_DepartmentMapper.Map(item));
}
}
}
return(result);
}
public Core.Domian.Settings.IssueManagementCommentLog Map(Sql.IssueManagementCommentLog item)
{
if (item == null)
{
return(null);
}
return(new Core.Domian.Settings.IssueManagementCommentLog()
{
Id = item.Id,
Active = item.Active,
ID_Comments = item.ID_Comments,
ID_Request = item.ID_Request,
ID_Status = item.ID_Status,
id_System_Name = item.id_System_Name,
RCT = item.RCT,
RUT = item.RUT,
RCB = _rcbMapping.Map(item.UserDetail),
RUB = _rubMapping.Map(item.UserDetail1),
ID_Pending_With_Email = item.ID_Pending_With_Email,
UploadFlag = item.UploadFlag,
ID_Status_Id = _statusMapping.Map(item.StatusMaster),
RCBEmail = item.RCBEmail,
RCBEmpCode = item.RCBEmpCode,
RCBEmpName = item.RCBEmpName,
RUBEmail = item.RUBEmail,
RUBEmpCode = item.RUBEmpCode,
RUBEmpName = item.RUBEmpName,
Target_Date = item.Target_Date,
});
}
public Division GetById(int id)
{
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var item = dbcontext.Divisions.FirstOrDefault(it => it.Id == id);
if (item == null)
{
throw new Exception("Not Found");
}
return(_divisionMapper.Map(item));
}
}
public ListQueryResult <User> GetByQuery(ListQuery <User> query)
{
var result = new ListQueryResult <User>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var linqQuery = dbcontext.UserDetails.Where(it => it.UserId > 0);
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "username")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.UserName == p.Value);
}
}
else if (p.Name == "filterText")
{
string val = p.Value;
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.Title.Contains(val) || it.Email.Contains(val));
}
}
}
foreach (var item in linqQuery.Take(query.PageSize).OrderBy(it => it.Title))
{
if (result.Items == null)
{
result.Items = new List <User>();
}
var usr = _mapper.Map(item);
result.Items.Add(usr);
}
}
}
return(result);
}
public Core.Domian.Settings.IssueManagementAnchorComment Map(Sql.IssueManagementAnchorComment item)
{
if (item == null)
{
return(null);
}
return(new Core.Domian.Settings.IssueManagementAnchorComment()
{
Id = item.Id,
Active = item.Active,
ID_Comments = item.ID_Comments,
ID_Request = item.ID_Request,
id_System_Name = item.id_System_Name,
RCT = item.RCT,
RUT = item.RUT,
RCB = _rcbMapping.Map(item.UserDetail),
RUB = _rubMapping.Map(item.UserDetail1),
ID_Pending_With_Email = item.ID_Pending_With_Email
});
}
public ListQueryResult <User> GetByQuery(ListQuery <User> query)
{
var result = new ListQueryResult <User>();
using (Sql.InitiativeHubFinalEntities dbcontext = new Sql.InitiativeHubFinalEntities())
{
var linqQuery = dbcontext.UserDetails.Where(it => it.UserId > 0);
if (query.Parameters != null)
{
foreach (var p in query.Parameters)
{
if (p.Name == "username")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.UserName == p.Value);
}
}
else if (p.Name == "title")
{
if (p.Operator == CompareOperator.Equals)
{
linqQuery = linqQuery.Where(it => it.Title == p.Value);
}
}
else if (p.Name.ToLower() == "dhdivisionid")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DepartmentHeads.Count(g => g.DeparmentId == val) > 0);
}
else if (p.Name.ToLower() == "dodivisionid")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DepartmentOwners.Count(g => g.DeparmentId == val) > 0);
}
else if (p.Name == "ResponsibleUsers")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DivisionId == val);
}
else if (p.Name == "DependentUsers")
{
int val = 0;
val = int.Parse(p.Value);
linqQuery = linqQuery.Where(it => it.DivisionId == val);
}
}
}
foreach (var item in linqQuery)
{
if (result.Items == null)
{
result.Items = new List <User>();
}
var usr = _mapper.Map(item);
result.Items.Add(usr);
}
}
return(result);
}