public void setTrxHist(String trxid)
{
trxId = trxid;
var LoadTrxHis = (from hdrTransaction in conn.hdrTransactions
join detPayment in conn.detPayments on hdrTransaction.TrxId equals detPayment.TrxId
where hdrTransaction.TrxId == trxid
select new {
TransactionId = hdrTransaction.TrxId,
TransactionDate = detPayment.TrxDate,
detTrxId = detPayment.detTrxId,
Amount = detPayment.Amount,
Remnant = detPayment.Remnant,
PaymentType = detPayment.PaymentType,
}).ToList();
dgTrxHist.DataSource = LoadTrxHis;
//Remnant = int.Parse((LoadTrxHis[LoadTrxHis.Count-1].Remnant).ToString());
var shouldPay = LoadTrxHis.GroupBy(t => t.TransactionDate)
.Select(group => new { TrxDate = group.Key, payments = group.OrderBy(rem => rem.Remnant) })
.OrderBy(group => group.payments.First().TransactionDate);
foreach (var group in shouldPay)
{
Remnant = 0;
dPays.Clear();
Console.WriteLine(group.TrxDate);
//trxDate = group.TrxDate;
foreach (var payments in group.payments)
{
Console.WriteLine(payments.detTrxId + " " + payments.Amount + " " + payments.Remnant);
Remnant += payments.Remnant.Value;
if (payments.Remnant.Value != 0)
{
dPay = new detPayment();
dPay.TrxId = payments.TransactionId;
dPay.detTrxId = payments.detTrxId;
dPay.Amount = payments.Amount;
dPay.Remnant = payments.Remnant;
dPays.Add(dPay);
}
}
}
if (Remnant == 0)
{
btnPay.Enabled = false;
}
else
{
if (chkAdm.Checked)
{
Remnant += Adm;
}
}
}
void insertPaymenttoDB(detPayment dpay)
{
conn.detPayments.InsertOnSubmit(dpay);
try
{
conn.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void getTrxHist(string TrxID)
{
lastDetPaymentList = new List <detPayment>();
var getTrxHist = (from detPayment in conn.detPayments
//join detAdm in conn.detAdms on detPayment.TrxDate equals detAdm.TrxDate
where detPayment.TrxId == TrxID
select new { detPayment.detId, detPayment.detTrxId, detPayment.TrxDate, detPayment.Amount, detPayment.PaymentType, detPayment.Remnant /*Adm=detAdm.Amount*/ }).ToList();
dgPayDet.DataSource = getTrxHist;
if (getTrxHist != null)
{
string lastPayment = (getTrxHist.Last().TrxDate).ToString();
var lastDetPayment = getTrxHist.Where(trxHist => trxHist.TrxDate == lastPayment);
foreach (var item in lastDetPayment)
{
detPayment tmpLastPay = new detPayment();
tmpLastPay.detId = item.detId;
tmpLastPay.detTrxId = item.detTrxId;
tmpLastPay.TrxDate = item.TrxDate;
tmpLastPay.Amount = item.Amount;
tmpLastPay.Remnant = item.Remnant;
tmpLastPay.PaymentType = item.PaymentType;
lastDetPaymentList.Add(tmpLastPay);
}
txtPaid.Text = (lastDetPayment.Sum(lastTrx => lastTrx.Amount)).ToString();
txtRest.Text = (lastDetPayment.Sum(lastTrx => lastTrx.Remnant)).ToString();
rest = int.Parse(txtRest.Text);
if (rest == 0)
{
txtRest.Text = "0";
btnPay.Enabled = false;
}
else
{
if (chkAdm.Checked)
{
txtRest.Text = (rest + Adm).ToString();
}
else
{
txtRest.Text = (rest).ToString();
}
}
Total = (int.Parse(txtPaid.Text) + rest);
txtTotalAmount.Text = Total.ToString();
}
}
void insertDetPayment(string trxID, int detTrxID, int payamount, int restamount, string payType)
{
detPayment dPay = new detPayment();
dPay.Amount = payamount;
dPay.Remnant = restamount;
dPay.TrxId = trxID;
dPay.TrxDate = DateTime.Now.ToString("yyyyMMddHHmmss");
dPay.PaymentType = payType;
dPay.detTrxId = detTrxID;
conn.detPayments.InsertOnSubmit(dPay);
try
{
conn.SubmitChanges();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
