public DateTime?openDate(int id)
{
tDRCRequest od = new tDRCRequest();
od = dc.tDRCRequests.SingleOrDefault(d => d.ID == id);
return(od.assignedopenDate);
}
List <tDRCRequest> CreateRequestTest()
{
List <UserAccountsResult> analyst = CreateUsersTest();
List <OACode> os = CreateOATest();
List <RTCode> rc = CreateReqType();
List <MD715Code> md7 = CreateMD715Test();
List <AMD715Code> amd7 = CreateAMD715Test();
List <NOTECODE> notes = CreateNoteTest();
List <DisbCode> dis = CreateDisTest();
// IQueryable test = .AsQueryable();
List <tDRCRequest> trequest = new List <tDRCRequest>();
for (int i = 0; i < 101; i++)
{
/*Quick Fake data
*
* rqvm.DateCompleted = new DateTime(2017, 5, 30);
* rqvm.DRCStatus = "Fulfilled";
* rqvm.EmployeeFirstName = Faker.Name.First();
* rqvm.EmployeeLastName = Faker.Name.Last();
* rqvm.EmployeeEmail = Faker.Internet.Email();
* rqvm.SupervisorFirstName = Faker.Name.First();
* rqvm.SupervisorLastName = Faker.Name.Last();
* rqvm.Description = Faker.Lorem.Paragraph();
* rqvm.Comments = Faker.Lorem.Paragraph();
* rqvm.SupervisorPhone = Faker.Phone.Number();
* rqvm.EmployeePhone = Faker.Phone.Number();
*/
Random r = new Random();
int num = r.Next(1, 9);
tDRCRequest sampleRequest = new tDRCRequest()
{
AnalystAssigned = analyst.ElementAt(num).Id,
OA = os.ElementAt(num).OA_CODES,
CaseID = "2017-" + i + os.ElementAt(num).OA_CODES.ToString(),
CreatedBy = "Moore",
DRCRequestType = rc.ElementAt(num).RequestTypeCodes,
DateRequestReceived = DateTime.Now.AddDays(i),
Disability = dis.ElementAt(num).DISABCODES,
RequestedMD715 = num.ToString(),
EndMD715 = num.ToString(),
Notes = notes.ElementAt(num).NOTECODES,
EmployeeFirstName = Faker.Name.First(),
EmployeeLastName = Faker.Name.Last(),
EmployeeEmail = Faker.Internet.Email(),
SupervisorEmail = Faker.Internet.Email(),
Description = Faker.Lorem.Paragraph(),
Comments = Faker.Lorem.Paragraph(),
UpdatedBy = "SomeUser1",
ID = i,
TFToday = 0,
deleted = false,
Source = "Employee"
};
trequest.Add(sampleRequest);
}
return(trequest);
}
public RequestViewModel(tDRCRequest drcTable)
{
ID = drcTable.ID;
OA = drcTable.OA;
CaseID = drcTable.CaseID;
EmployeeID = drcTable.EmployeeID;
EmployeeLastName = drcTable.EmployeeLastName;
EmployeeFirstName = drcTable.EmployeeFirstName;
Position = drcTable.Position;
Grade = drcTable.Grade;
EmployeePhone = drcTable.EmployeePhone;
EmployeePhoneExt = drcTable.EmployeePhoneExt;
EmployeeEmail = drcTable.EmployeeEmail;
Disability = drcTable.Disability;
SupervisorLastName = drcTable.SupervisorLastName;
SupervisorFirstName = drcTable.SupervisorFirstName;
SupervisorEmail = drcTable.SupervisorEmail;
SupervisorPhone = drcTable.SupervisorPhone;
SupervisorPhoneExt = drcTable.SupervisorPhoneExt;
Description = drcTable.Description;
DateRequestReceived = drcTable.DateRequestReceived;
COWADate = drcTable.COWADate;
QuarterReceived = drcTable.QuarterReceived;
DateCompleted = drcTable.DateCompleted;
DateFulfilled = drcTable.DateFulfilled;
DRCRequestType = drcTable.DRCRequestType;
DRCStatus = drcTable.DRCStatus;
OC = drcTable.OC;
Source = drcTable.Source;
RequestedMD715 = drcTable.RequestedMD715;
EndMD715 = drcTable.EndMD715;
AnalystAssigned = drcTable.AnalystAssigned;
TFToday = (int)drcTable.TFToday;
TFReportDate = drcTable.TFReportDate;
ReportInOut = drcTable.ReportInOut;
Notes = drcTable.Notes;
Comments = drcTable.Comments;
deleted = (bool)drcTable.deleted;
CreatedBy = drcTable.CreatedBy;
Purchasing = drcTable.Purchasing;
PRNumber = drcTable.PRNumber;
Amount = drcTable.Amount;
UpdatedBy = drcTable.UpdatedBy;
CreatedDate = drcTable.CreatedDate;
UpdatedDate = drcTable.UpdatedDate;
ProvidedAccom = drcTable.ProvidedAccom;
assignedopenDate = drcTable.assignedopenDate;
}
public void UpdateRequest(RequestViewModel toTable, int id)
{
tDRCRequest nRequest = dc.tDRCRequests.Where(u => u.ID == id).SingleOrDefault();
nRequest.ID = toTable.ID;
nRequest.OA = toTable.OA;
nRequest.CaseID = toTable.CaseID;
nRequest.EmployeeID = toTable.EmployeeID;
nRequest.EmployeeLastName = toTable.EmployeeLastName;
nRequest.EmployeeFirstName = toTable.EmployeeFirstName;
nRequest.Position = toTable.Position;
nRequest.Grade = toTable.Grade;
nRequest.EmployeePhone = toTable.EmployeePhone;
nRequest.EmployeeEmail = toTable.EmployeeEmail;
nRequest.Disability = toTable.Disability;
nRequest.SupervisorLastName = toTable.SupervisorLastName;
nRequest.SupervisorFirstName = toTable.SupervisorFirstName;
nRequest.SupervisorPhone = toTable.SupervisorPhone;
nRequest.Description = toTable.Description;
nRequest.DateRequestReceived = toTable.DateRequestReceived;
nRequest.COWADate = toTable.COWADate;
nRequest.QuarterReceived = toTable.QuarterReceived;
nRequest.DateCompleted = toTable.DateCompleted;
nRequest.DateFulfilled = toTable.DateFulfilled;
nRequest.DRCRequestType = toTable.DRCRequestType;
nRequest.DRCStatus = toTable.DRCStatus;
nRequest.OC = toTable.OC;
nRequest.Source = toTable.Source;
nRequest.RequestedMD715 = toTable.RequestedMD715;
nRequest.EndMD715 = toTable.EndMD715;
nRequest.AnalystAssigned = toTable.AnalystAssigned;
nRequest.TFToday = toTable.TFToday;
nRequest.TFReportDate = toTable.TFReportDate;
nRequest.ReportInOut = toTable.ReportInOut;
nRequest.Notes = toTable.Notes;
nRequest.Comments = toTable.Comments;
nRequest.deleted = toTable.deleted;
nRequest.CreatedBy = toTable.CreatedBy;
nRequest.Purchasing = toTable.Purchasing;
nRequest.PRNumber = toTable.PRNumber;
nRequest.Amount = toTable.Amount;
nRequest.ProvidedAccom = toTable.ProvidedAccom;
nRequest.UpdatedBy = toTable.UpdatedBy;
nRequest.assignedopenDate = toTable.assignedopenDate;
dc.SubmitChanges();
}
public void UpdateRequest(RequestViewModel toTable, int id)
{
tDRCRequest nRequest = fTDRCRequest.SingleOrDefault(p => p.ID == id);
nRequest.ID = toTable.ID;
nRequest.OA = toTable.OA;
nRequest.CaseID = toTable.CaseID;
nRequest.EmployeeID = toTable.EmployeeID;
nRequest.EmployeeLastName = toTable.EmployeeLastName;
nRequest.EmployeeFirstName = toTable.EmployeeFirstName;
nRequest.Position = toTable.Position;
nRequest.Grade = toTable.Grade;
nRequest.EmployeePhone = toTable.EmployeePhone;
nRequest.EmployeeEmail = toTable.EmployeeEmail;
nRequest.Disability = toTable.Disability;
nRequest.SupervisorLastName = toTable.SupervisorLastName;
nRequest.SupervisorFirstName = toTable.SupervisorFirstName;
nRequest.SupervisorPhone = toTable.SupervisorPhone;
nRequest.Description = toTable.Description;
nRequest.DateRequestReceived = toTable.DateRequestReceived;
nRequest.COWADate = toTable.COWADate;
nRequest.QuarterReceived = toTable.QuarterReceived;
nRequest.DateCompleted = toTable.DateCompleted;
nRequest.DateFulfilled = toTable.DateFulfilled;
nRequest.DRCRequestType = toTable.DRCRequestType;
nRequest.DRCStatus = toTable.DRCStatus;
nRequest.OC = toTable.OC;
nRequest.Source = toTable.Source;
nRequest.RequestedMD715 = toTable.RequestedMD715;
nRequest.EndMD715 = toTable.EndMD715;
nRequest.AnalystAssigned = toTable.AnalystAssigned;
nRequest.TFToday = toTable.TFToday;
nRequest.TFReportDate = toTable.TFReportDate;
nRequest.ReportInOut = toTable.ReportInOut;
nRequest.Notes = toTable.Notes;
nRequest.Comments = toTable.Comments;
nRequest.deleted = toTable.deleted;
nRequest.CreatedBy = toTable.CreatedBy;
nRequest.Purchasing = toTable.Purchasing;
nRequest.PRNumber = toTable.PRNumber;
nRequest.UpdatedBy = toTable.UpdatedBy;
//throw new NotImplementedException();
}
public void addRequest(tDRCRequest req)
{
fTDRCRequest.Add(req);
//throw new NotImplementedException();
}
public void addRequest(tDRCRequest req)
{
dc.tDRCRequests.InsertOnSubmit(req);
}
