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