private void btnSave_Click(object sender, EventArgs e)
{
PayDayCodeManager oManager = new PayDayCodeManager();
PayDayCodeUnit oUnit = new PayDayCodeUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
oUnit.Code = txtCode.Text;
oUnit.Description = txtDescription.Text;
oUnit.DateCreated = Convert.ToDateTime(dtCreated.EditValue);
oUnit.CreatedBy = txtCreatedBy.Text;
oUnit.DateModified = Convert.ToDateTime(dtModified.EditValue);
oUnit.ModifiedBy = txtModifiedBy.Text;
oUnit.LineItems = this.LineItems;
oManager.Add(oUnit);
oManager.Close();
this.MainMenu.RefreshMainMenu();
}
void BindPayDayCode()
{
PayDayCodeManager oManager = new PayDayCodeManager();
DataTable dtLines = new DataTable();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
dtLines = oManager.GetPayDayCodeHeader();
cboPayDayCode.Properties.DataSource = dtLines;
cboPayDayCode.Properties.DisplayMember = "Remarks";
cboPayDayCode.Properties.ValueMember = "PayDayCode";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("PayDayCode", "Code", 100);
cboPayDayCode.Properties.Columns.Add(col);
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Remarks", "Name", 100);
cboPayDayCode.Properties.Columns.Add(col);
cboPayDayCode.Refresh();
oManager.Close();
}
public void CreateRowInCustomFrequency(string sPayDayCode, string sPayment, int count, string sInterestPaid, string sPrincipalPaid, string sEndingBalance, int countRow)
{
DateTime dateStart = (DateTime)dtStartOfPayment.EditValue;
string sPaymentTerm = cboFrequencyOfPayment.Text;
PayDayCodeManager oManager = new PayDayCodeManager();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
DataTable dtLines = oManager.GetPayDayCodeLineItems(sPayDayCode);
oManager.Close();
int iRowCount = dtLines.Rows.Count;
int iRowNo = 0;
dateStart = dateStart.AddMonths(countRow - 1);
foreach (DataRow lineRow in dtLines.Rows)
{
DataRow oRow = this.LineScheduleOfPayment.NewRow();
oRow["ScheduleNo"] = iRowCounter;
string sMonth = dateStart.Month.ToString();
string sDay = lineRow["DayWeekNo"].ToString();
string sYear = dateStart.Year.ToString();
DateTime dtSchedule;
repeat:
string sConcatMonth = (sMonth + "/" + sDay + "/" + sYear);
try
{
dtSchedule = Convert.ToDateTime(sConcatMonth);
}
catch
{
sDay = (Convert.ToInt16(sDay) - 1).ToString();
goto repeat;
}
//dtSchedule = Convert.ToDateTime(sConcatMonth);
oRow["ScheduledDate"] = dtSchedule;
oRow["PaymentAmount"] = String.Format("{0:N}", Convert.ToDouble(sPayment) / iRowCount); ;
oRow["PrincipalReduction"] = String.Format("{0:N}", Convert.ToDouble(sPrincipalPaid) / iRowCount);
oRow["InterestAmount"] = String.Format("{0:N}", Convert.ToDouble(sInterestPaid) / iRowCount);
oRow["PaidAmount"] = 0;
oRow["OtherCharges"] = 0;
this.LineScheduleOfPayment.Rows.Add(oRow);
iRowCounter = iRowCounter + 1;
}
txtNoOfPayments.Text = (iRowCounter - 1).ToString("#,###");
}