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 WipTaskDelete(int wipTaskID, int deletor)
{
_dbml = new ProjectModelDbEntities();
_task = _dbml.Sales_Wip.SingleOrDefault(x => x.WipTaskID == wipTaskID);
CheckIsDeletable(deletor);
}
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();
}
public WipTaskSchedule(int contentID, DateTime targetDate)
{
_targetDate = MyDateTime.GetDateOfMinusBusinessDays(targetDate, -1);
var dbml = new ProjectModelDbEntities();
_task = dbml.tblWipTasks.First(x => x.ContentID == contentID);
_scheduleStartDate = DateTime.Today;
}
public TaskChangeDueTime(int taskID)
{
_db = new ProjectModelDbEntities();
Sales_Dispatching task = _db.Sales_Dispatching.SingleOrDefault(x => x.TaskID == taskID);
if (task != null)
{
_task = task;
}
}
public SearchProject(String q, string teamIDStr, string myIDStr)
{
int teamID = Convert.ToInt32(teamIDStr);
int myID = Convert.ToInt32(myIDStr);
var itemOptions = new List <ItemOption>();
var dbml = new ProjectModelDbEntities();
//?
List <Sales_JobMasterList> projects =
dbml.Sales_JobMasterList.Where(x => (x.FW_Employees.Team == teamID | teamID == 0) &
(myID == x.sales | myID == x.sa1ID | myID == 5020) |
myID == x.sales |
myID == x.sa1ID
).OrderBy(x => x.jobTitle).ToList();
string[] search = q.Split(' ');
try
{
foreach (Sales_JobMasterList item in projects)
{
if (IsThisJobAlreadSelected(item.jobID, itemOptions))
{
continue;
}
string namevalue = item.jobTitle + " - " + item.jobNumber;
if (!MyString.IsContainsAny(namevalue, search))
{
continue;
}
var st = new ItemOption
{
Name = namevalue,
SelectedID = Convert.ToString(item.jobID),
Value = namevalue
};
itemOptions.Add(st);
}
}
catch (Exception ex)
{
string exp = ex.ToString(); //Setup a breakpoint here to verify any exceptions raised.
}
//Return
Items = itemOptions;
}
public SearchWorkorderByNumber(String q, string teamIDStr, string myIDStr)
{
string[] search = q.Split(' ');
var workorderNumber = search[0];
int teamID = Convert.ToInt32(teamIDStr);
int myID = Convert.ToInt32(myIDStr);
var itemOptions = new List <ItemOption>();
var dbml = new ProjectModelDbEntities();
List <Sales_JobMasterList_WO> query;
if (workorderNumber.Length == 7)
{
query = dbml.Sales_JobMasterList_WO.Where(x => x.WorkorderNumber == workorderNumber).ToList();
}
else
{
query = dbml.Sales_JobMasterList_WO.Where(x => x.WorkorderNumber.Contains(workorderNumber)).ToList();
}
query = query.Where(
x => x.FW_Employees.Team == teamID && myID == 5020 ||
(teamID == 0 && myID == x.Sa1ID || myID == x.Sales || myID == 5020) ||
myID == x.Sa1ID ||
myID == x.Sales
).OrderBy(x => x.WorkorderNumber).ToList();
try
{
foreach (Sales_JobMasterList_WO item in query)
{
string namevalue = item.WorkorderNumber + "V" + item.woRev.ToString() + "-" + item.jobTitle;
var st = new ItemOption
{
Name = namevalue,
SelectedID = Convert.ToString(item.woID),
Value = namevalue
};
itemOptions.Add(st);
}
}
catch (Exception ex)
{
string exp = ex.ToString(); //Setup a breakpoint here to verify any exceptions raised.
}
Items = itemOptions;
}
public SearchProjectByNumber(String q, string teamIDStr, string myIDStr)
{
int teamID = Convert.ToInt32(teamIDStr);
int myID = Convert.ToInt32(myIDStr);
var itemOptions = new List <ItemOption>();
var dbml = new ProjectModelDbEntities();
string[] search = q.Split(' ');
var projectNumber = search[0];
List <Sales_JobMasterList> projects;
if (projectNumber.Length == 8)
{
projects = dbml.Sales_JobMasterList.Where(x => x.jobNumber == projectNumber).ToList();
}
else
{
projects = dbml.Sales_JobMasterList.Where(x => x.jobNumber.Contains(projectNumber)).ToList();
}
projects = projects.Where(x => (x.FW_Employees.Team == teamID | teamID == 0) &
(myID == x.sales | myID == x.sa1ID | myID == 5020) |
myID == x.sales |
myID == x.sa1ID
).OrderBy(x => x.jobTitle).ToList();
if (projects.Any())
{
foreach (Sales_JobMasterList item in projects)
{
string namevalue = item.jobTitle + " - " + item.jobNumber;
var st = new ItemOption
{
Name = namevalue,
SelectedID = Convert.ToString(item.jobID),
Value = namevalue
};
itemOptions.Add(st);
}
}
//Return
Items = itemOptions;
}
public SearchInvoiceByNumber(String q, string teamIDStr, string myIDStr)
{
Items = new List <ItemOption>();
int teamID = Convert.ToInt32(teamIDStr);
int myID = Convert.ToInt32(myIDStr);
string[] search = q.Split(' ');
string invNumber = search[0];
List <Sales_JobMasterList_Invoice> invoices;
var db = new ProjectModelDbEntities();
if (invNumber.Length == 7)
{
invoices = db.Sales_JobMasterList_Invoice.Where(x => x.invoiceNo == invNumber).ToList();
}
else
{
invoices = db.Sales_JobMasterList_Invoice.Where(x => x.invoiceNo.Contains(invNumber)).ToList();
}
invoices = invoices.Where(x => myID == x.Sales || myID == x.SA1 || myID == 5020).OrderBy(x => x.invoiceNo).ToList();
if (invoices.Count == 0)
{
return;
}
foreach (Sales_JobMasterList_Invoice item in invoices)
{
string namevalue = item.invoiceNo + "V" + item.Revision.ToString() + "-" + item.Title;
var st = new ItemOption
{
Name = namevalue,
SelectedID = Convert.ToString(item.invoiceID),
Value = namevalue
};
Items.Add(st);
}
}
public WipTaskSelect(int wipTaskID)
{
_dbml = new ProjectModelDbEntities();
_task = _dbml.Sales_Wip.Find(wipTaskID);
}
public WipTaskPublicUpdateFromInternal(int jobID, int employeeID)
{
_jobID = jobID;
_employeeID = employeeID;
_dbml = new ProjectModelDbEntities();
}
public WipTaskFinish(int jobID, int employeeID)
{
_jobID = jobID;
_employeeID = employeeID;
_dbml = new ProjectModelDbEntities();
}
public WipTaskContent(int contentID)
{
_dbml = new ProjectModelDbEntities();
_taskContent = _dbml.tblWipTasks.First(x => x.ContentID == contentID);
}
public WipTaskCreateNew(Sales_Wip task)
{
_task = task;
_dbml = new ProjectModelDbEntities();
}
