//public bool CreateJobCard(JobCardView jobCard)
//{
// using (DigiFusionEntities db = new Database.DigiFusionEntities())
// {
// try
// {
// JobCard jc = new JobCard
// {
// CustomerID = (Guid)jobCard.CustomerID,
// DesignerID = (Guid)jobCard.DesignerID,
// JobDate = jobCard.JobDate,
// JobTypeID = jobCard.JobTypeID,
// MaterialID = jobCard.MaterialID,
// QuoteRef = jobCard.QuoteRef
// };
// db.JobCards.Add(jc);
// db.SaveChanges();
// }
// catch
// {
// return false;
// }
// }
// return true;
//}
public string[] GetAllRolesForUser(string userName)
{
using (DigiFusionEntities db = new Database.DigiFusionEntities())
{
var userID = db.SYSUsers.SingleOrDefault(x => x.LoginName == userName).SYSUserID;
var roleIDs = db.SYSUserRoles.Where(x => x.SYSUserID == userID).Select(y => y.RoleID).ToList();
var result = db.Roles.Where(x => roleIDs.Contains(x.RoleID)).Select(y => y.Name).ToArray();
return(result);
}
}
public void SetInstallation(string userName, JobCardView jobCard)
{
using (DigiFusionEntities db = new Database.DigiFusionEntities())
{
JobCard dbItem = db.JobCards.Single(x => x.JobCardID == jobCard.JobCardID);
dbItem.InstallID = GetUserID(userName);
dbItem.InstalDate = DateTime.Now;
dbItem.TaskStep = 4;
db.SaveChanges();
}
}
public MaterialView GetMaterial(Guid id)
{
using (DigiFusionEntities db = new Database.DigiFusionEntities())
{
var material = db.Materials.SingleOrDefault(x => x.MaterialID == id && !x.IsDeleted);
MaterialView result = new MaterialView()
{
MaterialID = material.MaterialID,
Description = material.Description,
Name = material.Name
};
return(result);
}
}
public JobTypeView GetJobType(Guid id)
{
using (DigiFusionEntities db = new Database.DigiFusionEntities())
{
var jobType = db.JobTypes.SingleOrDefault(x => x.JobTypeID == id && !x.IsDeleted);
JobTypeView result = new JobTypeView()
{
JobTypeID = jobType.JobTypeID,
Description = jobType.Description,
Name = jobType.Name
};
return(result);
}
}
public DesignerView GetDesigner(Guid id)
{
using (DigiFusionEntities db = new Database.DigiFusionEntities())
{
var designer = db.Designers.SingleOrDefault(x => x.DesignerID == id && !x.IsDeleted);
DesignerView result = new DesignerView()
{
ContactNumber = designer.ContactNumber,
DesignerID = designer.DesignerID,
Description = designer.Description,
IsDeleted = designer.IsDeleted,
Name = designer.Name
};
return(result);
}
}
public CustomerView GetCustomer(Guid id)
{
using (DigiFusionEntities db = new Database.DigiFusionEntities())
{
var customer = db.Customers.SingleOrDefault(x => x.CustomerID == id && !x.IsDeleted);
CustomerView result = new CustomerView()
{
ContactNumber = customer.ContactNumber,
CustomerID = customer.CustomerID,
Description = customer.Description,
IsDeleted = customer.IsDeleted,
Name = customer.Name
};
return(result);
}
}
