protected void ddlBrName_SelectedIndexChanged(object sender, EventArgs e) { try { txtBrCode.Text = ""; txtWorkDate.Text = ""; txtOpenDate.Text = ""; txtBrCode.Text = ddlBrName.SelectedValue.ToString(); ViewState["EntryDate"] = LG.openDay(txtBrCode.Text.Trim().ToString()); string NextDay = ViewState["EntryDate"].ToString(); NextDay = conn.AddMonthDay(NextDay, "-1", "D"); A: string Holdy = conn.sExecuteScalar("SELECT COUNT(*) FROM AVS1026 WHERE HOLIDAYDATE = '" + conn.ConvertDate(NextDay) + "' AND STATUS = 1 "); if (Holdy != "0") { NextDay = conn.AddMonthDay(NextDay, "-1", "D"); goto A; } else { txtWorkDate.Text = ViewState["EntryDate"].ToString(); txtOpenDate.Text = NextDay.ToString(); BindGrid(); return; } } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } }
protected void txtPeriod_TextChanged(object sender, EventArgs e) { try { if (txtDepAmt.Text == "") { lblMessage.Text = "First Enter Amount...!!"; ModalPopup.Show(this.Page); txtDepAmt.Focus(); return; } if (txtPeriod.Text == "") { return; } if (ddlDuration.SelectedValue == "M") { txtDueDate.Text = conn.AddMonthDay(txtDepDate.Text, txtPeriod.Text, "M").Replace("12:00:00", ""); txtDueDate.Text = conn.AddMonthDay(txtDepDate.Text, txtPeriod.Text, "M").Replace("12:00:00", ""); } else if (ddlDuration.SelectedValue == "D") { txtDueDate.Text = conn.AddMonthDay(txtDepDate.Text, txtPeriod.Text, "D").Replace("12:00:00", ""); txtDueDate.Text = conn.AddMonthDay(txtDepDate.Text, txtPeriod.Text, "D").Replace("12:00:00", ""); } txtIntRate.Focus(); } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } }
public void CalcMatDate() { try { string EffDate, MatDate; if (TxtPeriod.Text != "") { if (DdlDuartion.SelectedValue == "M") { EffDate = Conn.ConvertDate(TxtEffectDate.Text); MatDate = Conn.AddMonthDay(TxtEffectDate.Text, TxtPeriod.Text, "M"); TxtMaturityDate.Text = MatDate.ToString(); } else { EffDate = Conn.ConvertDate(TxtEffectDate.Text); MatDate = Conn.AddMonthDay(TxtEffectDate.Text, TxtPeriod.Text, "D"); TxtMaturityDate.Text = MatDate.ToString(); } } } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } }
protected void TxtPeriod_TextChanged(object sender, EventArgs e) { try { if (TxtPeriod.Text == "") { return; } if (TxtPrincipal.Text == "") { WebMsgBox.Show("Enter Deposit Amount", this.Page); TxtPrincipal.Focus(); return; } //double rate = 0; //TxtIntRate.Text = rate.ToString(); TxtTDate.Text = Conn.AddMonthDay(TxtFDate.Text, TxtPeriod.Text, "M").Replace("12:00:00", ""); float amt = (float)Convert.ToDouble(TxtPrincipal.Text); float intrate = (float)Convert.ToDouble(TxtIntRate.Text); CalculatedepositINT(amt, TxtAccType.Text.ToString(), intrate, Convert.ToInt32(TxtPeriod.Text), "ON MATURITY", "M"); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } }
public string ReOpenDay(string BrCode, string EDate, string LoginCode, string Mid, string Flag) { string RS = ""; try { EDate = conn.AddMonthDay(EDate.ToString(), "-1", "D"); sql = "Exec SP_DayReOpenActivity @BranchCode = '" + BrCode + "', @EntryDate = '" + conn.ConvertDate(EDate).ToString() + "', @LoginCode = '" + LoginCode + "', @Mid = '" + Mid + "', @PcName = '" + conn.PCNAME() + "', @Flag = '" + Flag + "'"; RS = conn.sExecuteScalar(sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(RS); }
protected void TxtRate_TextChanged(object sender, EventArgs e) { // Get rates wise 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()); }
protected void GetChrgs(string FL) { string RES; try { if (FL == "UCC") { RES = OC.GetCharges(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), FL); if (RES != null) { TxtChrgsCheque.Text = RES; } } if (FL == "MCM") { DateTime CDT; string MINMON = ""; MINMON = OC.GetMinMonth(Session["BRCD"].ToString()); string chkdt = conn.AddMonthDay(TxtOpenDate.Text, MINMON, "M").Replace("12:00:00", ""); // OPD = Convert.ToDateTime(TxtOpenDate.Text); CDT = Convert.ToDateTime(chkdt); if (Convert.ToDateTime(Session["EntryDate"].ToString()) <= CDT) { RES = OC.GetCharges(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), FL); if (RES != null) { TxtEarlyClose.Text = RES; } } else { TxtEarlyClose.Text = "0"; } } } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } }
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 ddlBrName_SelectedIndexChanged(object sender, EventArgs e) { try { txtBrCode.Text = ""; txtWorkDate.Text = ""; txtOpenDate.Text = ""; //Check user is admin or not string ADM = DO.checkAdmin(Session["BRCD"].ToString(), Session["LOGINCODE"].ToString(), Session["MID"].ToString()); if (ADM != null && ADM != "") { txtBrCode.Text = ddlBrName.SelectedValue.ToString(); ViewState["EntryDate"] = LG.openDay(txtBrCode.Text.Trim().ToString()); string NextDay = ViewState["EntryDate"].ToString(); NextDay = conn.AddMonthDay(NextDay, "1", "D"); A: string Holdy = conn.sExecuteScalar("SELECT COUNT(*) FROM AVS1026 WHERE HOLIDAYDATE = '" + conn.ConvertDate(NextDay) + "' AND STATUS = 1 "); if (Holdy != "0") { NextDay = conn.AddMonthDay(NextDay, "1", "D"); goto A; } else { txtWorkDate.Text = ViewState["EntryDate"].ToString(); txtOpenDate.Text = NextDay.ToString(); return; } } else { ddlBrName.SelectedValue = Session["BRCD"].ToString(); txtBrCode.Text = Session["BRCD"].ToString(); ViewState["EntryDate"] = LG.openDay(txtBrCode.Text.Trim().ToString()); string NextDay = ViewState["EntryDate"].ToString(); NextDay = conn.AddMonthDay(NextDay, "1", "D"); A: string Holdy = conn.sExecuteScalar("SELECT COUNT(*) FROM AVS1026 WHERE HOLIDAYDATE = '" + conn.ConvertDate(NextDay) + "' AND STATUS = 1 "); if (Holdy != "0") { NextDay = conn.AddMonthDay(NextDay, "1", "D"); goto A; } else { txtWorkDate.Text = ViewState["EntryDate"].ToString(); txtOpenDate.Text = NextDay.ToString(); return; } } } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } }