public void AddOtherTask() { var dbml = new ProjectModelDbEntities(); var newTask = new Sales_WipPublic { JobID = _jobID, estRevID = 0, quoteRevID = 0, woID = 0, invoiceID = 0, Priority = 0, ContentID = 65531, Contents = "My Contents Here", Status = 0, ScheduleStartDate = DateTime.Today, ScheduleFinishDate = DateTime.Today, Responsible = _employeeID, CreatedBy = _employeeID, LastUpdatedAt = DateTime.Now, LastUpdatedBy = _employeeID }; dbml.Sales_WipPublic.Add(newTask); dbml.SaveChanges(); }
public void CreateNewTaskes() { var dbml = new ProjectModelDbEntities(); List <tblWipTask> taskes = dbml.tblWipTasks.Where(x => x.IsPublic).ToList(); foreach (tblWipTask task in taskes) { var newTask = new Sales_WipPublic { JobID = _jobID, estRevID = 0, quoteRevID = 0, woID = 0, invoiceID = 0, Priority = 0, ContentID = task.ContentID, Contents = task.PublicContentName, Status = 0, ScheduleStartDate = DateTime.Today, ScheduleFinishDate = DateTime.Today.AddDays(task.LeadTime), Responsible = _employeeID, CreatedBy = _employeeID, LastUpdatedAt = DateTime.Now, LastUpdatedBy = _employeeID }; dbml.Sales_WipPublic.Add(newTask); } dbml.SaveChanges(); }
private Sales_WipPublic GetNewTask(Sales_Wip internalTask) { var newTask = new Sales_WipPublic { JobID = _jobID, estRevID = 0, quoteRevID = 0, woID = 0, invoiceID = 0, Priority = 0, ContentID = internalTask.ContentID, Contents = GetContentName(internalTask.ContentID), Status = 0, ScheduleStartDate = internalTask.ScheduleStartDate, ScheduleFinishDate = internalTask.ScheduleFinishDate, Responsible = internalTask.Responsible, CreatedBy = _employeeID, LastUpdatedAt = DateTime.Now, LastUpdatedBy = _employeeID }; return(newTask); }
private Sales_WipPublic GetNewTask(tblWipTask task) { var newTask = new Sales_WipPublic { JobID = _jobID, estRevID = 0, quoteRevID = 0, woID = 0, invoiceID = 0, Priority = 0, ContentID = task.ContentID, Contents = task.ContentName, Status = 0, ScheduleStartDate = DateTime.Today, ScheduleFinishDate = DateTime.Today.AddDays(task.LeadTime), Responsible = _employeeID, CreatedBy = _employeeID, LastUpdatedAt = DateTime.Now, LastUpdatedBy = _employeeID }; return(newTask); }