private void duebillPaymentButton_Click(object sender, EventArgs e)
{
if (tempSearchOrderInfo.DueBill > 0)
{
DueBillPaymentForm aDueBillPaymentForm = new DueBillPaymentForm();
aDueBillPaymentForm.ShowDialog();
double amount = 0.0;
if (DueBillPaymentForm.inputResult.Equals("Cancel"))
return;
string amt = DueBillPaymentForm.inputResult.Substring(Program.currency.Length);
if (Convert.ToDouble(amt) == 0.00)
{
CMessageBox tempMessageBox = new CMessageBox("Error!", "Price cannot be zero.");
tempMessageBox.ShowDialog();
return;
}
amount = Convert.ToDouble(amt);
string paymentmethod = "";
string cardName = "";
PaymentMethod aPaymentMethod = new PaymentMethod();
aPaymentMethod.ShowDialog();
paymentmethod = PaymentMethod.inputResult;
if (paymentmethod == "Card")
{
EFTOptionForm eFTOptionForm = new EFTOptionForm();
DialogResult dr = eFTOptionForm.ShowDialog();
if (dr == DialogResult.Cancel)
return;
saveEFTCardAgainsOrderid(EFTOptionForm.seletedEFTCard);
}
PaymentDueBill aPaymentDueBill = new PaymentDueBill();
CPayment aPayment = new CPayment();
aPayment.OrderID = orderID;
double tempamount = 0;
if (amount - tempSearchOrderInfo.DueBill >= 0)
{
tempamount = tempSearchOrderInfo.DueBill;
}
else if (tempSearchOrderInfo.DueBill - amount > 0)
{
tempamount = amount;
}
if (paymentmethod == "Cash")
{
aPayment.CashAmount = tempamount;
aPayment.EFTAmount = 0;
aPaymentDueBill.CashAmount = tempamount;
}
else if (paymentmethod == "Card")
{
aPayment.EFTAmount = tempamount;
aPayment.CashAmount = 0;
aPaymentDueBill.CardAmount = tempamount;
}
aPayment.ChequeAmount = tempSearchOrderInfo.DueBill - tempamount;
aPaymentDueBill.PaymentDate = DateTime.Now;
CPaymentDAO aPaymentDao = new CPaymentDAO();
string sr = aPaymentDao.UpdatePaymentForDueBill(aPayment, aPaymentDueBill);
MessageBox.Show(sr);
this.Close();
}
else
{
MessageBox.Show("Due Bill Must be greater than zero");
}
}
private PaymentDueBill ReaderToReadDueBill(IDataReader oReader)
{
PaymentDueBill aPaymentDueBill = new PaymentDueBill();
try
{
aPaymentDueBill.BillId = Convert.ToInt32(oReader["billId"]);
}
catch (Exception)
{
}
try
{
aPaymentDueBill.CashAmount = Convert.ToDouble(oReader["cashamount"]);
}
catch (Exception)
{
}
try
{
aPaymentDueBill.CardAmount = Convert.ToDouble(oReader["cardamount"]);
}
catch (Exception)
{
}
try
{
aPaymentDueBill.Cheque = Convert.ToDouble(oReader["chequeamount"]);
}
catch (Exception)
{
}
try
{
aPaymentDueBill.PaymentDate = Convert.ToDateTime(oReader["paymentdate"]);
}
catch (Exception)
{
}
return aPaymentDueBill;
}
public string UpdatePaymentForDueBill(CPayment aPayment, PaymentDueBill aPaymentDueBill)
{
string result = "";
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.UpdatePaymentForDueBill), aPayment.OrderID, aPayment.CashAmount, aPayment.EFTAmount, aPayment.ChequeAmount);
this.ExecuteNonQuery(sSql);
result = "Due Bill Payment Successfully";
int billid = CheckExistsDueBill(aPaymentDueBill);
if (billid > 0)
{
aPaymentDueBill.BillId = billid;
sSql = string.Format(SqlQueries.GetQuery(Query.UpdateTotalDueBillPayment), aPaymentDueBill.BillId, aPaymentDueBill.CashAmount, aPaymentDueBill.CardAmount, aPaymentDueBill.Cheque);
this.ExecuteNonQuery(sSql);
}
else
{
sSql = string.Format(SqlQueries.GetQuery(Query.InsertTotalDueBillPayment), aPaymentDueBill.CashAmount, aPaymentDueBill.CardAmount, aPaymentDueBill.Cheque, DateTime.Now.Date);
this.ExecuteNonQuery(sSql);
}
}
catch (Exception ex)
{
result = "Sorry Please Try again";
Logger.Write("Exception : " + ex + " in UpdatePaymentVatStat()", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return result;
}
private int CheckExistsDueBill(PaymentDueBill aPaymentDueBill)
{
int result = 0;
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.CheckExistsDueBill), DateTime.Now.Date);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
while (oReader.Read())
{
result = Convert.ToInt32(oReader[0]);
}
oReader.Close();
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in CheckExistsDueBill()", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return result;
}
public List<PaymentDueBill> GetTotalDuePayment(DateTime duebillfromDate, DateTime duebilltoDate)
{
List<PaymentDueBill> aPaymentDueBills = new List<PaymentDueBill>();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.GetTotalDuePayment), duebillfromDate, duebilltoDate);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
while (oReader.Read())
{
PaymentDueBill aPaymentDueBill = new PaymentDueBill();
aPaymentDueBill = ReaderToReadDueBill(oReader);
aPaymentDueBills.Add(aPaymentDueBill);
}
oReader.Close();
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in CheckExistsDueBill()", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return aPaymentDueBills;
}
