public void AddUserAccount(UserSignUpView user)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
SYSUser SU = new SYSUser();
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.CreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SU.ModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;;
SU.CreatedDateTime = DateTime.Now;
SU.ModifiedDateTime = DateTime.Now;
db.SYSUsers.Add(SU);
db.SaveChanges();
SYSUserProfile SUP = new SYSUserProfile();
SUP.SYSUserID = SU.SYSUserID;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.CreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.ModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.CreatedDateTime = DateTime.Now;
SUP.ModifiedDateTime = DateTime.Now;
db.SYSUserProfiles.Add(SUP);
db.SaveChanges();
Role userRole = db.Roles.FirstOrDefault(x => x.Name.ToUpper() == "USER");
if (userRole != null)
{
SYSUserRole SUR = new SYSUserRole();
SUR.RoleID = userRole.RoleID;
SUR.SYSUserID = SU.SYSUserID;
SUR.IsActive = true;
SUR.CreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.ModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.CreatedDateTime = DateTime.Now;
SUR.ModifiedDateTime = DateTime.Now;
db.SYSUserRoles.Add(SUR);
db.SaveChanges();
}
//if (user.RoleID > 0)
//{
// SYSUserRole SUR = new SYSUserRole();
// SUR.RoleID = user.RoleID;
// SUR.SYSUserID = user.SYSUserID;
// SUR.IsActive = true;
// SUR.CreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
// SUR.ModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;
// SUR.CreatedDateTime = DateTime.Now;
// SUR.ModifiedDateTime = DateTime.Now;
// db.SYSUserRoles.Add(SUR);
// db.SaveChanges();
//}
}
}
public bool IsLoginNameExist(string loginName)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
return(db.SYSUsers.Where(o => o.LoginName.Equals(loginName)).Any());
}
}
public int GetJobsPerDate(DateTime date)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var result = db.JobCards.Where(x => x.JobDate == date).Count();
return(result);
}
}
public int GetUserID(string userName)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
int result = db.SYSUsers.SingleOrDefault(x => x.LoginName == userName).SYSUserID;
return(result);
}
}
public JobCardView GetJobCard(int jobCardID, bool includeDeleted)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var result = GetViewModel(db.JobCards.SingleOrDefault(x => x.JobCardID == jobCardID && !x.IsDeleted), includeDeleted);
return(result);
}
}
public static string GetJobTypeName(Guid?jobTypeID)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var result = db.JobTypes.Single(x => x.JobTypeID == jobTypeID).Name;
return(result);
}
}
public List <UserView> GetAllUsers()
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
List <UserView> result = new List <UserView>();
db.SYSUsers.ToList().ForEach(y => result.Add(GetViewModel(y)));
return(result);
}
}
public void DeleteMaterial(MaterialView material)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
Material materialDB = db.Materials.Single(x => x.MaterialID == material.MaterialID);
materialDB.IsDeleted = true;
db.SaveChanges();
}
}
public void DeleteJobCard(JobCardView jobCard)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
JobCard jobCardDB = db.JobCards.Single(x => x.JobCardID == jobCard.JobCardID);
jobCardDB.IsDeleted = true;
db.SaveChanges();
}
}
public void DeleteJobType(JobTypeView jobType)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
JobType jobTypeDb = db.JobTypes.Single(x => x.JobTypeID == jobType.JobTypeID);;
jobTypeDb.IsDeleted = true;
db.SaveChanges();
}
}
public void DeleteDesigner(DesignerView designer)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
Designer designerDb = db.Designers.Single(x => x.DesignerID == designer.DesignerID);;
designerDb.IsDeleted = true;
db.SaveChanges();
}
}
public void DeleteCustomer(CustomerView customer)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
Customer customerDb = db.Customers.Single(x => x.CustomerID == customer.CustomerID);;
customerDb.IsDeleted = true;
db.SaveChanges();
}
}
public List <JobCardView> GetInvoiceJobCards(bool includeDeleted)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
List <JobCardView> result = new List <JobCardView>();
db.JobCards.Where(x => !x.IsDeleted && x.TaskStep == 4).ToList().ForEach(y => result.Add(GetViewModel(y, includeDeleted)));
result = result.Where(x => (x.TaskStep == TaskStep.Invoice && x.CreatedDate.Value.AddDays(7) > DateTime.Now) || x.TaskStep < TaskStep.Invoice).ToList();
return(result);
}
}
public void UpdateMaterial(MaterialView material)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
Material materialDb = db.Materials.Single(x => x.MaterialID == material.MaterialID);
materialDb.Description = material.Description;
materialDb.IsDeleted = material.IsDeleted;
materialDb.Name = material.Name;
db.SaveChanges();
}
}
public void UpdateJobType(JobTypeView jobType)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
JobType jobTypeDb = db.JobTypes.Single(x => x.JobTypeID == jobType.JobTypeID);
jobTypeDb.Description = jobType.Description;
jobTypeDb.IsDeleted = jobType.IsDeleted;
jobTypeDb.Name = jobType.Name;
db.SaveChanges();
}
}
public void SetInvoice(string userName, JobCardView jobCard)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
JobCard dbItem = db.JobCards.Single(x => x.JobCardID == jobCard.JobCardID);
dbItem.InvoiceID = GetUserID(userName);
dbItem.InvoiceDate = DateTime.Now;
dbItem.TaskStep = 5;
db.SaveChanges();
}
}
public void UpdateCustomer(CustomerView customer)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
Customer customerDb = db.Customers.Single(x => x.CustomerID == customer.CustomerID);
customerDb.ContactNumber = customer.ContactNumber;
customerDb.Description = customer.Description;
customerDb.IsDeleted = customer.IsDeleted;
customerDb.Name = customer.Name;
db.SaveChanges();
}
}
public void UpdateDesigner(DesignerView designer)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
Designer designerrDb = db.Designers.Single(x => x.DesignerID == designer.DesignerID);
designerrDb.ContactNumber = designer.ContactNumber;
designerrDb.Description = designer.Description;
designerrDb.IsDeleted = designer.IsDeleted;
designerrDb.Name = designer.Name;
db.SaveChanges();
}
}
public string GetUserPassword(string loginName)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var user = db.SYSUsers.Where(o => o.LoginName.ToLower().Equals(loginName));
if (user.Any())
{
return(user.FirstOrDefault().PasswordEncryptedText);
}
else
{
return(string.Empty);
}
}
}
public void CreateMaterial(MaterialView material)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var dbMaterial = new Material
{
MaterialID = Guid.NewGuid(),
Description = material.Description,
IsDeleted = false,
Name = material.Name
};
db.Materials.Add(dbMaterial);
db.SaveChanges();
}
}
public void CreateJobType(JobTypeView jobType)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var dbJobType = new JobType
{
JobTypeID = Guid.NewGuid(),
Description = jobType.Description,
IsDeleted = false,
Name = jobType.Name
};
db.JobTypes.Add(dbJobType);
db.SaveChanges();
}
}
public void CreateDesigner(DesignerView designer)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var dbDesigner = new Designer
{
ContactNumber = designer.ContactNumber,
DesignerID = Guid.NewGuid(),
Description = designer.Description,
IsDeleted = false,
Name = designer.Name
};
db.Designers.Add(dbDesigner);
db.SaveChanges();
}
}
public List <MaterialView> GetAllMaterials(bool includeDeleted)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
List <MaterialView> result = new List <MaterialView>();
if (includeDeleted)
{
db.Materials.ToList().ForEach(y => result.Add(GetViewModel(y)));
}
else
{
db.Materials.Where(x => !x.IsDeleted).ToList().ForEach(y => result.Add(GetViewModel(y)));
}
return(result);
}
}
public void CreateCustomer(CustomerView customer)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var dbCustomer = new Customer
{
ContactNumber = customer.ContactNumber,
CustomerID = Guid.NewGuid(),
Description = customer.Description,
IsDeleted = false,
Name = customer.Name
};
db.Customers.Add(dbCustomer);
db.SaveChanges();
}
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool authorize = false;
using (DigiFusionEntities db = new DigiFusionEntities())
{
UserManager UM = new UserManager();
foreach (var roles in userAssignedRoles)
{
authorize = UM.IsUserInRole(httpContext.User.Identity.Name, roles);
if (authorize)
{
return(authorize);
}
}
}
return(authorize);
}
public List <JobCardView> GetLastJobCards(int amount, int userID, bool includeDeleted)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
List <JobCardView> result = new List <JobCardView>();
db.JobCards.Where(
x => !x.IsDeleted && (
x.ApplicationID == userID ||
x.CladingID == userID ||
x.CreatedID == userID ||
x.InstallID == userID ||
x.InvoiceID == userID ||
x.UVPrinterID == userID)).ToList().ForEach(y => result.Add(GetViewModel(y, includeDeleted)));
result = result.Where(x => (x.TaskStep == TaskStep.Invoice && x.CreatedDate.Value.AddDays(7) > DateTime.Now) || x.TaskStep < TaskStep.Invoice).ToList();
result = result.OrderByDescending(x => x.JobCardID).Take(amount).OrderBy(x => x.JobCardID).ToList();
return(result);
}
}
public bool IsUserInRole(string loginName, string roleName)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
SYSUser SU = db.SYSUsers.Where(o => o.LoginName.ToLower().Equals(loginName))?.FirstOrDefault();
if (SU != null)
{
var roles = from q in db.SYSUserRoles
join r in db.Roles on q.RoleID equals r.RoleID
where r.Name.Equals(roleName) && q.SYSUserID.Equals(SU.SYSUserID)
select r.Name;
if (roles != null)
{
return(roles.Any());
}
}
return(false);
}
}
public void CreateJobCard(JobCardAdminView jobCard)
{
using (DigiFusionEntities db = new DigiFusionEntities())
{
var dbJobCard = new JobCard
{
CustomerID = (Guid)jobCard.CustomerID,
DesignerID = (Guid)jobCard.DesignerID,
IsDeleted = jobCard.IsDeleted,
JobCardID = jobCard.JobCardID,
JobDate = jobCard.JobDate,
JobTypeID = jobCard.JobTypeID,
MaterialID = jobCard.MaterialID,
QuoteRef = jobCard.QuoteRef,
CreatedID = jobCard.CreatedID,
CreatedDate = jobCard.CreatedDate,
Description = jobCard.Description
};
db.JobCards.Add(dbJobCard);
db.SaveChanges();
}
}
