private string GetConsignmentResultDetails(ConsignmentResult result)
{
if (result == null)
{
return("");
}
stringBuilder.Clear();
stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Id",
result.Consignor.ConsignorId));
stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Name",
result.Consignor.ConsignorName.Trim()));
stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor DOB",
((DateTime)result.Consignor.ConsignorDOB).ToString("dd MMMM yyyy")));
stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Phone",
result.Consignor.ConsignorPhone.Trim()));
stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Email",
result.Consignor.ConsignorEmail.Trim()));
stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Period",
ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(result.ConsignmentPeriod)));
stringBuilder.AppendLine(string.Format("{0,-20} {1:n0}", "Returned Items",
result.NumberOfReturnedItems));
stringBuilder.AppendLine(string.Format("{0,-20} {1:c}", "Value Items",
result.TotalValueOfReturnedItems));
stringBuilder.AppendLine(string.Format("{0,-20} {1:c}", "Consignment Result",
result.TotalValueReceivedByConsignor));
return(stringBuilder.ToString());
}
private void ReturnResult(object sender, EventArgs e)
{
if (consignmentResult == null)
{
return;//no result is selected
}
//update consignment result table
consignmentResult.ReturnedDate = DateTime.Now;
consignmentResult.ReturnedBy = ConsignmentStoreBusinessLogic.loggedInEmployee.EmployeeId;
//update expenses table
context.Expenses.Add(new Expens
{//set ConsignmentResult expense date = ReturnedDate
Date = (DateTime)consignmentResult.ReturnedDate,
Amount = consignmentResult.TotalValueReceivedByConsignor,
Category = "ConsignmentResult"
});
context.SaveChanges();//save to database
consignmentResult = null;
//refresh view
dataGridViewConsignmentResults.DataSource = context.ConsignmentResults.Where(result => !result.ReturnedDate.HasValue &&
!result.ReturnedBy.HasValue).ToList();
textBoxResultDetail.Text = GetConsignmentResultDetails(consignmentResult);
}
private void DisplayDetailOfConsignmentResult(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)//not header row
{
int consignorId = int.Parse(dataGridViewConsignmentResults.Rows[e.RowIndex].Cells[0].Value.ToString());
int consignmentPeriod = int.Parse(dataGridViewConsignmentResults.Rows[e.RowIndex].Cells[1].Value.ToString());
//get the consignment result
consignmentResult = context.ConsignmentResults.Local.Single(result =>
result.ConsignmentPeriod == consignmentPeriod &&
result.ConsignorId == consignorId);
//display it
textBoxResultDetail.Text = GetConsignmentResultDetails(consignmentResult);
}
}
