protected void btn_Save_Click(object sender, EventArgs e) { lblSaveFlag.Text = "Save"; if (lblEdit.Text == "Edit") { KycFormSave(); lblAutoExtend.Text = ""; return; } else { OtherBAL ObjBal = new OtherBAL(); DataSet ds = ObjBal.Idv_Chetana_Get_KycForm_GetMasterCust(txtCustCode.Text, Convert.ToInt32(Session["FY"]), "ChkCode"); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { ModalPopupExtenderNew.Show(); return; } else { KycFormSave(); lblAutoExtend.Text = ""; } } }
protected void btn_PrintSave_Click(object sender, EventArgs e) { lblSaveFlag.Text = "SavePrint"; if (lblEdit.Text == "Edit") { KycFormSave(); Page.ClientScript.RegisterStartupScript( this.GetType(), "OpenWindow", "window.open('KycFormReport.aspx?KycNo=" + lblAutoExtend.Text + "');", true); lblAutoExtend.Text = ""; return; } else { OtherBAL ObjBal = new OtherBAL(); DataSet ds = ObjBal.Idv_Chetana_Get_KycForm_GetMasterCust(txtCustCode.Text, Convert.ToInt32(Session["FY"]), "ChkCode"); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { ModalPopupExtenderNew.Show(); return; } else { KycFormSave(); Page.ClientScript.RegisterStartupScript( this.GetType(), "OpenWindow", "window.open('KycFormReport.aspx?KycNo=" + KycMax.ToString() + "');", true); lblAutoExtend.Text = ""; } } }
private void BindReport() { //if (rdbAll.Checked == true) //{ // All = "All".ToString(); // DDLSuperZone.SelectedValue = "0"; // DDLZone.SelectedValue = "0"; //} //else if (rdbAmount.Checked == true) //{ // Amount = Convert.ToInt32(txtAmount.Text == "" ? "0" : txtAmount.Text); // DDLSuperZone.SelectedValue = "0"; // DDLZone.SelectedValue = "0"; //} DataSet ds = OtherBAL.Idv_Chetana_PANReport(Convert.ToInt32(DDLSuperZone.SelectedValue.ToString()), Convert.ToInt32(DDLZone.SelectedValue.ToString()), Convert.ToInt32(Session["FY"]), "", "", "", ""); if (ds.Tables[0].Rows.Count > 0) { ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Report/PANReport.rpt")); rd.SetDataSource(ds.Tables[0]); //rd.SetParameterValue("SuperZoneName", DDLSuperZone.SelectedValue.ToString() == "0" ? "-" : DDLSuperZone.SelectedItem.Text); //rd.SetParameterValue("ZoneName", DDLZone.SelectedValue.ToString() == "0" ? "-" : DDLZone.SelectedItem.Text); CrystalPanReport.ReportSource = rd; } else { MessageBox("No record found"); DDLSuperZone.Focus(); return; } }
private void GetInvoice() { StringBuilder objste = new StringBuilder("-"); try { DataSet dsMailParams = OtherNewClass.AutoMail.AutoMailParams("customerinv", "", "", "", "", "", "", "", ""); DataTable dtmaildesc = dsMailParams.Tables[0]; DataSet ds = OtherBAL.GetInvoiceLog("System", "", "", ""); DataTable dt = ds.Tables[0]; DoLog(objste, "Get Mail setting Count >> " + dt.Rows.Count.ToString()); //DataTable dtmaildesc = ds.Tables[2]; string FirstPath = string.Empty; string SecondPath = string.Empty; DoLog(objste, "Generating 1 File"); FirstPath = "../AutoEmailAttachment/AutoInvoice/" + DateTime.Now.ToString("MM_dd_yyyy_HH_MM") + "/"; SecondPath = ""; DirectoryManagement(FirstPath); DoLog(objste, "Main Dataset >> "); Response.Write(generatefiles(ds, FirstPath, dtmaildesc)); DoLog(objste, "Wrote Data >> "); } catch (Exception ex) { Response.Write("Error >> " + DoLog(objste, "Error >> " + ex.Message).ToString()); } Response.End(); }
private void ChekedData() { Session["TokenPendingReport"] = null; Other_Z.OtherBAL ObjBAL = new OtherBAL(); OtherBAL.Token_Register_Property ObjProperty = new OtherBAL.Token_Register_Property(); int tokenid; Session["TokenPendingReport"] = null; ObjProperty.R1 = "UpdateTransaction"; ObjProperty.createdBy = Session["UserName"].ToString(); ObjProperty.FY = Convert.ToInt32(Session["FY"]); string TokenNo = ""; StringBuilder sb = new StringBuilder("<r>"); StringBuilder sb1 = new StringBuilder(); try { foreach (RepeaterItem i in Rptrpending.Items) { CheckBox chk = (CheckBox)i.FindControl("chkRepeater"); if (chk.Checked == true) { sb.Append("<i>"); TokenNo = Convert.ToInt32(((CheckBox)chk.Parent.FindControl("chkRepeater")).Text).ToString(); sb.Append("<x>" + TokenNo + "</x>"); sb.Append("</i>"); sb1.Append(TokenNo + ","); } } sb.Append("</r>"); if (TokenNo == "") { MessageBox("Please Checked The Record"); return; } ObjProperty.R2 = sb.ToString(); ObjBAL.Idv_Chetana_Save_Token_Register(ObjProperty, out tokenid); //DataTable dt = FillGridView("TokenTransferReport", sb1.ToString()); //Session["TokenPendingReport"] = dt; Rptrpending.DataSource = FillGridView("TokenPending", ""); Rptrpending.DataBind(); DataTable dt = DataPrint("print", sb1.ToString()); Session["TokenPendingReport"] = dt; bindreport(dt); //Page.ClientScript.RegisterStartupScript( //this.GetType(), "OpenWindow", "window.open('Token_Register_Report.aspx');", true); } catch { throw; } }
private DataTable updateGrid(string R3) { string Id = ""; string R1 = ""; string R2 = ""; string PrintId = ""; string strTemp = ""; string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string ToDate = DateTime.Now.ToString("MM/dd/yyyy"); int TokenKyc = 0; int FY = Convert.ToInt32(Session["FY"]); Other_Z.OtherBAL ObjBAL = new OtherBAL(); DataTable dtgrid = new DataTable(); if (rbtnToken.Checked) { TokenKyc = Convert.ToInt32(txtTokenFind.Text.Trim()); strTemp = "TokenNo"; } else if (rbtnKyc.Checked) { TokenKyc = Convert.ToInt32(txtKycFind.Text.Trim()); strTemp = "KycNo"; } else if (rbtDatewise.Checked) { FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2]; ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2]; } DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId, rbtDatewise.Checked == true ? Convert.ToDateTime(FromDate):Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")), rbtDatewise.Checked == true ? Convert.ToDateTime(ToDate): Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))); dtgrid = ds.Tables[0]; if (dtgrid.Rows.Count == 0) { if (rbtDatewise.Checked) { MessageBox("Record Not Found "); txtFromDate.Focus(); } else if (rbtnKyc.Checked) { MessageBox("Record Not Found "); txtKycFind.Focus(); } else if (rbtnToken.Checked) { MessageBox("Record Not Found "); txtTokenFind.Focus(); } } return(dtgrid); }
private bool CheckedCustomerExists() { bool flage = false; Other_Z.OtherBAL ObjBAL = new OtherBAL(); string CustCode = txtCustomerName.Text.Split(':')[0].ToString().Trim(); if (CustCode != "") { DataSet ds = ObjBAL.Token_Register_Validation(CustCode, Convert.ToInt32(txtKycNo.Text == "" ? 0 : Convert.ToInt32(txtKycNo.Text)), Convert.ToInt32(strFY), "", ""); if (ds.Tables[0].Rows[0][0].ToString() == "BlackList") { MessageBox("This customer is in black list"); txtCustomerName.Focus(); flage = false; return(flage); } if (ds.Tables[0].Rows[0][0].ToString() == "Kyc no not match this Customer") { MessageBox("Kyc no not match this Customer"); txtCustomerName.Focus(); flage = false; return(flage); } if (ds.Tables[0].Rows[0][0].ToString() == "Kyc No is mandatory") { MessageBox("Kyc No is mandatory"); txtKycNo.Focus(); flage = false; return(flage); } else if (ds.Tables[0].Rows[0][0].ToString() == "Invalid Kyc no") { MessageBox("Invalid Kyc no"); txtKycNo.Focus(); txtKycNo.Text = ""; flage = false; return(flage); } else if (ds.Tables[0].Rows[0][0].ToString() == "Invalid Customer") { MessageBox("Invalid Customer"); txtCustomerName.Focus(); txtCustomerName.Text = ""; flage = false; return(flage); } else { flage = true; } } return(flage); }
private void PrintData() { string Fromdate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2]; string Todate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2]; ReportDocument rd = new ReportDocument(); if (rbtSalesman.Checked == true) { if (txtMRCode.Text != "") { DataTable dt = OtherBAL.ReportSpecimanLedger(txtMRCode.Text.Split(':')[0].ToString(), Convert.ToInt32(strFY), "", Fromdate, Todate, chk_AmountWise.Checked == true ? "1" : "0", "").Tables[0]; if (dt.Rows.Count > 0) { SalesmanLedger.Visible = true; rd.Load(Server.MapPath("~/Report/SpecimanLedger.rpt")); rd.SetDataSource(dt); if (chk_AmountWise.Checked == true) { rd.SetParameterValue("Header", "Amount Wise Ledger"); rd.SetParameterValue("Qty", "Order Amt"); rd.SetParameterValue("InvQty", "Inv Amt"); rd.SetParameterValue("CNQty", "CN Amt"); rd.SetParameterValue("Total", "Speciman Sold"); } else { rd.SetParameterValue("Header", "Salesman Ledger"); rd.SetParameterValue("Qty", "Ord. Qty"); rd.SetParameterValue("InvQty", "Inv. Qty"); rd.SetParameterValue("CNQty", "CN Qty"); rd.SetParameterValue("Total", "Total Speciman"); } rd.SetParameterValue("Saleman", txtMRCode.Text.Split(':')[2]); rd.SetParameterValue("SalemanText", "Saleman Name"); rd.SetParameterValue("Fromdate", Fromdate); rd.SetParameterValue("Todate", Todate); SalesmanLedger.ReportSource = rd; } else { MessageBox("Record Not Found"); txtMRCode.Focus(); return; } } } else { MessageBox("BookSet Wise is in progress"); rd = null; return; //Amount Wise } }
private DataTable updateGridWithCustName(string R3) { string Id = ""; string R1 = txtCustomerName.Text; string R2 = ""; int FY = Convert.ToInt32(Session["FY"]); Other_Z.OtherBAL ObjBAL = new OtherBAL(); DataTable dtgrid = new DataTable(); DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, 0, "", DateTime.Now, DateTime.Now); dtgrid = ds.Tables[0]; return(dtgrid); }
public void KycFormPrintDocument() { if (Request.QueryString["KycNo"] != null) { int KycNo = Convert.ToInt32(Request.QueryString["KycNo"].ToString()); Other_Z.OtherBAL ObjBAL = new OtherBAL(); string strFy = Session["FY"].ToString(); DataSet ds = ObjBAL.Idv_Chetana_Report_KycForm(KycNo, Convert.ToInt32(strFy), "kycprint"); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Report/KycForm.rpt")); rd.SetDataSource(ds.Tables[0]); KycFormReportDoc.ReportSource = rd; } }
protected void btnDelete_Click(object sender, EventArgs e) { OtherBAL.KycForm_Property ObjProperty = new OtherBAL.KycForm_Property(); OtherBAL ObjBal = new OtherBAL(); int KycId, KycMax; ObjProperty.R1 = "Del"; ObjProperty.KycNo = Convert.ToInt32(lblKycId.Text); ObjBal.Idv_Chetana_Save_KycForm(ObjProperty, out KycId, out KycMax); Message("Record Delete successfully Kyc Form No is " + KycId.ToString()); lblAutoExtend.Text = ""; btnDelete.Visible = false; Clear(); }
public DataTable DataPrint(string R3, string PrintId) { string Id = ""; string R1 = ""; string R2 = ""; int TokenKyc = 0; int FY = Convert.ToInt32(Session["FY"]); Other_Z.OtherBAL ObjBAL = new OtherBAL(); DataTable dtgrid = new DataTable(); DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId, Convert.ToDateTime(null), Convert.ToDateTime(null)); return(dtgrid = ds.Tables[0]); }
private void PrintData() { if (Request.QueryString["SpecNo"] != "0") { int FY = Convert.ToInt32(Session["FY"].ToString()); if (FY != 0) { OtherBAL ObjBAL = new OtherBAL(); DataSet ds = ObjBAL.Idv_Chetana_Get_Godown_Speciman_Head(Convert.ToInt32(Request.QueryString["SpecNo"].ToString()), FY, "SpecimanPrint"); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Report/GetPassOutSpecimen.rpt")); rd.SetDataSource(ds.Tables[0]); GetPassSpecimen.ReportSource = rd; } } }
protected void txtCustCode_TextChanged(object sender, EventArgs e) { OtherBAL ObjBal = new OtherBAL(); string CustCode = txtCustCode.Text.ToString().Split(':')[0].Trim() + "!" + Session["UserName"].ToString(); DataSet ds = ObjBal.Idv_Chetana_Get_KycForm_CusCode(CustCode, Convert.ToInt32(Session["FY"]), ""); DataTable dt = ds.Tables[1]; if (dt.Rows.Count > 0) { Clear(); if (ds.Tables[1].Columns.Contains("BlackList")) { Message("This customer is in black list"); txtCustCode.Text = CustCode.Split('!')[0].Trim(); return; } else { txtCustCode.Text = CustCode.Split('!')[0].Trim(); txtCustName.Text = dt.Rows[0]["CustName"].ToString(); txtCustAdd.Text = dt.Rows[0]["Address"].ToString(); txtArea.Text = dt.Rows[0]["AreaCode"].ToString(); txtCity.Text = dt.Rows[0]["cityname"].ToString(); txtZipCode.Text = dt.Rows[0]["Zip"].ToString(); txtZoneCode.Text = dt.Rows[0]["ZoneCode"].ToString(); lblZoneCode.Text = dt.Rows[0]["ZoneName"].ToString(); txtTelephone.Text = dt.Rows[0]["telephone_exel"].ToString(); txtMobile.Text = dt.Rows[0]["Phone1"].ToString(); lblOS.Text = dt.Rows[0]["OutStanding"].ToString(); lblAvg.Text = dt.Rows[0]["TotalAvg"].ToString(); txtDelAdd.Text = dt.Rows[0]["Address"].ToString(); lblprvyeardisc.Text = dt.Rows[0]["prevdiscount"].ToString(); lblpreyeartitles.Text = dt.Rows[0]["Titles"].ToString(); txtCustName.Focus(); } } else { Clear(); } }
private DataTable FillGridView(string R3, string PrintId) { string Id = ""; string R1 = ""; string R2 = ""; string strTemp = ""; string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string ToDate = DateTime.Now.ToString("MM/dd/yyyy"); int TokenKyc = 0; int FY = Convert.ToInt32(Session["FY"]); Other_Z.OtherBAL ObjBAL = new OtherBAL(); DataTable dt = new DataTable(); DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId, R3 == strTemp ? Convert.ToDateTime(FromDate) : Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")), R3 == strTemp ? Convert.ToDateTime(ToDate) : Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))); dt = ds.Tables[0]; return(dt); }
private DataTable FillGridData(string R3, string PrintId) { string Id = ""; string R1 = ""; string R2 = ""; int TokenKyc = 0; int FY = Convert.ToInt32(Session["FY"]); Other_Z.OtherBAL ObjBAL = new OtherBAL(); DataTable dtgrid = new DataTable(); string FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2]; string ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2]; DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId, Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate) ); dtgrid = ds.Tables[0]; return(dtgrid); }
protected void btnRemove_Click(object sender, ImageClickEventArgs e) { #region Delete Data Other_Z.OtherBAL ObjBAL = new OtherBAL(); int TokenId = 0; OtherBAL.Token_Register_Property ObjProperty = new OtherBAL.Token_Register_Property(); ImageButton btn = ((ImageButton)sender); ObjProperty.TokenNo = Convert.ToInt32(((Label)btn.Parent.FindControl("lblTokenId")).Text); ObjProperty.FY = Convert.ToInt32(Session["FY"]); ObjProperty.createdBy = Session["UserName"].ToString(); ObjProperty.R1 = "del"; ObjBAL.Idv_Chetana_Save_Token_Register(ObjProperty, out TokenId); if (TokenId == Convert.ToInt32("-1")) { MessageBox("Transaction exists in dc master"); txtCustomerName.Focus(); return; } else { DataTable dt = GetSessionDataTable(); if (dt != null) { bool isedit = false; DataRow[] rows = dt.Select("TokenNo=" + TokenId); DataRow dr = null; if (rows.Length > 0) { dr = rows[0]; dr.Delete(); BindGridWithSession(); Clear(); } } } #endregion }
private void Print() { string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string ToDate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2].ToString(); ToDate = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2].ToString(); DataSet ds = OtherBAL.GetDebitVsCreditReport(txtcustomerid.Text.Split(':')[0].ToString(), Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate), Convert.ToInt32(Session["FY"]), "", ""); if (ds.Tables[0].Rows.Count > 0) { ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Report/DebitVsCredit.rpt")); rd.SetDataSource(ds.Tables[0]); DebitCredit.ReportSource = rd; } else { MessageBox("Record not found"); txtcustomerid.Focus(); return; } }
protected void btn_CashEntry(object sender, EventArgs e) { Other_Z.OtherBAL ObjDal = new OtherBAL(); DataSet ds = ObjDal.idv_Chetana_Get_Bank_Cash_Entries(txtbankcode.Text, Convert.ToInt32(ddlMonth.SelectedValue.ToString()), Convert.ToInt32(Session["FY"]), Convert.ToDecimal("0.0"), "", "", "", ""); if (ds.Tables[0].Rows.Count > 0) { DataView d = new DataView(ds.Tables[0]); d.RowFilter = "DebitAmount > 0"; d.Sort = "Party ASC"; if (d.ToTable().Rows.Count > 0) { PanelPopup.Visible = true; grdPopup.DataSource = null; grdPopup.DataSource = d.ToTable(); grdPopup.DataBind(); } } else { MessageBox("Cash entry not found"); } }
protected void btnAdd_Click(object sender, EventArgs e) { bool flage1 = true; flage1 = DateValidation(); if (flage1 == false) { return; } #region Insert Update Click Add Button bool flage = true; flage = CheckedCustomerExists(); if (flage == false) { return; } if (Convert.ToBoolean(Session["GetDataValidation"]) == true) { Session["TokenRegsterDataTable"] = null; } if (Session["UserName"] != null) { string OrderDate = DateTime.Now.ToString("MM/dd/yyyy"); string DeliveryDate = DateTime.Now.ToString("MM/dd/yyyy"); OrderDate = txtOrderDate.Text.Split('/')[1] + "/" + txtOrderDate.Text.Split('/')[0] + "/" + txtOrderDate.Text.Split('/')[2]; DeliveryDate = txtDeliveryDate.Text.Split('/')[1] + "/" + txtDeliveryDate.Text.Split('/')[0] + "/" + txtDeliveryDate.Text.Split('/')[2]; Other_Z.OtherBAL ObjBAL = new OtherBAL(); OtherBAL.Token_Register_Property ObjProperty = new OtherBAL.Token_Register_Property(); ObjProperty.TokenNo = Convert.ToInt32(lblTokenNo.Text.Trim()); ObjProperty.KYC_No = txtKycNo.Text.Trim() == "" ? "0" : txtKycNo.Text.Trim(); ObjProperty.CustCode = txtCustomerName.Text.Trim(); ObjProperty.DeliveryDate = Convert.ToDateTime(DeliveryDate); ObjProperty.ReceivedVia = ddlReceived.Text.Trim(); ObjProperty.HandOver = txtHandedOverTo.Text.Trim(); ObjProperty.Ord_Rec_Date = Convert.ToDateTime(OrderDate); ObjProperty.Remark = txtRemark.Text.Trim(); ObjProperty.createdBy = Session["UserName"].ToString(); ObjProperty.FY = Convert.ToInt32(Session["FY"]); ObjProperty.R1 = ""; ObjProperty.R2 = ""; ObjProperty.R3 = ""; int tokenid; ObjBAL.Idv_Chetana_Save_Token_Register(ObjProperty, out tokenid); MessageBox("Record save successfully Token No is " + tokenid.ToString()); DataTable CustNamedt = updateGrid("CustName"); DataTable dt = GetSessionDataTable(); if (dt != null) { bool isedit = false; DataRow[] rows = dt.Select("TokenNo=" + tokenid); DataRow dr = null; if (rows.Length > 0) { dr = rows[0]; isedit = true; Session["GetDataValidation"] = false; } else { dr = dt.NewRow(); } dr["TokenNo"] = tokenid; dr["KYC_No"] = ObjProperty.KYC_No == "0" ? "" : ObjProperty.KYC_No; dr["Ord_Rec_Date"] = ObjProperty.Ord_Rec_Date.ToString("dd/MM/yyyy"); dr["CustCode"] = ObjProperty.CustCode; dr["CustName"] = CustNamedt.Rows[0][0].ToString(); dr["DeliveryDate"] = ObjProperty.DeliveryDate.ToString("dd/MM/yyyy"); dr["ReceivedVia"] = ObjProperty.ReceivedVia; dr["HandOver"] = ObjProperty.HandOver; dr["Remark"] = ObjProperty.Remark; if (!isedit) { addRow(dr); Session["GetDataValidation"] = false; } else { } } BindGridWithSession(); Clear(); ChekGetValue = false; } #endregion }
private void KycFormSave() { OtherBAL.KycForm_Property ObjProperty = new OtherBAL.KycForm_Property(); OtherBAL ObjBal = new OtherBAL(); #region Checkbox Values Get string rbtnval = ""; if (rbtnChr.Checked == true) { rbtnval = "CH RECD"; } else if (rbtnSch.Checked == true) { rbtnval = "SCH"; } else if (rbtnWcp.Checked == true) { rbtnval = "WCP"; } else if (rbtnCod.Checked == true) { rbtnval = "COD"; } else { rbtnval = ""; } if (txtDisYear.Text == "") { txtDisYear.Text = "0"; } if (txtTitlesYear.Text == "") { txtTitlesYear.Text = "0"; } #endregion //string OrderDate = txtOrderRecdDate.Text.Split('/')[1] + "/" + txtOrderRecdDate.Text.Split('/')[0] + "/" + txtOrderRecdDate.Text.Split('/')[2]; ObjProperty.KycNo = Convert.ToInt32(lblKycId.Text); ObjProperty.CustCode = txtCustCode.Text.Split(':')[0].ToString(); ObjProperty.CustName = txtCustName.Text; ObjProperty.CustAdd = txtCustAdd.Text; ObjProperty.Area = txtArea.Text; ObjProperty.City = txtCity.Text; ObjProperty.ZipCode = txtZipCode.Text; ObjProperty.ZoneCode = txtZoneCode.Text; ObjProperty.Telepone = txtTelephone.Text; ObjProperty.MobileNo = txtMobile.Text; ObjProperty.IfBookseller = rbtnval; ObjProperty.DelAdd = txtDelAdd.Text; ObjProperty.Transport = txtTransport.SelectedValue; ObjProperty.DisCurrentYear = float.Parse(txtDisYear.Text); ObjProperty.TitleCurrentYear = Convert.ToInt32(txtTitlesYear.Text); ObjProperty.PrevDic = float.Parse(lblprvyeardisc.Text); ObjProperty.PrevTitle = Convert.ToInt32(lblpreyeartitles.Text == ""?"0":lblpreyeartitles.Text); ObjProperty.ChkSchemeLetter = Convert.ToInt32(ChkScheme.Checked); ObjProperty.ChkAddCommFrm = Convert.ToInt32(ChkAddComminsion.Checked); ObjProperty.ChkDisForm = Convert.ToInt32(ChkDisForm.Checked); ObjProperty.Remark = txtRemrk.Text; ObjProperty.FY = Convert.ToInt32(Session["FY"]); ObjProperty.CreatedBy = Session["UserName"].ToString(); ObjProperty.OS = Convert.ToSingle(lblOS.Text); ObjProperty.R1 = lblAvg.Text; ObjProperty.R2 = ""; ObjProperty.R3 = ""; ObjProperty.R4 = ""; ObjBal.Idv_Chetana_Save_KycForm(ObjProperty, out KycId, out KycMax); if (lblEdit.Text == "Edit") { Message("Record save successfully Kyc Form No is " + KycId.ToString()); lblKycId.Text = "0"; lblEdit.Text = ""; btnDelete.Visible = false; Clear(); } else { Message("Record save successfully Kyc Form No is " + KycMax.ToString()); lblKycId.Text = "0"; lblEdit.Text = ""; btnDelete.Visible = false; Clear(); } }
public void fillReport() { bool IsCustomer = false; Other_Z.OtherBAL Objbal = new OtherBAL(); string CustCode = txtcustomerid.Text.ToString(); DataTable dt = new DataTable(); if (lblCustName.Text.ToString().Split(':')[0].Trim().ToLower() == CustCode.ToLower()) { CustCode = lblCustName.Text; } lblCustName.Text = CustCode; txtcustomerid.Text = CustCode.ToString().Split(':')[0].Trim(); if (CustCode.Split('[').Length > 1) { if (CustCode.Split('[')[1].ToString().Split(']')[0].ToLower() == "cust") { //dt = DCMaster.Get_Name(CustCode.ToString().Split(':')[0].Trim(), "Customer").Tables[0]; IsCustomer = true; } else { IsCustomer = false; } } txtcustomerid.Focus(); DataSet ds = new DataSet(); if (txtFromDate.Text.Split('/').Length > 1 && txttoDate.Text.Split('/').Length > 1) { try { //string FROMdate = txtFromDate.Text; //string tOdate = txttoDate.Text; string FROMdate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2]; string tOdate = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2]; ds = Objbal.Idv_Chetana_C_AccountingLedger(CustCode.ToString().Split(':')[0].Trim(), Convert.ToDateTime(FROMdate), Convert.ToDateTime(tOdate), "", Convert.ToInt32(Session["FY"])); //ds = Objbal.Idv_Chetana_C_AccountingLedger("T05",Convert.ToDateTime("01/04/2015"),Convert.ToDateTime("31/03/2016"), "",Convert.ToInt32(2)); } catch (Exception ex) { lblCustName.Text = "Date is incorrect"; txtcustomerid.Text = ""; txtFromDate.Text = ""; txttoDate.Text = ""; totAlAmt1.Visible = false; totAlAmt.Visible = false; } } if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/CNF/report/CNFLedger.rpt")); rd.SetDataSource(ds.Tables[0]); rd.SetParameterValue("IsPrint", Convert.ToBoolean(IsPrint.Checked)); Cnfaccountingledger.ReportSource = rd; totAlAmt1.Visible = true; totAlAmt.Visible = true; Button1.Visible = true; btnPrint.Visible = true; //lbloutstndamt.Text = ds.Tables[1].Rows[0]["Closin_bal"].ToString(); //lblopbal1.Text = ds.Tables[1].Rows[0]["Closin_bal"].ToString(); } else { totAlAmt1.Visible = false; totAlAmt.Visible = false; MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; } } else { totAlAmt1.Visible = false; totAlAmt.Visible = false; MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; txtcustomerid.Focus(); } }
protected void BtnGetDCDetails_Click(object sender, EventArgs e) { OtherBAL ObjBal = new OtherBAL(); string RadioVal = ""; DataSet ds = ObjBal.Idv_Chetana_Get_KycForm(Convert.ToInt32(txtDocIdEdit.Text), Convert.ToInt32(Session["FY"]), Convert.ToInt32("0"), Convert.ToInt32("0"), "", "", "", ""); DataTable dt = ds.Tables[1]; if (dt.Rows.Count > 0) { #region Radio Button Checked RadioVal = dt.Rows[0]["IfBkseller"].ToString(); if (RadioVal == "CH RECD") { rbtnChr.Checked = true; } else if (RadioVal == "SCH") { rbtnSch.Checked = true; } else if (RadioVal == "WCP") { rbtnWcp.Checked = true; } else if (RadioVal == "COD") { rbtnCod.Checked = true; } else { RadioVal = ""; } #endregion lblKycId.Text = dt.Rows[0]["KycNo"].ToString(); txtCustCode.Text = dt.Rows[0]["CustCode"].ToString(); txtCustName.Text = dt.Rows[0]["CustName"].ToString(); txtCustAdd.Text = dt.Rows[0]["CustAddress"].ToString(); txtArea.Text = dt.Rows[0]["Area"].ToString(); txtCity.Text = dt.Rows[0]["City"].ToString(); txtZipCode.Text = dt.Rows[0]["ZipCode"].ToString(); txtZoneCode.Text = dt.Rows[0]["ZoneCode"].ToString(); txtTelephone.Text = dt.Rows[0]["TelNo"].ToString(); txtMobile.Text = dt.Rows[0]["MobileNo"].ToString(); txtDelAdd.Text = dt.Rows[0]["DelAddr"].ToString(); txtTitlesYear.Text = dt.Rows[0]["Titles"].ToString(); txtDisYear.Text = dt.Rows[0]["Dis"].ToString(); //Prev Year Dicount And Title lblprvyeardisc.Text = dt.Rows[0]["PrevDis"].ToString(); lblpreyeartitles.Text = dt.Rows[0]["PrevTitle"].ToString(); ChkScheme.Checked = Convert.ToBoolean(dt.Rows[0]["SchLTR"].ToString()); ChkAddComminsion.Checked = Convert.ToBoolean(dt.Rows[0]["AddCommFrm"].ToString()); ChkDisForm.Checked = Convert.ToBoolean(dt.Rows[0]["DisForm"].ToString()); lblOS.Text = Convert.ToSingle(dt.Rows[0]["OS"]).ToString(); lblAvg.Text = dt.Rows[0]["TotalAvg"].ToString(); txtRemrk.Text = dt.Rows[0]["Remark"].ToString(); // txtPersonInchrg.Text = dt.Rows[0]["PersonInchrg"].ToString(); txtTransport.SelectedValue = dt.Rows[0]["Transport"].ToString(); lblAutoExtend.Text = lblKycId.Text; txtCustCode.Focus(); lblEdit.Text = "Edit"; } else { Message("Info! : \\r\\n Kyc No. " + txtDocIdEdit.Text.Trim() + " Not Found!!!"); ModalPopUpDocNum.Show(); txtDocIdEdit.Text = ""; txtDocIdEdit.Focus(); } }