public async Task <IActionResult> PutRecordDetails(int id, RecordDetails recordDetails)
{
if (id != recordDetails.No)
{
return(BadRequest());
}
_context.Entry(recordDetails).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RecordDetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public decimal findTotalExpenditure(String dept, List <DisbursementList> dList)
{
decimal sum = 0;
List <RecordDetails> rList = new List <RecordDetails>();
for (int i = 0; i < dList.Count; i++)
{
DisbursementList d = dList[i];
string dId = d.Dlid;
var q1 = context.RecordDetails.Where(x => x.Rrid == dId).ToList();
foreach (RecordDetails current in q1)
{
rList.Add(current);
}
}
for (int j = 0; j < rList.Count; j++)
{
RecordDetails r = rList[j];
string ItemNum = r.ItemNumber;
var q2 = context.Catalogue.Where(x => x.ItemNumber == ItemNum).First();
decimal price = (decimal)q2.Supplier1Price;
int Quantity = r.Quantity;
decimal total = price * Quantity;
sum += total;
}
return(sum);
}
public async Task <ActionResult <RecordDetails> > PostRecordDetails(RecordDetails recordDetails)
{
_context.RecordDetails.Add(recordDetails);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetRecordDetails", new { id = recordDetails.No }, recordDetails));
}
public async Task <IActionResult> AddItem(string itemNumber, int quantity)
{
//var q = context.Catalogue.Where(x => x.ItemName == itemName).FirstOrDefault();
//string itemNumber = q.ItemNumber;
bool checkItemExists = false;
var q = context.RecordDetails.Where(x => x.Rrid == rrid).ToList();
foreach (RecordDetails current in q)
{
if (current.ItemNumber == itemNumber)
{
checkItemExists = true;
current.Quantity = current.Quantity + quantity;
await context.SaveChangesAsync();
break;
}
}
if (checkItemExists == false)
{
RecordDetails r = new RecordDetails();
r.Rrid = rrid;
r.ItemNumber = itemNumber;
r.Quantity = quantity;
context.Add(r);
await context.SaveChangesAsync();
return(RedirectToAction("Edit", new { id = rrid }));
}
else
{
return(RedirectToAction("Edit", new { id = rrid }));
}
}
public async Task <IActionResult> Edit(int id, [Bind("Rdid,Rrid,ItemNumber,Quantity,Remark")] RecordDetails recordDetails)
{
if (id != recordDetails.Rdid)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(recordDetails);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RecordDetailsExists(recordDetails.Rdid))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ItemNumber"] = new SelectList(_context.Catalogue, "ItemNumber", "ItemNumber", recordDetails.ItemNumber);
return(View(recordDetails));
}
public async Task <IActionResult> Index(string[] itemSubmitted)
{
ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User);
List <string> identity = userCheck.checkUserIdentityAsync(user);
int userID = user.WorkID;
dept = identity[0];
role = identity[1];
if (itemSubmitted.Length != 0)
{
rrid = b.IDGenerator(dept);
foreach (var item in tempNewRequests)
{
if (Array.Exists(itemSubmitted, i => i == item.ItemNumber.ToString()))
{
//add items to request
RecordDetails r = new RecordDetails();
r.Rrid = rrid;
r.ItemNumber = item.ItemNumber;
r.Quantity = item.Quantity;
r.QuantityDelivered = 0;
_context.RecordDetails.Add(r);
_context.SaveChanges();
}
}
//check if item exists in record details
var record = _context.RecordDetails.FirstOrDefault(x => x.Rrid == rrid);
if (record != null)
{
// Make new EmployeeRequestRecord
EmployeeRequestRecord e = new EmployeeRequestRecord();
DateTime requestDate = DateTime.Now.Date;
int empId = userid;
var findHeadId = _context.Department.Where(x => x.DepartmentCode == dept).First();
int headId = findHeadId.HeadId;
string deptCode = dept;
string status = "Pending Approval";
e.Rrid = rrid;
e.RequestDate = requestDate;
e.DepEmpId = empId;
e.DepHeadId = headId;
e.DepCode = deptCode;
e.Status = status;
_context.EmployeeRequestRecord.Add(e);
_context.SaveChanges();
TempData["Submitted"] = "New request has been created successfully!";
}
}
tempNewRequests = new List <TempNewRequest>();
List <RecordDetails> rdList = _context.RecordDetails.Where(x => x.Rrid == rrid).ToList();
//return RedirectToAction("Details", new { id = rrid });
return(Json(new { redirecturl = "NewRequest/Details/" + rrid }));
}
public async Task <string> PFitem1Async(order source)
{
RecordDetails temp = _context.RecordDetails.Where(s => s.Rdid.ToString() == source.DepName).ToList().First();
temp.Remark = source.status;
_context.Update(temp);
await _context.SaveChangesAsync();
return("123");
}
public async Task <string> PFitemAsync(string amount, string rdid)
{
RecordDetails temp = _context.RecordDetails.Where(s => s.Rdid.ToString() == rdid).ToList().First();
temp.QuantityDelivered = int.Parse(amount);
_context.Update(temp);
await _context.SaveChangesAsync();
return("123");
}
private void HideIndividualDetailsRecord(int id)
{
foreach (Control control in FileScanComparisons.Controls)
{
if (control.Name == "ExpandedRecord_" + id)
{
FileScanComparisons.Controls.Remove(control);
RecordDetails.Remove((FileScanComparison)control);
}
}
}
private int IsLabelFollowed(RecordDetails record)
{
if (_currentUser.FollowedLabels.Any(fa => fa.Id == record.Label.Id))
{
return(2);
}
else
{
return(0);
}
}
private int IsArtistFollowed(RecordDetails record)
{
if (_currentUser.FollowedArtists.Any(fa => fa.Id == record.Artist.Id))
{
return(2);
}
else
{
return(0);
}
}
public async Task <string> saveVoucherAsync(details source)
{
RecordDetails k = new RecordDetails();
var h = _context.Catalogue.Where(s => s.ItemName == source.ItemName).First().ItemNumber;
k.ItemNumber = h;
k.Rrid = source.VoNo;
k.Remark = source.Remark;
k.Quantity = source.Quantity;
_context.RecordDetails.Add(k);
await _context.SaveChangesAsync();
return("ok");
}
public void TestandoInicializaçãoDoRecord()
{
var record = new Record();
var dif = DateTime.Now.Subtract(record.AccessTimestamp).TotalSeconds;
Assert.IsTrue(dif < 1);
Assert.IsTrue(string.IsNullOrEmpty(record.AccessUsername));
Assert.IsNull(record.Details);
var details = new RecordDetails();
Assert.IsTrue(string.IsNullOrEmpty(details.Fields));
Assert.IsTrue(string.IsNullOrEmpty(details.Table));
Assert.IsNotNull(details.Person);
Assert.IsInstanceOfType(details.Person, typeof(Dictionary <string, string>));
}
private FileScanComparison ExpandIndividualDetailsRecord(Panel record, int id)
{
FileScanResult fileScanResult = Results[id];
FileScanComparison expandedRecord = new FileScanComparison();
expandedRecord.Name = "ExpandedRecord_" + id;
expandedRecord.SetFileScanResult(fileScanResult);
expandedRecord.BackColor = Color.White;
expandedRecord.ForeColor = Color.Black;
int y = record.Location.Y + record.Height + 1;
expandedRecord.Location = new Point(record.Location.X, y);
//expandedRecord.AutoScaleMode = AutoScaleMode.Inherit;
RecordDetails.Add(expandedRecord);
FileScanComparisons.Controls.Add(expandedRecord);
return(expandedRecord);
}
public async Task <string> PFitem12Async(order source)
{
RecordDetails temp = _context.RecordDetails.Where(s => s.Rdid.ToString() == source.DepName).ToList().First();
List <RecordDetails> changezero = _context.RecordDetails.Where(s => s.Rrid == temp.Rrid).ToList();
foreach (RecordDetails item in changezero)
{
if (item.QuantityDelivered == 0)
{
item.QuantityDelivered = -1;
_context.Update(item);
}
}
temp.Remark = source.status;
_context.Update(temp);
await _context.SaveChangesAsync();
return("123");
}
public List <string> GetVoucherDetails(string id)
{
List <string> result = new List <string>();
RecordDetails ad = _context.RecordDetails.Where(s => s.Rdid.ToString() == id).ToList().First();
if (ad == null)
{
return(null);
}
else
{
var tem = _context.Catalogue.Where(s => s.ItemNumber == ad.ItemNumber).ToList().First();
result.Add(tem.ItemName);
result.Add(ad.Rdid.ToString());
//this part in fact is price
result.Add(ad.Quantity.ToString());
result.Add(ad.Remark);
return(result);
}
}
private int LabelAndArtistOrderCount(RecordDetails record)
{
return(_currentUser.Orders.Sum(o => o.Items
.Where(i => i.Artist.Id == record.Artist.Id || i.Label.Id == record.Label.Id)
.Sum(i => i.Quantity)));
}
private void DemoDetailsControlButton_Click(object sender, RoutedEventArgs e)
{
RecordDetails window = new RecordDetails(this.RMUrl.Text, this.RUri.Text);
window.ShowDialog();
}
//Generate Disbursement List for a department
public List <RecordDetails> GenerateDisbursementListDetails(string depCode)
{
DateTime start = StationeryRetrivalStartDate();
DateTime cutoff = StationeryRetrivalCutoffDate();
//DisbursementListDetails for a department
List <RecordDetails> result = new List <RecordDetails>();
//Check if a pending delivery disbursement list exists
List <DisbursementList> dlList = _context.DisbursementList
.Where(x => x.DepartmentCode == depCode && x.Status == "Pending Delivery").ToList();
//Get EmployeeRequestRecord of a department, check if it's null
List <EmployeeRequestRecord> errList = _context.EmployeeRequestRecord
.Where(x => x.CompleteDate >= start && x.CompleteDate <= cutoff && x.DepCode == depCode && x.Status == "Approved")
.ToList();
//Get all RecordDetails
List <RecordDetails> rdList = _context.RecordDetails.ToList();
// Check if the disbursement list exists in the database
var dl = _context.DisbursementList.FirstOrDefault(x => x.DepartmentCode == depCode && x.Status == "Pending Delivery");
if (errList != null)
{
if (dl == null)
{
//create a new dl
dl = new DisbursementList()
{
Dlid = IDGenerator("DL"),
StartDate = DateTime.Now,
DepartmentCode = depCode,
EstDeliverDate = null,
CompleteDate = null,
RepId = _context.Department.Find(depCode).RepId,
CollectionPointId = _context.Department.Find(depCode).CollectionPointId,
Status = "Pending Delivery"
};
Console.WriteLine(dl.StartDate);
_context.DisbursementList.Add(dl);
_context.SaveChanges();
}
//Find all needed EmployeeRequestRecordID, add to a list
List <string> rridList = new List <string>();
foreach (EmployeeRequestRecord err in errList)
{
rridList.Add(err.Rrid);
}
//Select out needed EmployeeRequestRecord details
List <RecordDetails> selectederrList = new List <RecordDetails>();
foreach (RecordDetails r in rdList)
{
if (rridList.Contains(r.Rrid))
{
selectederrList.Add(r);
}
}
foreach (RecordDetails r in selectederrList)
{
//check if dl record exists
var rd = _context.RecordDetails.FirstOrDefault(x => x.Rrid == dl.Dlid && x.ItemNumber == r.ItemNumber && x.Remark == null);
rd.Quantity = 0;
if (rd == null)
{
rd = new RecordDetails()
{
Rrid = dl.Dlid, ItemNumber = r.ItemNumber, Quantity = r.Quantity
};
_context.RecordDetails.Add(rd);
}
else
{
rd.Quantity += r.Quantity;
}
_context.SaveChanges();
}
result = _context.RecordDetails.Where(x => x.Rrid == dl.Dlid).ToList();
}
return(result);
}
private bool UserHasAlreadyOrderedTheRecord(RecordDetails record)
{
return(_currentUser.Orders.Any(o => o.Items.Any(i => i.Id == record.Id)));
}
