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 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 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 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 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 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 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 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 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 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 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 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();
}
}
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();
}
}
