public WrapperMultiProjectWorkflow GetProjectWorkflowCompletedTransferedSteps(int ProjectID, int WorkflowID)
{
WrapperMultiProjectWorkflow WrapperMultiProjectWorkflow = new WrapperMultiProjectWorkflow();
NbkDbEntities dbcontext = new NbkDbEntities();
List <ProjectWorkflowSteps> Obj = dbcontext.ProjectWorkflowSteps.Where(x => x.ProjectId == ProjectID &&
x.WorkflowId == WorkflowID).OrderBy(x => x.WorkflowStepId).ToList();
List <ProjectWorkflowENT> MultiProjectWorkflow = new List <ProjectWorkflowENT>();
if (Obj != null)
{
if (Obj.Count > 0)
{
MultiProjectWorkflow.AddRange(Obj.Select(i => new ProjectWorkflowENT
{
Id = i.Id,
ProjectId = i.ProjectId,
WorkflowId = i.WorkflowId,
WorkflowStepId = i.WorkflowStepId,
IsTransfer = i.IsTransfer,
EmailHistoryId = i.TaskId,
InsertDate = i.InsertDate,
InsertedBy = i.InsertedBy
}));
}
}
WrapperMultiProjectWorkflow.MultiProjectWorkflow = MultiProjectWorkflow;
return(WrapperMultiProjectWorkflow);
}
public ProjectWorkflowENT InsertRecordInDoc(ProjectWorkflowENT Param, int?otherDoc, int?PartyTypeId, int?PartyDocTypeID)
{
if (Param.FileName == null)
{
Param.FileName = "";
}
NbkDbEntities dbcontext = new NbkDbEntities();
Doc Data = new Doc
{
ProjectId = Param.ProjectId,
WorkflowId = Param.WorkflowId,
WorkflowStepId = Param.WorkflowStepId,
Date = Param.InsertDate,
PartyId = null,
OtherDocs = otherDoc,
FileName = Param.FileName.ToString(),
PartyTypeId = PartyTypeId,
PartyDocTypeId = PartyDocTypeID
};
dbcontext.Doc.Add(Data);
dbcontext.SaveChanges();
Param.EmailHistoryId = Data.Id;
return(Param);
}
public ProjectWorkflowENT WorkflowProjectStepStatusAdd(ProjectWorkflowENT Param)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ProjectWorkflowSteps Data = new ProjectWorkflowSteps()
{
ProjectId = Param.ProjectId,
WorkflowId = Param.WorkflowId,
WorkflowStepId = Param.WorkflowStepId,
IsTransfer = Param.IsTransfer,
TaskId = Param.EmailHistoryId,
InsertDate = Param.InsertDate,
InsertedBy = Param.InsertedBy
};
//dbcontext.ProjectWorkflowSteps.Attach(Data);
//var update = dbcontext.Entry(Data);
//update.Property(x => x.ProjectId).IsModified = true;
//update.Property(x => x.WorkflowId).IsModified = true;
//update.Property(x => x.WorkflowStepId).IsModified = true;
//update.Property(x => x.IsTransfer).IsModified = true;
//update.Property(x => x.TaskId).IsModified = true;
//update.Property(x => x.InsertDate).IsModified = true;
//update.Property(x => x.InsertedBy).IsModified = true;
dbcontext.ProjectWorkflowSteps.Add(Data);
dbcontext.SaveChanges();
Param.Id = Data.Id;
return(Param);
}
public ProjectWorkflowENT InsertRecordInEmailHistory(ProjectWorkflowENT Param)
{
if (Param.FileName == null)
{
Param.FileName = "";
}
NbkDbEntities dbcontext = new NbkDbEntities();
EmailHistory Data = new EmailHistory
{
ProjectId = Param.ProjectId,
WorkflowId = Param.WorkflowId,
WorkflowStepId = Param.WorkflowStepId,
//PartyId =
Subject = Param.EmailSubject,
ToEmail = Param.EmailTo,
FromEmail = Param.EmailFrom,
Message = Param.EmailContent,
FileName = Param.FileName.ToString(),
Date = DateTime.Now
//PartyTypeId =
//IsEmail =
};
dbcontext.EmailHistory.Add(Data);
dbcontext.SaveChanges();
Param.EmailHistoryId = Data.Id;
return(Param);
}
public ChecklistTemplateENT UpdateSelectSingle(ChecklistTemplateENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ChecklistTemplate Data = new ChecklistTemplate()
{
Id = Obj.Id,
Title = Obj.Title,
IsDefault = Obj.IsDefault
};
dbcontext.ChecklistTemplate.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.Title).IsModified = true;
update.Property(x => x.IsDefault).IsModified = true;
dbcontext.SaveChanges();
if (Obj.ServiceSelectedID > 0)
{
var ServiceDetail = dbcontext.Service.Where(x => x.Id == Obj.ServiceSelectedID).FirstOrDefault();
ServiceDetail.ChecklistTempId = Obj.Id;
dbcontext.SaveChanges();
var PreviousService = dbcontext.Service.Where(x => x.ChecklistTempId == Obj.Id && x.Id != Obj.ServiceSelectedID).FirstOrDefault();
if (PreviousService != null)
{
PreviousService.ChecklistTempId = null;
dbcontext.SaveChanges();
}
}
return(Obj);
}
public void DeleteSlabService(int id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
dbcontext.ServicePerSlab.RemoveRange(dbcontext.ServicePerSlab.Where(x => x.ServiceId == id));
dbcontext.SaveChanges();
}
public List <PartyType> DefaultPartyTypesList(List <ServiceWorkflowCategory> DataServiceWorkflowCatagory)
{
List <int> WorkflowCatagoryIDs = DataServiceWorkflowCatagory.Select(x => x.WorkflowCategoryId).ToList();
NbkDbEntities dbcontext = new NbkDbEntities();
return(dbcontext.PartyType.Where(x => x.IsDefault == true && WorkflowCatagoryIDs.Contains(x.WorkflowCategoryId.GetValueOrDefault())).OrderByDescending(y => y.WorkflowCategoryId).ToList());
}
public ProjectENT SelectSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
Project Obj = dbcontext.Project.Where(x => x.Id == Id).FirstOrDefault();
ProjectENT Data = new ProjectENT()
{
Id = Obj.Id,
Title = Obj.Title,
Address = Obj.Address,
Dated = Obj.Dated,
CustomerId = Obj.CustomerId,
ContactPersonId = Obj.ContactPersonId,
BuildingSupplierId = Obj.BuildingSupplierId,
GardsNo = Obj.GardsNo,
Bruksnmmer = Obj.Bruksnmmer,
PostNo = Obj.PostNo,
Poststed = Obj.Poststed,
Kommune = Obj.Kommune,
Description = Obj.Description,
};
//Get project services and workflow list
Data = GetProjectServiceAndWorkflowList(Data);
return(Data);
}
public List <ProjectServiceENT> InsertProjectServicesList(List <ProjectServiceENT> ServicesList, int projectID)
{
if (ServicesList.Count != 0)
{
foreach (var item in ServicesList)
{
if (item.IsNewAdded == true)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ProjectService Data = new ProjectService()
{
ProjectId = projectID,
ServiceId = item.ServiceId,
Quantity = item.Quantity,
Price = item.Price,
IsNewAdded = false
};
dbcontext.ProjectService.Add(Data);
dbcontext.SaveChanges();
item.Id = Data.Id;
}
}
}
return(ServicesList);
}
public ContactENT UpdateSelectSingle(ContactENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ContactBook Data = new ContactBook()
{
Id = Obj.Id,
Name = Obj.Name,
CompanyName = Obj.CompanyName,
ContactNo = Obj.ContactNo,
Email = Obj.Email
};
dbcontext.ContactBook.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.Name).IsModified = true;
update.Property(x => x.CompanyName).IsModified = true;
update.Property(x => x.ContactNo).IsModified = true;
update.Property(x => x.Email).IsModified = true;
dbcontext.SaveChanges();
return(Obj);
}
public WorkflowCategoryStepENT UpdateSingleWorkflowCategoryStep(WorkflowCategoryStepENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
WorkflowCategorySteps Data = new WorkflowCategorySteps()
{
Id = Obj.Id,
WorkflowCategoryId = Obj.WorkflowCategoryId,
StepName = Obj.StepName,
IsActive = Obj.IsActive,
IsTransferable = Obj.IsTransferable,
StepSequence = Obj.StepSequence
};
dbcontext.WorkflowCategorySteps.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.WorkflowCategoryId).IsModified = true;
update.Property(x => x.StepName).IsModified = true;
update.Property(x => x.IsActive).IsModified = true;
update.Property(x => x.IsTransferable).IsModified = true;
update.Property(x => x.StepSequence).IsModified = true;
dbcontext.SaveChanges();
return(Obj);
}
public List <ProjectENT> GetAllArchivedProjectList(int EntriesFrom, int EntriesTill)
{
NbkDbEntities dbcontext = new NbkDbEntities();
List <Project> Obj = new List <Project>();
EntriesFrom = EntriesFrom - 1;
int EntriesRequired = EntriesTill - EntriesFrom;
Obj = dbcontext.Project.Where(x => x.IsArchived == true).OrderByDescending(x => x.Id).Skip(EntriesFrom).Take(EntriesRequired).ToList();
List <ProjectENT> Data = new List <ProjectENT>();
Data.AddRange(Obj.Select(i => new ProjectENT
{
Id = i.Id,
Title = i.Title,
Dated = i.Dated,
CustomerId = i.CustomerId,
ContactPersonId = i.ContactPersonId,
BuildingSupplierId = i.BuildingSupplierId,
Description = i.Description,
IsDeleted = i.IsDeleted,
IsArchived = i.IsArchived
}));
return(Data);
}
public List <Users> Get()
{
NbkDbEntities _context = new NbkDbEntities();
List <Users> listing = _context.Users.ToList();
return(listing);
}
public UserProfileENT UpdateSelectSingle(UserProfileENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
Users Data = new Users()
{
Id = Obj.Id,
Designation = Obj.Designation,
IsActive = Obj.IsActive,
Password = Obj.Password,
Picture = Obj.Picture,
UserName = Obj.UserName,
UserTypeId = Obj.UserTypeId,
ContactId = Obj.ContactId
};
dbcontext.Users.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.Designation).IsModified = true;
update.Property(x => x.IsActive).IsModified = true;
update.Property(x => x.Password).IsModified = true;
update.Property(x => x.Picture).IsModified = true;
update.Property(x => x.UserName).IsModified = true;
update.Property(x => x.UserTypeId).IsModified = true;
update.Property(x => x.ContactId).IsModified = true;
dbcontext.SaveChanges();
return(Obj);
}
public List <ProjectServiceENT> ListOfProjectServices(int proId)
{
NbkDbEntities dbcontext = new NbkDbEntities();
List <ProjectService> Response = dbcontext.ProjectService.Where(x => x.ProjectId == proId).ToList();
//var qweResponse = from PS in dbcontext.ProjectService
// join S in dbcontext.Service on PS.ServiceId equals S.Id
// where PS.ProjectId == proId
// select new { ProjectService = PS, Service = S };
List <ProjectServiceENT> Data = new List <ProjectServiceENT>();
Data.AddRange(Response.Select(x => new ProjectServiceENT
{
Id = x.Id,
IsNewAdded = x.IsNewAdded,
Price = x.Price,
ProjectId = x.ProjectId,
Quantity = x.Quantity,
ServiceId = x.ServiceId,
Service = x.Service != null ? new ServiceENT {
Id = x.Service.Id, Description = x.Service.Description, Name = x.Service.Name, Rate = x.Service.Rate,
ServiceChargedAs = x.Service.ServiceChargedAs, ServiceTypeId = x.Service.ServiceTypeId
} : null
}).ToList());
return(Data);
}
public void DeleteSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
WorkflowCategory Obj = dbcontext.WorkflowCategory.Where(x => x.Id == Id).FirstOrDefault();
dbcontext.WorkflowCategory.Remove(Obj);
dbcontext.SaveChanges();
}
public void DeleteServiceWorkflowCategoryByServiceID(int ServiceID)
{
NbkDbEntities dbcontext = new NbkDbEntities();
List <ServiceWorkflowCategory> Obj = dbcontext.ServiceWorkflowCategory.Where(x => x.ServiceId == ServiceID).ToList();
dbcontext.ServiceWorkflowCategory.RemoveRange(Obj);
dbcontext.SaveChanges();
}
public void DeleteSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ContactBook Obj = dbcontext.ContactBook.Where(x => x.Id == Id).FirstOrDefault();
dbcontext.ContactBook.Remove(Obj);
dbcontext.SaveChanges();
}
public void DeleteSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
ChecklistTemplate Obj = dbcontext.ChecklistTemplate.Where(x => x.Id == Id).FirstOrDefault();
dbcontext.ChecklistTemplate.Remove(Obj);
dbcontext.SaveChanges();
}
public void DeleteSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
PartyType Obj = dbcontext.PartyType.Where(x => x.Id == Id).FirstOrDefault();
dbcontext.PartyType.Remove(Obj);
dbcontext.SaveChanges();
}
public ProjectENT UpdateSelectSingle(ProjectENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
Project Data = new Project()
{
Id = Obj.Id,
Title = Obj.Id + " - " + Obj.Address + " - " + Obj.GardsNo + "/" + Obj.Bruksnmmer,
Address = Obj.Address,
CustomerId = Obj.CustomerId,
ContactPersonId = Obj.ContactPersonId,
BuildingSupplierId = Obj.BuildingSupplierId,
GardsNo = Obj.GardsNo,
Bruksnmmer = Obj.Bruksnmmer,
PostNo = Obj.PostNo,
Poststed = Obj.Poststed,
Kommune = Obj.Kommune,
Description = Obj.Description
};
dbcontext.Project.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.Title).IsModified = true;
update.Property(x => x.CustomerId).IsModified = true;
update.Property(x => x.ContactPersonId).IsModified = true;
update.Property(x => x.BuildingSupplierId).IsModified = true;
update.Property(x => x.GardsNo).IsModified = true;
update.Property(x => x.PostNo).IsModified = true;
update.Property(x => x.Poststed).IsModified = true;
update.Property(x => x.Kommune).IsModified = true;
update.Property(x => x.Bruksnmmer).IsModified = true;
update.Property(x => x.Description).IsModified = true;
update.Property(x => x.Address).IsModified = true;
dbcontext.SaveChanges();
//Services add
Obj.ProjectService = InsertProjectServicesList(Obj.ProjectService, Obj.Id);
//Adding Default partytype into projectparty table
List <ServiceWorkflowCategory> DataServiceWorkflowCatagory = GetServiceWorkflowCategoryByServiceID(Obj.ProjectService);
List <PartyType> DefaultPartyTypes = DefaultPartyTypesList(DataServiceWorkflowCatagory);
ContactBook Dummy = GetDummyContact();
foreach (var item in DefaultPartyTypes)
{
AddProjectParty(Obj.Id, Dummy.Id, item.Id);
}
//Project checklist creation
ProjectChecklistsOnUpdateCreate(Obj.Id, Obj.ProjectService);
return(Obj);
}
public void ProjectChecklistsOnUpdateCreate(int?ProjectId, List <ProjectServiceENT> ServicesList)
{
NbkDbEntities db = new NbkDbEntities();
List <int> ProjectServiceIDs = ServicesList.Select(X => X.Id).ToList();
//var list = (from r in db.ProjectChecklist where r.ProjectId == ProjectId select r).ToList();
if (ProjectId != null)
{
var listServices = ListOfProjectServicesForUpdate(Convert.ToInt32(ProjectId), ProjectServiceIDs);
foreach (var item in listServices)
{
ChecklistTemplate ObjChecklistTemp = ChecklistTempByServiceID(item.ServiceId);
Service ObjService = ServiceByServiceID(item.ServiceId);
int totalServices = Convert.ToInt32(item.Quantity);
//int a = i + 1;
if (totalServices > 0)
{
for (int i = 0; i < totalServices; i++)
{
//Checklist for ServiceNameHere
ProjectChecklist obj = new ProjectChecklist();
obj.ProjectId = item.ProjectId;
if (item.Service.ChecklistTempId != null)
{
obj.ChecklistName = ObjChecklistTemp.Title;
}
else
{
obj.ChecklistName = "Checklist for " + ObjService.Name;
}
db.ProjectChecklist.Add(obj);
db.SaveChanges();
if (ObjService.ChecklistTempId != null)
{
int ProjectChecklistID = obj.Id;
int ChecklistTempId = Convert.ToInt32(ObjService.ChecklistTempId);
SaveChecklistTemp(ChecklistTempId, ProjectChecklistID);
}
}
}
else
{
ProjectChecklist obj = new ProjectChecklist();
obj.ProjectId = item.ProjectId;
obj.SortOrder = item.Id;
obj.ChecklistName = item.Service.Name + " Checklist";
db.ProjectChecklist.Add(obj);
db.SaveChanges();
}
//Service status change
var ProService = db.ProjectService.Where(x => x.Id == item.Id).FirstOrDefault();
ProService.IsNewAdded = false;
db.SaveChanges();
}
}
}
public ProjectENT CreateSingle(ProjectENT Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
//changes for adding id manually
if (Obj.Id == 0)
{
int maxId = Convert.ToInt32(ProjectsMaxId());
Obj.Id = maxId + 1;
}
Project Data = new Project()
{
Id = Obj.Id,
Title = Obj.Id + " - " + Obj.Address + " - " + Obj.GardsNo + "/" + Obj.Bruksnmmer,
Address = Obj.Address,
Dated = DateTime.Today,
CustomerId = Obj.CustomerId,
ContactPersonId = Obj.ContactPersonId,
BuildingSupplierId = Obj.BuildingSupplierId,
GardsNo = Obj.GardsNo,
Bruksnmmer = Obj.Bruksnmmer,
PostNo = Obj.PostNo,
Poststed = Obj.Poststed,
Kommune = Obj.Kommune,
Description = Obj.Description
//CreateChecklistCdate= Obj.CreateChecklistCdate,
//AddPartiesCdate= Obj.AddPartiesCdate
};
dbcontext.Project.Add(Data);
dbcontext.SaveChanges();
//Services add
InsertProjectServicesList(Obj.ProjectService, Obj.Id);
//Adding Default partytype into projectparty table
List <ServiceWorkflowCategory> DataServiceWorkflowCatagory = GetServiceWorkflowCategoryByServiceID(Obj.ProjectService);
//Get project services and workflow list
Obj = GetProjectServiceAndWorkflowList(Obj);
List <PartyType> DefaultPartyTypes = DefaultPartyTypesList(DataServiceWorkflowCatagory);
ContactBook Dummy = GetDummyContact();
foreach (var item in DefaultPartyTypes)
{
AddProjectParty(Obj.Id, Dummy.Id, item.Id);
}
//Project checklist creation
ProjectChecklistsCreate(Obj.Id);
Obj.Title = Obj.Id + " - " + Obj.Address + " - " + Obj.GardsNo + "/" + Obj.Bruksnmmer;
return(Obj);
}
public void UpdateProjectTitle(Project Obj)
{
NbkDbEntities dbcontext = new NbkDbEntities();
dbcontext.Project.Attach(Obj);
var update = dbcontext.Entry(Obj);
update.Property(x => x.Title).IsModified = true;
dbcontext.SaveChanges();
}
public List <ProjectService> ListOfProjectServicesByWorkflowID(int WorkflowID, int ProjectID)
{
NbkDbEntities dbcontext = new NbkDbEntities();
List <int> ServiceIDListAssociatedWithWorkflow = dbcontext.ServiceWorkflowCategory.Where(x => x.WorkflowCategoryId == WorkflowID).Select(x => x.ServiceId).ToList();
dbcontext = new NbkDbEntities();
List <ProjectService> Data = dbcontext.ProjectService.Where(x => x.ProjectId == ProjectID && ServiceIDListAssociatedWithWorkflow.Contains(Convert.ToInt32(x.ServiceId))).ToList();
return(Data);
}
public void UpdateToken(int userID, string Token)
{
NbkDbEntities context = new NbkDbEntities();
DateTime Today = DateTime.Now;
var db = context.Users.Where(x => x.Id == userID).FirstOrDefault();
db.Token = Token;
db.TokenValidTo = Today.AddDays(7);
db.TokenValidFrom = Today;
context.SaveChanges();
}
public BuildingSupplierENT SelectSingle(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
BuildingSupplierTemplate Obj = dbcontext.BuildingSupplierTemplate.Where(x => x.Id == Id).FirstOrDefault();
BuildingSupplierENT Data = new BuildingSupplierENT()
{
Id = Obj.Id,
Title = Obj.Title
};
return(Data);
}
public bool CheckIfServiceAsocWithProject(int id)
{
bool ifExist = false;
NbkDbEntities dbcontext = new NbkDbEntities();
ProjectService obj = dbcontext.ProjectService.Where(x => x.ServiceId == id).FirstOrDefault();
if (obj != null)
{
ifExist = true;
}
return(ifExist);
}
public void UpdateProjectArchiveStatus(int ProjectID, bool isArchive)
{
NbkDbEntities dbcontext = new NbkDbEntities();
var Data = dbcontext.Project.Where(x => x.Id == ProjectID).FirstOrDefault();
Data.IsArchived = isArchive;
dbcontext.Project.Attach(Data);
var update = dbcontext.Entry(Data);
update.Property(x => x.IsArchived).IsModified = true;
dbcontext.SaveChanges();
}
public bool?IsAdminUser(int Id)
{
NbkDbEntities dbcontext = new NbkDbEntities();
bool? isAdmin = dbcontext.Users
.Join(dbcontext.ContactBook,
x => x.ContactId,
y => y.Id,
(x, y) => new { Y = y, X = x })
.Where(xAndy => xAndy.X.Id == Id).Select(x => x.Y.IsAdmin).FirstOrDefault();
return(isAdmin);
}
