private void ImportData()
{
//Retreive document details from database
try
{
using (var dc = new DBAuditDataContext())
{
if (ComboDocNo.SelectedIndex != -1 && ComboName.SelectedIndex != -1)
{
DateTime?varDatePay = null;
int? intLocationId = null;
string strLocation = null;
string strDestination = null;
string strPeriod = null;
decimal? doubleTrans = null;
decimal? doubleTravel = null;
string strNotes = null;
dc.ProSelectTransFee(ComboDocNo.SelectedValue.ToString(), ref varDatePay, ref intLocationId,
int.Parse(ComboName.SelectedValue.ToString()), ref strDestination, ref strPeriod,
ref doubleTrans, ref doubleTravel, ref strNotes);
if (varDatePay != null)
{
DatePay.Value = varDatePay.Value;
}
dc.ProGetLocationByID(intLocationId, ref strLocation);
ComboLocation.Text = strLocation;
TxtDestination.Text = strDestination;
TxtPeriod.Text = strPeriod;
TxtTrans.Text = doubleTrans.ToString();
TxtTravel.Text = doubleTravel.ToString();
TxtNotes.Text = strNotes;
}
else
{
DatePay.Text = null;
ComboLocation.SelectedIndex = -1;
TxtDestination.Clear();
TxtPeriod.Clear();
TxtTrans.Clear();
TxtTravel.Clear();
TxtNotes.Clear();
}
}
}
catch (InvalidOperationException)
{
DatePay.Value = DateTime.Now;
ComboLocation.Text = "";
TxtDestination.Text = "";
TxtPeriod.Text = "";
TxtTrans.Text = "";
TxtTravel.Text = "";
TxtNotes.Text = "";
BtnDelete.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void TxtPeriod_TextChanged(object sender, EventArgs e)
{
if (TxtPeriod.Text == "")
{
return;
}
if (TxtDepoAmt.Text == "")
{
WebMsgBox.Show("Please enter amount", this.Page);
TxtDepoAmt.Focus();
return;
}
// Check Duration
string IsPvalid = "0";
IsPvalid = CurrentCls.CheckPeriod(TxtProcode.Text.ToString(), TxtPeriod.Text.ToString(), ddlduration.SelectedValue.ToString(), Session["BRCD"].ToString(), ddlAccType.SelectedValue);
if (Convert.ToInt32(IsPvalid) > 0)
{
}
else
{
WebMsgBox.Show("Invalid Period...", this.Page);
TxtPeriod.Text = "";
TxtRate.Text = "";
TxtIntrest.Text = "";
TxtMaturity.Text = "";
DtDueDate.Text = "";
TxtPeriod.Focus();
return;
}
// Get rates for Product Code
float rate = CurrentCls.GetIntrestRate(TxtProcode.Text.ToString(), TxtPeriod.Text.ToString(), Session["BRCD"].ToString(), ddlduration.SelectedValue.ToString(), false);
if (rate == 0)
{
WebMsgBox.Show(" Invalid Value... ", this.Page);
TxtPeriod.Text = "";
TxtPeriod.Focus();
return;
}
else
{
TxtRate.Text = rate.ToString();
}
// Calculate Due date
CalDueDate(Convert.ToDateTime(dtDeposDate.Text.ToString()), ddlduration.SelectedItem.Text.ToString(), Convert.ToInt32(TxtPeriod.Text));
// Calculate Interest
float amt = (float)Convert.ToDouble(TxtDepoAmt.Text);
float intrate = (float)Convert.ToDouble(TxtRate.Text);
CalculatedepositINT(amt, TxtProcode.Text.ToString(), intrate, Convert.ToInt32(TxtPeriod.Text), ddlIntrestPay.SelectedItem.Text.ToString(), ddlduration.SelectedItem.Text.ToString());
TxtProcode1.Focus();
}
protected void TxtPeriod_TextChanged(object sender, EventArgs e)
{
try
{
string RT = "";
string RR = FDR.Getrate(TxtPeriod.Text, TxtProcode.Text, ddlduration.SelectedValue, ViewState["ACCTYPE"].ToString(), Session["BRCD"].ToString(), Session["EntryDate"].ToString());
if (RR != null)
{
TxtRate.Text = RR;
RT = TxtRate.Text;
string PT = ddlduration.SelectedItem.Text;
if (PT == "Days" || PT == "DAYS")
{
PT = "D";
}
else if (PT == "Months" || PT == "MONTHS")
{
PT = "M";
}
if (RT != "")
{
// TxtDepoAmt.Text = TxtTotalAmount.Text;
double RATE = Convert.ToDouble(RT);
DtDueDate.Text = conn.AddMonthDay(dtDeposDate.Text, TxtPeriod.Text, PT).Replace("12:00:00", "");
CalculatedepositINT(float.Parse(TxtDepoAmt.Text), TxtProcode.Text, float.Parse(RATE.ToString()), Convert.ToInt32(TxtPeriod.Text), ddlIntrestPay.SelectedItem.Text, ddlduration.SelectedValue);
}
BtnSubmit.Focus();
}
else
{
WebMsgBox.Show("Invalid Period, Add from Interest Master....!", this.Page);
TxtPeriod.Text = "";
TxtPeriod.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtPeriod_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtPeriod.Text == "")
{
return;
}
if (TxtDepoAmt.Text == "")
{
WebMsgBox.Show("Please enter amount", this.Page);
TxtDepoAmt.Focus();
return;
}
// Check Duration
string IsPvalid = "0";
IsPvalid = CurrentCls.CheckPeriod(ddlAccType.SelectedValue.ToString(), ddlProdCode.SelectedValue.ToString(), TxtPeriod.Text.ToString(), ddlduration.SelectedValue.ToString(), Session["BRCD"].ToString());
if (Convert.ToInt32(IsPvalid) > 0)
{
}
else
{
WebMsgBox.Show("Invalid Period...", this.Page);
TxtPeriod.Text = "";
TxtRate.Text = "";
TxtIntrest.Text = "";
TxtMaturity.Text = "";
DtDueDate.Text = "";
TxtPeriod.Focus();
return;
}
// Get rates for Product Code
float rate = CurrentCls.GetIntrestRate(ddlProdCode.SelectedValue.ToString(), TxtPeriod.Text.ToString(), Session["BRCD"].ToString(), ddlduration.SelectedValue.ToString(), false);
if (rate == 0)
{
WebMsgBox.Show(" Invalid Value... ", this.Page);
TxtPeriod.Text = "";
TxtPeriod.Focus();
return;
}
else
{
TxtRate.Text = rate.ToString();
}
if (ddlduration.SelectedValue == "M")
{
DtDueDate.Text = conn.AddMonthDay(dtDeposDate.Text, TxtPeriod.Text, "M").Replace("12:00:00", "");
DtDueDate.Text = conn.AddMonthDay(dtDeposDate.Text, TxtPeriod.Text, "M").Replace("12:00:00", "");
}
else if (ddlduration.SelectedValue == "D")
{
DtDueDate.Text = conn.AddMonthDay(dtDeposDate.Text, TxtPeriod.Text, "D").Replace("12:00:00", "");
DtDueDate.Text = conn.AddMonthDay(dtDeposDate.Text, TxtPeriod.Text, "D").Replace("12:00:00", "");
}
// Calculate Interest
float amt = (float)Convert.ToDouble(TxtDepoAmt.Text);
float intrate = (float)Convert.ToDouble(TxtRate.Text);
CalculatedepositINT(amt, ddlProdCode.SelectedValue.ToString(), intrate, Convert.ToInt32(TxtPeriod.Text), ddlIntrestPay.SelectedItem.Text.ToString(), ddlduration.SelectedItem.Text.ToString());
}
catch (Exception Ex)
{
WebMsgBox.Show(Ex.Message, this.Page);
}
}