protected void txtbankdet_TextChanged(object sender, EventArgs e) { string BankCode = txtbankdet.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(BankCode, "Bank").Tables[0]; if (dt.Rows.Count != 0) { txtbankdet.Text = BankCode; lblbankname.Text = Convert.ToString(dt.Rows[0]["BankName"]); DDLSelectSet.Focus(); } else { lblbankname.Text = "No such Bank code"; txtbankdet.Focus(); txtbankdet.Text = ""; } }
protected void txtCode_TextChanged(object sender, EventArgs e) { string ECode = txtCode.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(ECode, "BookName").Tables[0]; if (dt.Rows.Count != 0) { txtCode.Text = ECode; lblDescriptionofGoods.Text = dt.Rows[0]["BookName"].ToString(); lblStandard.Text = dt.Rows[0]["Standard"].ToString(); // lblDescriptionofGoods.Visible = true; txtQuantity.Focus(); } else { lblDescriptionofGoods.Text = "No such Book code"; txtCode.Focus(); txtCode.Text = ""; } txtQuantity.Focus(); }
protected void txtbankcoder_TextChanged(object sender, EventArgs e) { string BankCode1 = txtbankcoder.Text.ToString().Split(':')[0].Trim(); DataTable dt3 = new DataTable(); dt3 = DCMaster.Get_Name(BankCode1, "Bank").Tables[0]; if (dt3.Rows.Count != 0) { txtbankcoder.Text = BankCode1; lblbanknamer.Text = Convert.ToString(dt3.Rows[0]["BankName"]); PnlBankRDetails.Visible = false; txtFromDate.Focus(); } else { lblbanknamer.Text = "No such Bank code"; txtbankcoder.Focus(); txtbankcoder.Text = ""; PnlBankRDetails.Visible = false; } }
protected void txtcustomer_TextChanged(object sender, EventArgs e) { CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomer.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); btnadd.Focus(); } else { lblCustName.Text = "No such Customer code"; txtcustomer.Focus(); txtcustomer.Text = ""; } }
protected void btnGstPrint_Click(object sender, EventArgs e) { loder1("wait..", "4000"); ((Button)(sender)).Enabled = false; DCConfirmQtyDetails _objDCConfirmQtyDetails = new DCConfirmQtyDetails(); DCMaster _objDCMaster = new DCMaster(); try { _objDCConfirmQtyDetails.IsPrintInvoice = true; _objDCConfirmQtyDetails.CreatedBy = Convert.ToString(Session["UserName"]); _objDCConfirmQtyDetails.SubDocId = Convert.ToDecimal(((Button)(sender)).CommandArgument.Trim()); _objDCConfirmQtyDetails.AvailableQty = Convert.ToInt32(strFY); _objDCConfirmQtyDetails.Save_DC_PrintInvoiceDetails(1); //Rptrpending.DataSource = DCMaster.Get_ApprovedDocNo(); //Rptrpending.DataBind(); //Rptrpending.DataSource = DCDetails.Get_DC_Completed_IsApproved(Convert.ToInt32(strFY)); //Rptrpending.DataBind(); ((Button)(sender)).BackColor = System.Drawing.Color.Red; ((Button)(sender)).ForeColor = System.Drawing.Color.White; ((Button)(sender)).Enabled = true; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "window", "f_open_window_max('print/ReportInvoicePrint.aspx?d=" + docnewno + "&sd=" + ((Button)(sender)).CommandArgument.Trim() + "&type=GST" + "')", true); // ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "window", "f_open_window_max('print/ReportInvoicePrint.aspx?d=" + docnewno + "&sd=" + //((Button)(sender)).CommandArgument.Trim() + "')", true); } catch (Exception ex) { MessageBox(ex.Message.ToString()); ((Button)(sender)).Enabled = true; } //} }
protected void txtPurchase_TextChanged(object sender, EventArgs e) { try { string ECode = txtPurchase.Text.ToString().Split(':', '[', ']')[0].Trim(); string flag = txtPurchase.Text.ToString().Split(':', '[', ']')[3].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(ECode, flag).Tables[0]; if (dt.Rows.Count != 0) { txtPurchase.Text = ECode; if (flag == "AC") { lblpurchase.Visible = true; lblpurchase.Text = dt.Rows[0]["AC_NAME"].ToString(); } else { lblpurchase.Visible = true; lblpurchase.Text = dt.Rows[0]["CustName"].ToString(); } txtInvAlfa.Focus(); } else { lblpurchase.Text = "No such Party found"; txtPurchase.Focus(); txtPurchase.Text = ""; } } catch { txtPurchase.Text = ""; txtPurchase.Focus(); lblpurchase.Text = "No such Party found"; } }
protected void txtAccode_TextChanged(object sender, EventArgs e) { try { string Accode = txtAccode.Text.ToString().Split(':')[0].Trim(); string flag = txtAccode.Text.ToString().Split(':', '[', ']')[3].Trim(); DataTable dt1 = new DataTable(); dt1 = DCMaster.Get_Name(Accode, flag).Tables[0]; if (dt1.Rows.Count != 0) { if (flag == "AC") { txtAccode.Text = Accode; lblaccname.Text = Convert.ToString(dt1.Rows[0]["AC_NAME"]); //txtperson.Focus(); } else if (flag == "Cust") { txtAccode.Text = Accode; lblaccname.Text = Convert.ToString(dt1.Rows[0]["CustName"]); // txtperson.Focus(); } txtreportcode.Focus(); } else { lblaccname.Text = "No such Account code"; txtAccode.Focus(); txtAccode.Text = ""; } } catch { lblaccname.Text = "No such Account code"; } }
protected void txtcustomer_TextChanged(object sender, EventArgs e) { string CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim(); // txtcustomer.Text = CustCode; DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomer.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); DDlTransport.Focus(); DataSet ds = new DataSet(); ds = Idv.Chetana.BAL.CustomerToTransport.Get_CustomerandTransporterValueAD(CustCode); if (ds.Tables[0].Rows.Count != 0) { pnlGet_TransDetails.Visible = true; grdget.DataSource = ds.Tables[0]; grdget.DataBind(); grdget.Visible = true; } else { grdget.Visible = false; // MessageBox("No Such Record Found"); } } else { lblCustName.Text = "No such Customer code"; txtcustomer.Focus(); txtcustomer.Text = ""; } }
protected void txtcustomer_TextChanged(object sender, EventArgs e) { //PnlAddbk.Visible = false; grdBookDetails.DataBind(); PnlPrint.Visible = false; btnPrint.Visible = false; txtbkcod.Text = ""; string CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "CustomerNAC").Tables[0]; if (dt.Rows.Count != 0) { txtcustomer.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustNameCA"]); PnlAddBook.Visible = true; if (dt.Rows[0]["State"].ToString().ToLower() == "maharashtra") { srate = "l"; } else { srate = "m"; } } else { lblCustName.Text = "No such Customer code"; txtcustomer.Focus(); txtcustomer.Text = ""; srate = ""; } btngetRec.Focus(); }
//protected void txtsalemanCode_TextChanged(object sender, EventArgs e) //{ // string ECode = txtsalemanCode.Text.ToString().Split(':')[0].Trim(); // DataTable dt = new DataTable(); // dt = DCMaster.Get_Name(ECode, "Employee").Tables[0]; // if (dt.Rows.Count != 0) // { // txtsalemanCode.Text = ECode; // lblSalesManName.Text = dt.Rows[0]["FirstName"] + " " + dt.Rows[0]["MiddleName"] + " " + dt.Rows[0]["LastName"]; // txtpIncharge.Focus(); // } // else // { // lblSalesManName.Text = "No such salesman code"; // txtsalemanCode.Focus(); // txtsalemanCode.Text = ""; // } //} protected void txtcustomer_TextChanged(object sender, EventArgs e) { string CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomer.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); if (dt.Rows[0]["State"].ToString().ToLower() == "maharashtra") { srate = "l"; } else { srate = "m"; } //txtsalemanCode.Focus(); ACExttransporter.ContextKey = CustCode; DDlemployee.DataSource = DCMaster.Get_Employee_By_Customer_Code(CustCode, "Employee"); DDlemployee.DataBind(); DDlemployee.Items.Insert(0, new ListItem("-Select-", "0")); DDlemployee.Focus(); // Bind_DDL_Transport(); } else { lblCustName.Text = "No such Customer code"; txtcustomer.Focus(); txtcustomer.Text = ""; srate = ""; } }
protected void btnconfirm_Click(object sender, EventArgs e) { btnconfirm.Enabled = false; Auth = DCMaster.Get_DocumentNum_Authentication(Convert.ToInt32(txtdocno.Text), Convert.ToInt32(strFY)); SubDocNo = Convert.ToDecimal(DCConfirmQtyDetails.Get_DCDetails_SubDocNo_ByDocID(Convert.ToInt32(txtdocno.Text), Convert.ToInt32(strFY)).Rows[0][0].ToString()); if (Auth) { MessageBox("Document no is not available"); txtdocno.Focus(); } else { DCConfirmQtyDetails _objDCConfirmQtyDetails = new DCConfirmQtyDetails(); DCMaster _objDCMaster = new DCMaster(); int DocId = 0; try { foreach (GridViewRow Row in grdconfirm.Rows) { _objDCConfirmQtyDetails.DCDetailID = Convert.ToInt32(((Label)Row.FindControl("lblDCdatils")).Text.Trim()); string Qty = ((TextBox)Row.FindControl("lblavailable")).Text.Trim(); _objDCConfirmQtyDetails.AvailableQty = Convert.ToInt32(Qty); DocId = Convert.ToInt32(((Label)Row.FindControl("lbldocNo")).Text.Trim()); _objDCConfirmQtyDetails.SubDocNo = SubDocNo; _objDCConfirmQtyDetails.SaveDCConfirmQtyDetails(); DCtoGodown _objDCMastertoGodown = new DCtoGodown(); foreach (GridViewRow row in grdconfirm.Rows) { _objDCMastertoGodown.DCDetailID = Convert.ToInt32(((Label)row.FindControl("lblDCdatils")).Text.Trim()); _objDCMastertoGodown.DocumentNo = Convert.ToInt32(((Label)row.FindControl("lbldocNo")).Text.Trim()); _objDCMastertoGodown.EmpID = txtempc.Text.Trim(); _objDCMastertoGodown.CreatedBy = Convert.ToString(Session["UserName"]); _objDCMastertoGodown.SaveGodown(); } } _objDCMaster.DocNo = DocId; _objDCMaster.IsConfirm = true; _objDCMaster.IsApproved = false; _objDCMaster.IsCanceled = false; _objDCMaster.Remark = txtremark.Text.Trim(); _objDCMaster.FinancialYearFrom = Convert.ToInt32(strFY); _objDCMaster.update(1); grdconfirm.DataBind(); MessageBox("DC Confirm successfully for document no. " + txtdocno.Text); loder("DC Confirm successfully for document no. " + txtdocno.Text); lblmessage.InnerHtml = "Last confirm doc no. : " + docno.InnerHtml; //docno.InnerHtml = "Last confirm doc no. : " + docno.InnerHtml; Rptrpending.DataSource = DCMaster.Get_Pending_DocNo(Convert.ToInt32(strFY)); Rptrpending.DataBind(); txtempc.Text = ""; lblEmpName.Text = ""; txtempc.Visible = false; lblEmpName.Visible = false; lblemp.Visible = false; btnconfirm.Visible = false; btnPrint.Visible = false; txtremark.Visible = false; docno.InnerHtml = ""; lblempname1.InnerHtml = ""; lblcustname.InnerHtml = ""; txtremark.Text = ""; string jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='none';"; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true); upOrderNO.Update(); } catch (Exception ex) { MessageBox(ex.Message.ToString()); } } }
protected void btnsave_Click(object sender, EventArgs e) { try { foreach (GridViewRow gv in gvPayment.Rows) { TextBox txtBankName = (TextBox)gv.FindControl("txtBankName"); PettyCashEntry petty = new PettyCashEntry(); petty.EmpId = Convert.ToInt32(((Label)gv.FindControl("lblEmpId")).Text); //petty.UpdatedBy = Session["UserUpdate"].ToString(); petty.VoucherNo = ((Label)gv.FindControl("lblVoucherNo")).Text; petty.PaymentRemar = ((TextBox)gv.FindControl("txtRemark")).Text; string BankCode1 = txtBankName.Text.ToString().Split(':')[0].Trim(); ////modification//////// DataTable dt = new DataTable(); dt = DCMaster.Get_Name(BankCode1, "Bank").Tables[0]; if (dt.Rows.Count != 0) { petty.BankCode = BankCode1; petty.ChequeNo = ((TextBox)gv.FindControl("txtCheque")).Text; } else { txtBankName.Text = string.Empty; } //////end////// if ((((TextBox)gv.FindControl("txtPaymentDate")).Text) == "") { petty.PaidAmount = Convert.ToDecimal("0"); petty.IsPaid = Convert.ToBoolean(false); } else { string strVoucherdate = ((TextBox)gv.FindControl("lblVoucherdate")).Text; string[] strVoucherdateArray = strVoucherdate.Split('/'); strVoucherdate = strVoucherdateArray[1].ToString() + '/' + strVoucherdateArray[0].ToString() + '/' + strVoucherdateArray[2].ToString(); string strPaymentdate = ((TextBox)gv.FindControl("txtPaymentDate")).Text; string[] strPaymentdateArray = strPaymentdate.Split('/'); strPaymentdate = strPaymentdateArray[1].ToString() + '/' + strPaymentdateArray[0].ToString() + '/' + strPaymentdateArray[2].ToString(); DateTime Voucherdate = Convert.ToDateTime(strVoucherdate); DateTime Paymentdate = Convert.ToDateTime(strPaymentdate); if (Voucherdate <= Paymentdate) { petty.IsPaid = Convert.ToBoolean(true); petty.PaidAmount = Convert.ToDecimal(((TextBox)gv.FindControl("txtPaidAmount")).Text); petty.PaymentDate = ((TextBox)gv.FindControl("txtPaymentDate")).Text; // petty.GivenFrom = ((DropDownList)gv.FindControl("ddlGivenFrom")).SelectedItem.Text; string ddlSelsct = ((DropDownList)gv.FindControl("ddlGivenFrom")).SelectedItem.Text; if (ddlSelsct.ToLower() == "select") { } else { petty.GivenFrom = ((DropDownList)gv.FindControl("ddlGivenFrom")).SelectedItem.Text; petty.update(); Bind(); message("Record Saved Successfully"); } } else { message("Payment Date should greater than Voucher Date"); } } } } catch { } }
protected void RepDetailsConfirm_ItemCommand(object source, RepeaterCommandEventArgs e) { { bool Auth = DCMaster.Get_DocumentNum_Authentication(Convert.ToInt32(txtDocno.Text), Convert.ToInt32(strFY)); if (Auth) { MessageBox("Document no is not available"); txtDocno.Focus(); } else { // DCConfirmQtyDetails _objDCConfirmQtyDetails = new DCConfirmQtyDetails(); // DCMaster _objDCMaster = new DCMaster(); DCConfirmQtyDetails _objDCFT = new DCConfirmQtyDetails(); // ActualInvoiceDetails _objactualinvoice = new ActualInvoiceDetails(); Other_Z.ActualInvoice_Details.ActualInvoice_DetailsProp _objactualinvoice = new Other_Z.ActualInvoice_Details.ActualInvoice_DetailsProp(); Other_Z.ActualInvoice_Details ObjBal = new Other_Z.ActualInvoice_Details(); try { #region ActulInvoice Repeater objrep = (Repeater)this.FindControl("RepDetailsConfirm"); GridView objgrid = (GridView)objrep.Items[e.Item.ItemIndex].FindControl("grdapproval"); foreach (GridViewRow row in objgrid.Rows) { _objactualinvoice.GanerateinvoiceId = Convert.ToInt32(((Label)row.FindControl("lblgenerateinvoiceid")).Text); _objactualinvoice.DocumentNo = Convert.ToInt32(txtDocno.Text); _objactualinvoice.SubDocId = Convert.ToDecimal(e.CommandArgument.ToString().Trim()); _objactualinvoice.BookCode = ((Label)row.FindControl("lblbookC")).Text; _objactualinvoice.BookName = ((Label)row.FindControl("lblbookN")).Text; _objactualinvoice.Standard = ((Label)row.FindControl("lblStandard")).Text; _objactualinvoice.Medium = ((Label)row.FindControl("lblMedium")).Text; _objactualinvoice.Rate = Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text); _objactualinvoice.Quantity = Convert.ToInt32(((TextBox)row.FindControl("lblqunty")).Text); _objactualinvoice.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtdiscount")).Text); _objactualinvoice.Amount = Convert.ToInt32(((Label)row.FindControl("lblAqty")).Text) * (Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text) - (Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text) * Convert.ToDecimal(((TextBox)row.FindControl("txtdiscount")).Text) / 100)); // _objactualinvoice.Amount = Convert.ToDecimal(((Label)row.FindControl("lblamt")).Text); _objactualinvoice.Freight = Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text); _objactualinvoice.Tax = Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objactualinvoice.Transporter = (((TextBox)e.Item.FindControl("lbltransporter")).Text); _objactualinvoice.LRNo = (((TextBox)e.Item.FindControl("txtlrno")).Text); // _objactualinvoice.TotalAmount = Convert.ToDecimal(((Label)e.Item.FindControl("lbltotalAmtget")).Text); // Finalamount = Convert.ToDecimal(((Label)row.FindControl("lblTotalAmt")).Text); _objactualinvoice.TotalAmount = Convert.ToDecimal(getTotalValues(objgrid).ToString()) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objactualinvoice.Bundles = (((TextBox)e.Item.FindControl("txtbundles")).Text); _objactualinvoice.CreatedBy = Convert.ToString(Session["UserName"]); _objactualinvoice.FinancialYearFrom = strFY; _objactualinvoice.HSNCode = ((Label)row.FindControl("lblHsnCode")).Text; _objactualinvoice.GSTPer = Convert.ToDecimal(((Label)row.FindControl("lblGstPer")).Text); _objactualinvoice.Typ = e.CommandName == "GSTInvoice" ? "G" : "N"; _objactualinvoice.GSTAmt = Convert.ToDecimal(_objactualinvoice.Amount * _objactualinvoice.GSTPer / 100); TextBox txtIdate1 = ((TextBox)e.Item.FindControl("txtdateabc")); TextBox txtLrdate1 = ((TextBox)e.Item.FindControl("txtlrdate")); _objactualinvoice.IsActive = true; _objactualinvoice.IsDeleted = false; string date1; string lrdate; if (txtIdate1.Text == "") { date1 = "1/1/2001"; } else { date1 = txtIdate1.Text.Split('/')[1] + "/" + txtIdate1.Text.Split('/')[0] + "/" + txtIdate1.Text.Split('/')[2]; } if (txtLrdate1.Text == "") { lrdate = "1/1/2001"; } else { lrdate = txtLrdate1.Text.Split('/')[1] + "/" + txtLrdate1.Text.Split('/')[0] + "/" + txtLrdate1.Text.Split('/')[2]; } _objactualinvoice.InvoiceDate = Convert.ToDateTime(date1); _objactualinvoice.LRDate = Convert.ToDateTime(lrdate); _objactualinvoice.Remark1 = ""; _objactualinvoice.Remark2 = ""; _objactualinvoice.Remark3 = ""; // _objactualinvoice.SaveActual_InvoiceDetails(1); ObjBal.SaveActualInvoiceDetails(_objactualinvoice); // (TextBox)e.Item.FindControl("txtfrieght"); } #endregion #region InvoiceCreate decimal subconfirmdoc = Convert.ToDecimal(e.CommandArgument.ToString().Trim()); // Save Freight and tax Details frieght = Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text); tax = Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); temp = tamount + frieght + tax; // totalamount = tamount; _objDCFT.Auto_ID = Convert.ToInt32(((Label)e.Item.FindControl("Lblautoid")).Text); _objDCFT.DocumentNo = Convert.ToInt32(txtDocno.Text); _objDCFT.SubDocNo = subconfirmdoc; _objDCFT.Freight = Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text); _objDCFT.Tax = Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objDCFT.TotalAmount = Convert.ToDecimal(((Label)e.Item.FindControl("lblallTotalamt")).Text); _objDCFT.LRNo = (((TextBox)e.Item.FindControl("txtlrno")).Text); TextBox txtIdate = ((TextBox)e.Item.FindControl("txtdateabc")); string date; if (txtIdate.Text == "") { date = "1/1/2001"; } else { date = txtIdate.Text.Split('/')[1] + "/" + txtIdate.Text.Split('/')[0] + "/" + txtIdate.Text.Split('/')[2]; } _objDCFT.InvoiceDate = Convert.ToDateTime(date); _objDCFT.AvailableQty = Convert.ToInt32(strFY); _objDCFT.Save_FrightTax_Details(1); // _objDCConfirmQtyDetails.SaveConfirmDetails(); stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); // stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed",Convert.ToInt32(strFY)); // RepDetailsConfirm.DataSource = stDS.Tables[0]; // RepDetailsConfirm.DataBind(); #endregion MessageBox("Invoice Updated successfully " + subconfirmdoc); lblmessage.InnerHtml = "Last updated Invoice no. : " + subconfirmdoc; stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "Edit", Convert.ToInt32(strFY)); RepDetailsConfirm.DataSource = stDS.Tables[0]; RepDetailsConfirm.DataBind(); } catch (Exception ex) { MessageBox(ex.Message.ToString()); } } } }
protected void btnGetRecords_Click(object sender, EventArgs e) { try { string Customer = txtcustomer.Text.Trim(); customrcode = Customer.Split(':')[0].ToString(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(customrcode, "Customer").Tables[0]; if (dt.Rows.Count > 0) { lblCustomerName.Text = dt.Rows[0]["CustName"].ToString(); lblCustID.Text = dt.Rows[0]["CustID"].ToString(); } else { lblCustomerName.Text = "No such customer found"; } DataSet ds1 = new DataSet(); ds = helpdesk.getAllHelpDesk(customrcode, strFY); //ds1 = Customer_cs.Idv_Chetana_Customer_BlackList(0,customrcode,"31-mar-"+DateTime.Now.Year.ToString(),0,1,2,0); RepCustomerDetails.DataSource = ds.Tables[0]; RepCustomerDetails.DataBind(); REpChetanaForcust.DataSource = ds.Tables[1]; REpChetanaForcust.DataBind(); RepChLstOrder.DataSource = ds.Tables[2]; RepChLstOrder.DataBind(); RepPayment.DataSource = ds.Tables[3]; RepPayment.DataBind(); RepPendingDC.DataSource = ds.Tables[5]; RepPendingDC.DataBind(); CustomerDiscount.DataSource = ds.Tables[6]; CustomerDiscount.DataBind(); rptConfirmed.DataSource = ds.Tables[7]; rptConfirmed.DataBind(); rptPOD.DataSource = ds.Tables[8]; rptPOD.DataBind(); if (CustomerDiscount.Items.Count > 0) { lblDiscMsg.Visible = false; } else { lblDiscMsg.Visible = true; } if (RepPendingDC.Items.Count > 0) { lnkMoreDc.Visible = true; LnkBtn.Visible = true; } else { lnkMoreDc.Visible = false; LnkBtn.Visible = false; } // int custId = 0; // if (ds.Tables[0].Rows.Count > 0) // { // custId = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); //} //ds1 = Customer_cs.Idv_Chetana_Customer_BlackList(custId, "HLPDSK", "31-mar-" + DateTime.Now.Year.ToString(), 0, Convert.ToInt32(strFY), 2, 0); //RepOutStanding.DataSource = ds1.Tables[0]; //RepOutStanding.DataBind(); } catch (Exception ex) { } }
public DataTable fillTempBookData(string bookcode, string flag) { DataTable dt = new DataTable(); DataTable tempGetData = new DataTable(); DataColumn colTax = new DataColumn(); colTax.DataType = System.Type.GetType("System.String"); colTax.ColumnName = "Rate"; DataColumn Discount = new DataColumn(); Discount.DataType = System.Type.GetType("System.String"); Discount.ColumnName = "Discount"; DataColumn AdditionalDiscount = new DataColumn(); AdditionalDiscount.DataType = System.Type.GetType("System.String"); AdditionalDiscount.ColumnName = "AdditionalDiscount"; DataColumn Amount = new DataColumn(); Amount.DataType = System.Type.GetType("System.String"); Amount.ColumnName = "Amount"; if (Session["tempDCData"] == null) { //CREATE NEW DATATABLE //ADD COLUMNS IN DATATABLE dt.Columns.Add("DCDetailID"); dt.Columns.Add("BookId"); dt.Columns.Add("BookCode"); dt.Columns.Add("BookName"); //dt.Columns.Add("BookType"); dt.Columns.Add("Standard"); dt.Columns.Add("Medium"); dt.Columns.Add("Quantity"); dt.Columns.Add("GivedQty"); dt.Columns.Add("RemainQty"); dt.Columns.Add("DeliveryDate"); dt.Columns.Add(colTax); dt.Columns.Add(Amount); dt.Columns.Add(Discount); dt.Columns.Add(AdditionalDiscount); //ADD DATA AS PER COLUMNS //Books _objBooks = new Books(); } else { dt = (DataTable)Session["tempDCData"]; } if (flag == "set") { tempGetData = BookSetDetails.Get_BookSetDetailsOn_SetID_ForDC((Convert.ToInt32(DDLSelectSet.SelectedItem.Value)), srate).Tables[0]; } else if (flag == "get") { try { tempGetData = DCDetails.GetDCDatilsByCode(bookcode, "documentno").Tables[0]; } catch { } } else { tempGetData = Books.Get_BooksMasterForDC(bookcode, srate).Tables[0]; Isblock = (Convert.ToBoolean(tempGetData.Rows[0]["IsBlock"].ToString())); } foreach (DataRow row in tempGetData.Rows) { price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); if (dt.Rows.Count != 0) { DataView dv = new DataView(dt); dv.RowFilter = "BookCode = '" + row["BookCode"].ToString() + "'"; int i = 0; price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); foreach (DataRowView row1 in dv) { i++; } if (i == 0) { DataSet ds = DCMaster.Get_Discount_On_CusomerAND_Booktype(txtcustomer.Text.ToString() + "!" + Session["FY"].ToString(), row["BookCode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { discount = Convert.ToDecimal(ds.Tables[0].Rows[0][0]); Adddiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][1]); // Totaldiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][2]); Tdiscount = amt * (discount / 100); amt = amt - Tdiscount; } if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); dcid = row["DCDetailID"].ToString(); string EDate = row["DeliveryDate"].ToString(); EDate = EDate.Split('/')[1] + "/" + EDate.Split('/')[0] + "/" + EDate.Split('/')[2]; Delidate = Convert.ToDateTime(EDate); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(row["Amount"].ToString()); discount = Convert.ToDecimal(row["Discount"].ToString()); } dt.Rows.Add(dcid, row["Bookid"].ToString(), row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, Delidate.ToString("dd/MM/yyyy"), String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:0.00}", Convert.ToDecimal(amt)), String.Format("{0:0.00}", Convert.ToDecimal(discount)), String.Format("{0:0.00}", Convert.ToDecimal(Adddiscount))); } } else { DataSet ds = DCMaster.Get_Discount_On_CusomerAND_Booktype(txtcustomer.Text.ToString() + "!" + Session["FY"].ToString(), row["BookCode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { discount = Convert.ToDecimal(ds.Tables[0].Rows[0][0]); Adddiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][1]); // Totaldiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][2]); Tdiscount = amt * (discount / 100); amt = amt - Tdiscount; } if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); dcid = row["DCDetailID"].ToString(); string EDate = row["DeliveryDate"].ToString(); EDate = EDate.Split('/')[1] + "/" + EDate.Split('/')[0] + "/" + EDate.Split('/')[2]; Delidate = Convert.ToDateTime(EDate); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(row["Amount"].ToString()); discount = Convert.ToDecimal(row["Discount"].ToString()); } dt.Rows.Add(dcid, row["Bookid"].ToString(), row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, Delidate.ToString("dd/MM/yyyy"), String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:0.00}", Convert.ToDecimal(amt)), String.Format("{0:0.00}", Convert.ToDecimal(discount)), String.Format("{0:0.00}", Convert.ToDecimal(Adddiscount))); } } return(dt); }
protected void BtnGetDCDetails_Click(object sender, EventArgs e) { String cd = ""; ModalPopUpDocNum.Hide(); Session["tempDCData"] = null; int DocNum = Convert.ToInt32(ddldocno.SelectedValue); // bool condition = false; cd = "1"; DataSet ds = DCMaster.Get_DCMasterBy_DocNum(DocNum, "1"); DataTable dt = ds.Tables[0]; DataTable dtzone = ds.Tables[2]; cd = "2"; if (dt.Rows.Count > 0) { txtdocnew.Text = dt.Rows[0]["DocumentNo_New"].ToString(); txtdoc.Text = dt.Rows[0]["DocumentNo"].ToString(); txtchalan.Text = dt.Rows[0]["ChallanNo"].ToString(); txtChalDate.Text = dt.Rows[0]["ChallanDate"].ToString(); txtorder.Text = dt.Rows[0]["OrderNo"].ToString(); txtcustomer.Text = dt.Rows[0]["CustCode"].ToString(); lblCustName.Text = dt.Rows[0]["CustName"].ToString(); DDlemployee.Items.Clear(); cd = "3"; try { DDlemployee.DataSource = DCMaster.Get_Employee_By_Customer_Code(txtcustomer.Text.ToString(), "Employee"); DDlemployee.DataBind(); cd = "4"; if (DDlemployee.Items.Count > 0) { DDlemployee.SelectedValue = dt.Rows[0]["SalesmanCode"].ToString(); cd = "5"; DDlemployee.SelectedItem.Text = dt.Rows[0]["SalesmanName"].ToString(); cd = "6"; } txtOrdDate.Text = dt.Rows[0]["OrderDate"].ToString(); txtdocDate.Text = dt.Rows[0]["DocumentDate"].ToString(); txtpIncharge.Text = dt.Rows[0]["PIncharge"].ToString(); txtspInstruct.Text = dt.Rows[0]["SpInstruction"].ToString(); txtbankdet.Text = dt.Rows[0]["BankCode"].ToString(); lblbankname.Text = dt.Rows[0]["BankName"].ToString(); cd = "7"; //Extra Zone Code Bind if (dtzone.Rows.Count > 0) { lblZoneCode.Visible = true; DDLZone.Visible = true; DDLZone.Items.Clear(); DDLZone.DataSource = ds.Tables[2]; DDLZone.DataBind(); if (dt.Rows[0]["ExtraZoneCode"].ToString() != "") { //DDLZone.SelectedValue = dt.Rows[0]["ExtraZoneCode"].ToString(); } } else { DDLZone.Items.Clear(); lblZoneCode.Visible = false; DDLZone.Visible = false; } txtDeliverydte.Text = Convert.ToDateTime(DCMaster.Get_DCMasterBy_DocNum(DocNum, "0").Tables[1].Rows[0]["DeliveryDate"].ToString()).ToString("dd/MM/yyyy"); UpdatePanel14.Update(); } catch (Exception ex) { MessageBox(cd); //Response.Write(ex.Message.ToString()); } // Bind_DDL_Transport(); // Ddltransport.SelectedValue = dt.Rows[0]["TransportID"].ToString(); if (dt.Rows[0]["TransporterCode"].ToString() == "Trans") { lbltransporter.Visible = false; lbltransporter.Text = dt.Rows[0]["TransporterCode"].ToString(); txttransporter.Text = dt.Rows[0]["Transporter"].ToString(); } else { txttransporter.Text = dt.Rows[0]["TransporterCode"].ToString(); lbltransporter.Visible = true; lbltransporter.Text = dt.Rows[0]["Transporter"].ToString(); } //DataSet ds = new DataSet(); // ds = SpecimanDetails.GetSpecimenDatilsByEmpCode(Convert.ToString(DocNum), "documentno"); DataTable dt1 = new DataTable(); if (Session["tempDCData"] != null) { Session["tempDCData"] = fillTempBookData(DocNum.ToString(), "get"); dt1 = (DataTable)Session["tempDCData"]; } else { Session["tempDCData"] = fillTempBookData(DocNum.ToString(), "get"); dt1 = (DataTable)Session["tempDCData"]; } grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); grdBookDetails.Columns[5].Visible = true; grdBookDetails.Columns[4].Visible = true; btn_Save.Visible = true; //DataTable dt3 = new DataTable(); //dt3 = ds.Tables[0]; //Session["tempDCData"] = dt3; grdBookDetails.Visible = true; // btn_Save.Visible = false; } else { message("Record not found for document no. " + TxtDocNo.Text); ModalPopUpDocNum.Show(); TxtDocNo.Text = ""; TxtDocNo.Focus(); btn_Save.Visible = false; } }
protected void btnGetData_Click(object sender, EventArgs e) { string CustCode = txtcustomerid.Text.ToString().Split(':')[0].Trim(); FromDate = Convert.ToDateTime(Func.getMonthInNameDate(txtFromDate.Text.Trim())); ToDate = Convert.ToDateTime(Func.getMonthInNameDate(txttoDate.Text.Trim())); if (CustCode != "") { try { DataTable dt = new DataTable(); dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0]; if (dt.Rows.Count != 0) { txtcustomerid.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); txtcustomerid.Focus(); DataSet ds = new DataSet(); ds = LeadgerDetails.Get_LedgerDetails(CustCode, "customer", "fromno", "tono", Convert.ToInt32(strFY), FromDate, ToDate); if (ds.Tables[0].Rows.Count > 0) { gvLedger.DataSource = ds; gvLedger.DataBind(); Button1.Visible = true; btnPrint.Visible = true; flag1 = CustCode; flag2 = "customer"; flag3 = "fromno"; flag4 = "tono"; flag5 = FromDate; flag6 = ToDate; } else { gvLedger.DataSource = null; gvLedger.DataBind(); MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; } } else { lblCustName.Text = "No such Customer code"; txtcustomerid.Focus(); txtcustomerid.Text = ""; } } catch (Exception ex) { } } else { lblCustName.Text = ""; DataSet ds1 = new DataSet(); ds1 = LeadgerDetails.Get_LedgerDetails(CustCode, "All", "fromno", "tono", Convert.ToInt32(strFY), FromDate, ToDate); gvLedger.DataSource = ds1; gvLedger.DataBind(); flag1 = CustCode; flag2 = "All"; flag3 = "fromno"; flag4 = "tono"; flag5 = FromDate; flag6 = ToDate; } }
protected void lblupdate_Click(object sender, EventArgs e) { try { Button lnkUpdate = (Button)sender; TextBox txtRemark = (TextBox)lnkUpdate.Parent.FindControl("txtRemark"); TextBox txtDepositDate = (TextBox)lnkUpdate.Parent.FindControl("txtDepositDate"); TextBox txtBankName = (TextBox)lnkUpdate.Parent.FindControl("txtBankName"); foreach (GridViewRow gv in GrdViewChequedate.Rows) { if (Convert.ToInt32(lblCid.Text.ToString()) == Convert.ToInt32(((Label)gv.FindControl("lblcqid")).Text)) { if (txtDepositDate.Text != "" && txtBankName.Text != "") { //ddate = Convert.ToDateTime(txtDepositDate.Text.ToString()); DateTime ddate; string date = txtDepositDate.Text.Split('/')[1] + "/" + txtDepositDate.Text.Split('/')[0] + "/" + txtDepositDate.Text.Split('/')[2]; ddate = Convert.ToDateTime(date); DateTime Cdate; Cdate = Convert.ToDateTime((((Label)gv.FindControl("lblChequeDate")).Text).ToString()); if (ddate < Cdate) { MessageBox("Cheque date should be greater than deposited date "); } else { Cheque_CashDetails chk = new Cheque_CashDetails(); chk.CQ_ID = Convert.ToInt32(((Label)gv.FindControl("lblcqid")).Text); //chk.EmpID = (((Label)gv.FindControl("lblEmpId")).Text); //chk.CustId = (((Label)gv.FindControl("lblcustid")).Text); chk.EmpID = (((Label)gv.FindControl("lblEmpCode1")).Text); chk.CustId = (((Label)gv.FindControl("lblCustCode1")).Text); chk.ReciptNo = Convert.ToInt32(((Label)gv.FindControl("lblrec")).Text); // lblReceiptNo123.Text = chk.Deposite_Type = (((Label)gv.FindControl("lbldepositType")).Text); chk.ChequeDate = (((Label)gv.FindControl("lblChequeDate")).Text); chk.ChequeNo = (((Label)gv.FindControl("lblChequeNo")).Text); chk.Amount = Convert.ToDecimal(((Label)gv.FindControl("lblAmount")).Text); chk.CreatedBy = ((Label)gv.FindControl("lblcreatedby")).Text; //chk.BankCode = ((Label)lnkUpdate.Parent.FindControl("lblBankCode")).Text; chk.Payee_Bank = ((Label)gv.FindControl("lblPayee_Bank")).Text; ///////////ledger entry///////// Ledgerdetails ldpay = new Ledgerdetails(); ldpay.Amount = Convert.ToDecimal(((Label)gv.FindControl("lblAmount")).Text); ldpay.CustId = ((Label)gv.FindControl("lblcustid")).Text; ldpay.OtherId = ((Label)gv.FindControl("lblcqid")).Text; ldpay.FY = Convert.ToInt32(strFY); //////////end///////////// foreach (GridViewRow gv1 in gvLegder.Rows) { if ((((CheckBox)gv1.FindControl("chkclose")).Checked) == true) { // ///////////Payment pending /////////// // ReceivedAmt = ReceivedAmt + Convert.ToDecimal(((TextBox)gv1.FindControl("txtreceivable")).Text); //Convert.ToDecimal(ReceivedAmt); //} // ReceivedAmt = Convert.ToDecimal(((TextBox)gv1.FindControl("txtreceivable")).Text); /////////////Reused code//////////// // Ledgerdetails ldpay = new Ledgerdetails(); //ldpay.Amount = Convert.ToDecimal(((Label)gv.FindControl("lblAmount")).Text); // ldpay.CustId = ((Label)gv.FindControl("lblcustid")).Text; // ldpay.OtherId = ((Label)gv.FindControl("lblcqid")).Text; // ldpay.update(); ///////////end//////////////// Receivable = Convert.ToDecimal(((TextBox)gv1.FindControl("txtreceivable")).Text); LedgerPaymentdetails ld = new LedgerPaymentdetails(); ld.Autoid = Convert.ToInt32("0"); ld.CQ_ID = Convert.ToInt32(lblCid.Text.Trim()); ld.InvoiceNo = Convert.ToDecimal(((Label)gv1.FindControl("lblotherId")).Text); ld.debitAmount = Convert.ToDecimal(((Label)gv1.FindControl("lblDebitAmount")).Text); ld.ReceiptAmount = Convert.ToDecimal(((TextBox)gv1.FindControl("txtreceivable")).Text); ld.ReceiptNo = Convert.ToInt32(((Label)gv.FindControl("lblrec")).Text); if (Receivable > 0) { ld.save(); } } // message("Record Saved Successfully"); // Response.Redirect(Request.RawUrl.Replace("/Website/", "").ToString()); } //chk.BankID = Convert.ToInt32(((Label)lnkUpdate.Parent.FindControl("lblBankID")).Text); if (txtDepositDate.Text == "") { ChequeDate2 = ""; } else { ChequeDate2 = txtDepositDate.Text.Split('/')[0] + "/" + txtDepositDate.Text.Split('/')[1] + "/" + txtDepositDate.Text.Split('/')[2]; chk.DepositDate = ChequeDate2; if (((Label)gv.FindControl("lblChequeNo")).Text == "") { string BankCode = txtBankName.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(BankCode, "Bank").Tables[0]; if (dt.Rows.Count != 0) { txtBankName.Text = BankCode; //lblbank.Text = Convert.ToString(dt.Rows[0]["BankName"]); chk.BankCode = txtBankName.Text.ToString().Split(':')[0].Trim(); chk.Description = txtRemark.Text.Trim().ToString(); chk.ISactive = true; chk.FinancialYear = Convert.ToInt32(strFY); chk.Save(1); ldpay.update(1); // ld.save(); message("Record Saved Successfully"); bindData(); pnlothertext.Visible = true; check = "save"; Response.Redirect(Request.RawUrl.Replace("/Website/", "").ToString()); } else { chk.BankCode = txtBankName.Text.ToString().Split(':')[0].Trim(); chk.Description = txtRemark.Text.Trim().ToString(); chk.ISactive = true; chk.FinancialYear = Convert.ToInt32(strFY); chk.Save(1); ldpay.update(1); // ld.save(); message("Record Saved Successfully"); bindData(); check = "save"; pnlothertext.Visible = true; Response.Redirect(Request.RawUrl.Replace("/Website/", "").ToString()); } } else { string BankCode = txtBankName.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(BankCode, "Bank").Tables[0]; if (dt.Rows.Count != 0) { txtBankName.Text = BankCode; //lblbank.Text = Convert.ToString(dt.Rows[0]["BankName"]); chk.BankCode = txtBankName.Text.ToString().Split(':')[0].Trim(); chk.Description = txtRemark.Text.Trim().ToString(); chk.ISactive = true; chk.FinancialYear = Convert.ToInt32(strFY); chk.Save(1); ldpay.update(1); // ld.save(); message("Record Saved Successfully"); bindData(); check = "save"; pnlothertext.Visible = true; Response.Redirect(Request.RawUrl.Replace("/Website/", "").ToString()); } else { message("No such Bank code"); txtBankName.Focus(); txtBankName.Text = ""; } } } // } } } else { message("Kindly enter BankName,Date details"); } } } } catch { } }
protected void txtAccode_TextChanged(object sender, EventArgs e) { try { lblPhone.Text = ""; string Accode = txtAccode.Text.ToString().Split(':')[0].Trim(); string flag = txtAccode.Text.ToString().Split(':', '[', ']')[3].Trim(); DataTable dt1 = new DataTable(); dt1 = DCMaster.Get_Name(Accode, flag).Tables[0]; if (dt1.Rows.Count != 0) { if (flag == "AC") { txtAccode.Text = Accode; lblaccname.Text = Convert.ToString(dt1.Rows[0]["AC_NAME"]); //Added by Nilesh becuase its taking too much time to bring amount for this particular code if (Accode != "c0101") { lbllimit.Visible = false; lbldislimit.Visible = false; lblCustOS.Visible = true; lblCustOS.Text = Convert.ToString(DCMaster.Get_Name(Accode, flag).Tables[1].Rows[0]["Closin_Bal"]); } else { lblCustOS.Visible = true; lblCustOS.Text = "-"; } txtperson.Focus(); } else if (flag == "Cust") { txtAccode.Text = Accode; lblaccname.Text = Convert.ToString(dt1.Rows[0]["CustName"]); lblCustOS.Visible = true; lblCustOS.Text = Convert.ToString(DCMaster.Get_Name(Accode, flag).Tables[1].Rows[0]["Closin_Bal"]); DataSet ds = DCMaster.Get_Name(Accode, "Cust"); lblPhone.Text = ds.Tables[0].Rows[0]["Phone1"].ToString(); lblsplitdc.Text = ds.Tables[0].Rows[0]["isSplit"].ToString(); if (Convert.ToBoolean(lblsplitdc.Text) == true) { lbllimit.Visible = true; lbldislimit.Visible = true; lbllimit.Text = ds.Tables[0].Rows[0]["limit"].ToString(); lblsplitdc.Text = ds.Tables[0].Rows[0]["isSplit"].ToString(); } txtperson.Focus(); } } else { lblaccname.Text = "No such Account code"; txtAccode.Focus(); txtAccode.Text = ""; } } catch (Exception) { lblaccname.Text = "No such Account code"; txtAccode.Focus(); txtAccode.Text = ""; lblaccname.Text = ""; lblCustOS.Text = ""; } }
protected void BtnGetOrderDetails_Click(object sender, EventArgs e) { Session["tempBookData"] = null; if (txtdocno.Text == "") { message("Please enter Document no."); ClearData(); } else { int DocNum = Convert.ToInt32(txtdocno.Text.ToString()); DataTable dt = new DataTable(); bool condition1 = false; bool condition2 = false; dt = DCMaster.Get_DCMasterBy_DocNum(DocNum, "CancelDC", Convert.ToInt32(strFY)).Tables[0]; // dt = DCDetails.Idv_Get_DCDetails_By_DocNo(DocNum, "Canceled").Tables[0]; if (dt.Rows.Count > 0) { // condition1 = Convert.ToBoolean(dt.Rows[0]["IsConfirm"]); condition2 = Convert.ToBoolean(dt.Rows[0]["IsCanceled"]); Pflag = Convert.ToBoolean(dt.Rows[0]["IsPartialConfirmed"]); } if (condition2 == true) { // dt = DCDetails.Idv_Get_DCDetails_By_DocNo(DocNum, "Canceled").Tables[0]; grdOrderDetails.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(DocNum, "Canceled", Convert.ToInt32(strFY)).Tables[0]; grdOrderDetails.DataBind(); grdOrderDetails.Visible = true; //btncancel.Visible = false; PnlCancel(false); } else { // dt = DCDetails.Idv_Get_DCDetails_By_DocNo(DocNum, "notCanceled").Tables[0]; grdOrderDetails.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(DocNum, "notCanceled", Convert.ToInt32(strFY)).Tables[0]; grdOrderDetails.DataBind(); grdOrderDetails.Visible = true; //btncancel.Visible = true; PnlCancel(true); } //else if (dt.Rows.Count == 0) //{ // message("Record not found for document no. " + txtdocno.Text); // btncancel.Visible = false; // txtdocno.Text = ""; // txtdocno.Focus(); // ClearData(); //} // else if (dt.Rows.Count > 0) { Orderdetails.Visible = true; tabledetails.Visible = true; lbldocumentno.Text = dt.Rows[0]["DocumentNo"].ToString(); lblchalanno.Text = dt.Rows[0]["ChallanNo"].ToString(); lblchaldate.Text = dt.Rows[0]["ChallanDate"].ToString(); lblorderno.Text = dt.Rows[0]["OrderNo"].ToString(); //txtsalemanCode.Text = dt.Rows[0]["SalesmanCode"].ToString(); lblsalesman.Text = dt.Rows[0]["SalesmanName"].ToString(); lblcanceldate.Text = dt.Rows[0]["CanceledDate"].ToString(); lbldocdate.Text = dt.Rows[0]["DocumentDate"].ToString(); lblCustomer.Text = dt.Rows[0]["CustName"].ToString(); lblremarked.Text = dt.Rows[0]["CanceledRemark"].ToString(); // lblPersonIncharge.Text = dt.Rows[0]["PIncharge"].ToString(); // lblSpInstruction.Text = dt.Rows[0]["SpInstruction"].ToString(); // lblTransporter.Text = dt.Rows[0]["TransporterCode"].ToString(); // lblBankThrough.Text = dt.Rows[0]["BankName"].ToString(); } } }
protected void btnGetData_Click(object sender, EventArgs e) { allVisible(); string CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim(); DataSet ds = new DataSet(); ds = DCMaster.Get_Name(CustCode, "Customer!" + Session["FY"].ToString()); DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); dt = ds.Tables[0]; dt1 = ds.Tables[1]; //CustomerTod Table DataTable dtAssorted = ds.Tables[2]; //Customer Assorted Discount if (dt.Rows.Count != 0) { txtcustomer.Text = CustCode; lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]); grdCustDetails.DataSource = BindGvCustDetail(CustCode); grdCustDetails.DataBind(); if (dtAssorted.Rows.Count > 0) { AssortedPanel.Visible = true; GridAssorted.DataSource = dtAssorted; GridAssorted.DataBind(); } else { GridAssorted.DataSource = dtAssorted; GridAssorted.DataBind(); } if (dt1.Rows.Count > 0) { PanelTod.Visible = true; TODGridview.DataSource = dt1; TODGridview.DataBind(); } else { TODGridview.DataSource = dt1; TODGridview.DataBind(); } if (grdCustDetails.Rows.Count > 0) { FillForm(); } if (ChkBlacklist.Checked == true) { lblblkremark.Visible = true; LblblkDate.Visible = true; TxtblkRemark.Visible = true; TxtblkDate.Visible = true; } else { lblblkremark.Visible = false; LblblkDate.Visible = false; TxtblkRemark.Visible = false; TxtblkDate.Visible = false; } } else { lblCustName.Text = "No such Customer code"; txtcustomer.Focus(); txtcustomer.Text = ""; grdCustDetails.DataSource = null; grdCustDetails.DataBind(); } }
protected void RepDetailsConfirm_ItemCommand(object source, RepeaterCommandEventArgs e) { if (Session["saved"] == null) { Session["saved"] = "s"; } if (Session["saved"].ToString() != e.CommandArgument.ToString().Trim()) { //if (e.CommandName == "AddToCart") { bool Auth = DCMaster.Get_DocumentNum_Authentication(Convert.ToInt32(txtDocno.Text), Convert.ToInt32(strFY)); if (Auth) { MessageBox("Document no is not available"); txtDocno.Focus(); } else { DCConfirmQtyDetails _objDCConfirmQtyDetails = new DCConfirmQtyDetails(); DCMaster _objDCMaster = new DCMaster(); DCConfirmQtyDetails _objDCFT = new DCConfirmQtyDetails(); ActualInvoiceDetails _objactualinvoice = new ActualInvoiceDetails(); try { #region ActulInvoice Repeater objrep = (Repeater)this.FindControl("RepDetailsConfirm"); GridView objgrid = (GridView)objrep.Items[e.Item.ItemIndex].FindControl("grdapproval"); foreach (GridViewRow row in objgrid.Rows) { _objactualinvoice.DocumentNo = Convert.ToInt32(txtDocno.Text); _objactualinvoice.SubDocId = Convert.ToDecimal(e.CommandArgument.ToString().Trim()); _objactualinvoice.BookCode = ((Label)row.FindControl("lblbookC")).Text; _objactualinvoice.BookName = ((Label)row.FindControl("lblbookN")).Text; _objactualinvoice.Standard = ((Label)row.FindControl("lblStandard")).Text; _objactualinvoice.Medium = ((Label)row.FindControl("lblMedium")).Text; _objactualinvoice.Rate = Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text); _objactualinvoice.Quantity = Convert.ToInt32(((Label)row.FindControl("lblAqty")).Text); _objactualinvoice.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtdiscount")).Text); _objactualinvoice.Amount = Convert.ToInt32(((Label)row.FindControl("lblAqty")).Text) * (Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text) - (Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text) * Convert.ToDecimal(((TextBox)row.FindControl("txtdiscount")).Text) / 100)); _objactualinvoice.Freight = Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text); _objactualinvoice.Tax = Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objactualinvoice.Transporter = (((TextBox)e.Item.FindControl("lbltransporter")).Text); _objactualinvoice.LRNo = (((TextBox)e.Item.FindControl("txtlrno")).Text); _objactualinvoice.TotalAmount = Convert.ToDecimal(getTotalValues(objgrid).ToString()) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objactualinvoice.Bundles = (((TextBox)e.Item.FindControl("txtbundles")).Text); _objactualinvoice.CreatedBy = Convert.ToString(Session["UserName"]); _objactualinvoice.FinancialYearFrom = strFY; TextBox txtIdate1 = ((TextBox)e.Item.FindControl("txtdateabc")); TextBox txtLrdate1 = ((TextBox)e.Item.FindControl("txtlrdate")); _objactualinvoice.IsActive = true; _objactualinvoice.IsDeleted = false; string date1; string lrdate; if (txtIdate1.Text == "") { date1 = "1/1/2001"; } else { date1 = txtIdate1.Text.Split('/')[2] + "/" + txtIdate1.Text.Split('/')[1] + "/" + txtIdate1.Text.Split('/')[0]; } if (txtLrdate1.Text == "") { lrdate = "1/1/2001"; } else { lrdate = txtLrdate1.Text.Split('/')[2] + "/" + txtLrdate1.Text.Split('/')[1] + "/" + txtLrdate1.Text.Split('/')[0]; } _objactualinvoice.InvoiceDate = Convert.ToDateTime(date1); _objactualinvoice.LRDate = Convert.ToDateTime(lrdate); _objactualinvoice.Remark1 = ""; _objactualinvoice.Remark2 = ""; _objactualinvoice.Remark3 = ""; _objactualinvoice.SaveActual_InvoiceDetails(1); // (TextBox)e.Item.FindControl("txtfrieght"); } #endregion #region InvoiceCreate decimal subconfirmdoc = Convert.ToDecimal(e.CommandArgument.ToString().Trim()); _objDCConfirmQtyDetails.IsCreateInvoice = true; _objDCConfirmQtyDetails.CreatedInvoiceBy = Convert.ToString(Session["UserName"]); _objDCConfirmQtyDetails.SubDocNo = subconfirmdoc; // For financial year _objDCConfirmQtyDetails.AvailableQty = Convert.ToInt32(strFY); _objDCMaster.DocNo = Convert.ToInt32(txtDocno.Text); // Save Freight and tax Details frieght = Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text); tax = Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); temp = Convert.ToDecimal(tamount.Text) + frieght + tax; totalamount = Convert.ToDecimal(tamount.Text); _objDCFT.DocumentNo = Convert.ToInt32(txtDocno.Text); _objDCFT.SubDocNo = subconfirmdoc; _objDCFT.Freight = Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text); _objDCFT.Tax = Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); decimal TotalAmt = Convert.ToDecimal(getTotalValues(objgrid).ToString()) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objDCFT.TotalAmount = Convert.ToDecimal(getTotalValues(objgrid).ToString()) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txtfrieght")).Text) + Convert.ToDecimal(((TextBox)e.Item.FindControl("txttax")).Text); _objDCFT.LRNo = (((TextBox)e.Item.FindControl("txtlrno")).Text); TextBox txtIdate = ((TextBox)e.Item.FindControl("txtdateabc")); string date; if (txtIdate.Text == "") { date = "1/1/2001"; } else { date = txtIdate.Text.Split('/')[2] + "/" + txtIdate.Text.Split('/')[1] + "/" + txtIdate.Text.Split('/')[0]; } _objDCFT.InvoiceDate = Convert.ToDateTime(date); _objDCFT.AvailableQty = Convert.ToInt32(strFY); _objDCFT.Save_FrightTax_Details(1); _objDCConfirmQtyDetails.SaveConfirmDetails(1); stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); // stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed", Convert.ToInt32(strFY)); //if (ViewState["staticDS"] != null) //{ // stDS = (DataSet)ViewState["staticDS"]; //} //else //{ stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed", Convert.ToInt32(strFY)); //} RepDetailsConfirm.DataSource = stDS.Tables[0]; RepDetailsConfirm.DataBind(); #endregion MessageBox("Invoice created successfully " + subconfirmdoc); lblmessage.InnerHtml = "Last confirm doc no. : " + subconfirmdoc; if (Rptrpending.Items.Count == 1) { Rptrpending.DataSource = DCMaster.Get_ApprovedDocNo(Convert.ToInt32(strFY)); Rptrpending.DataBind(); //updateapprove.Update(); } if (RepDetailsConfirm.Items.Count == 0) { Rptrpending.DataSource = DCMaster.Get_ApprovedDocNo(Convert.ToInt32(strFY)); Rptrpending.DataBind(); upDocNo.Update(); docno.InnerHtml = ""; lblcustname.InnerHtml = ""; lblempname1.InnerHtml = ""; //updateapprove.Update(); } if (SMSSend.Text.ToUpper() == "YES") { sendMsg(lblMobNo.Text.Trim(), subconfirmdoc.ToString(), string.Format("{0:0.00}", TotalAmt).ToString(), (((TextBox)e.Item.FindControl("lbltransporter")).Text), (((TextBox)e.Item.FindControl("txtlrno")).Text), (((TextBox)e.Item.FindControl("txtbundles")).Text), txtIdate.Text.Trim()); //sendZoalMsg(((Label)e.Item.FindControl("lblCustId1")).Text, lblcustname.InnerHtml.Trim(), lblMobNo.Text.Trim(), subconfirmdoc.ToString(), string.Format("{0:0.00}", TotalAmt).ToString(), // (((TextBox)e.Item.FindControl("lbltransporter")).Text), // (((TextBox)e.Item.FindControl("txtlrno")).Text), // (((TextBox)e.Item.FindControl("txtbundles")).Text), // txtIdate.Text.Trim()); } //lblempname1.InnerHtml = ""; //lblcustname.InnerHtml = ""; // docno.InnerHtml = "" ; } catch (SqlException ex) { Response.Write(ex.Message.ToString()); } catch (Exception ex1) { Response.Write(ex1.Message.ToString()); } } } } ViewState["staticDS"] = null; Session["saved"] = e.CommandArgument.ToString().Trim(); updategenerate.Update(); }
public DataTable fillTempBookData(string bookcode, string flag) { DataTable dt = new DataTable(); DataTable tempGetData = new DataTable(); DataColumn colTax = new DataColumn(); colTax.DataType = System.Type.GetType("System.String"); colTax.ColumnName = "Rate"; DataColumn Discount = new DataColumn(); Discount.DataType = System.Type.GetType("System.String"); Discount.ColumnName = "Discount"; DataColumn AdditionalDiscount = new DataColumn(); AdditionalDiscount.DataType = System.Type.GetType("System.String"); AdditionalDiscount.ColumnName = "AdditionalDiscount"; DataColumn Amount = new DataColumn(); Amount.DataType = System.Type.GetType("System.String"); Amount.ColumnName = "Amount"; if (Session["tempDCData"] == null) { //CREATE NEW DATATABLE //ADD COLUMNS IN DATATABLE dt.Columns.Add("DCDetailID"); dt.Columns.Add("BookCode"); dt.Columns.Add("BookName"); //dt.Columns.Add("BookType"); dt.Columns.Add("Standard"); dt.Columns.Add("Medium"); // dt.Columns.Add("Quantity"); dt.Columns.Add("ReturnQty"); // dt.Columns.Add("DefectQty"); dt.Columns.Add("RemainQty"); dt.Columns.Add(colTax); dt.Columns.Add(Amount); dt.Columns.Add(Discount); dt.Columns.Add(AdditionalDiscount); dt.Columns.Add("Comment"); //ADD DATA AS PER COLUMNS //Books _objBooks = new Books(); } else { dt = (DataTable)Session["tempDCData"]; } tempGetData = Books.Get_BooksMasterForDC(bookcode, srate).Tables[0]; foreach (DataRow row in tempGetData.Rows) { price = row["SellingPrice"].ToString(); if (price == "") { price = "0"; } amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); if (dt.Rows.Count != 0) { DataView dv = new DataView(dt); dv.RowFilter = "BookCode = '" + row["BookCode"].ToString() + "'"; int i = 0; price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); foreach (DataRowView row1 in dv) { i++; } if (i == 0) { DataSet ds = DCMaster.Get_Discount_On_CusomerAND_Booktype(txtcustomer.Text.ToString(), row["BookCode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { discount = Convert.ToDecimal(ds.Tables[0].Rows[0][0]); Adddiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][1]); Tdiscount = amt * (discount / 100); amt = amt - Tdiscount; } dt.Rows.Add(dcid, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), rqty, Qty, String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:0.00}", Convert.ToDecimal(amt)), String.Format("{0:0.00}", Convert.ToDecimal(discount)), String.Format("{0:0.00}", Convert.ToDecimal(Adddiscount)), ""); } } else { DataSet ds = DCMaster.Get_Discount_On_CusomerAND_Booktype(txtcustomer.Text.ToString(), row["BookCode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { discount = Convert.ToDecimal(ds.Tables[0].Rows[0][0]); Adddiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][1]); // Totaldiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][2]); Tdiscount = amt * (discount / 100); amt = amt - Tdiscount; } dt.Rows.Add(dcid, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), rqty, Qty, String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:0.00}", Convert.ToDecimal(amt)), String.Format("{0:0.00}", Convert.ToDecimal(discount)), String.Format("{0:0.00}", Convert.ToDecimal(Adddiscount)), ""); } } return(dt); }
public void fillReport() { 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!" + Convert.ToInt32(Session["FY"])).Tables[0]; IsCustomer = true; } else { IsCustomer = false; } } //= Convert.ToString(dt.Rows[0]["CustName"]); txtcustomerid.Focus(); DataSet ds = new DataSet(); if (txtFromDate.Text.Split('/').Length > 1 && txttoDate.Text.Split('/').Length > 1) { try { 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 = AccountLeadgerDetails.Get_Trial_Balance_Individual(CustCode.ToString().Split(':')[0].Trim(), IsCustomer, Convert.ToDateTime(FROMdate), Convert.ToDateTime(tOdate)); } catch (Exception ex) { lblCustName.Text = "Date is incorrect"; txtcustomerid.Text = ""; txtFromDate.Text = ""; txttoDate.Text = ""; totAlAmt1.Visible = false; totAlAmt.Visible = false; // gvLedger.DataSource = null; // gvLedger.DataBind(); } } if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("~/Report/AccountLedger.rpt")); rd.SetDataSource(ds.Tables[0]); rd.SetParameterValue("IsPrint", Convert.ToBoolean(IsPrint.Checked)); accountingledger.ReportSource = rd; // gvLedger.DataSource = ds; 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 { //gvLedger.DataSource = null; totAlAmt1.Visible = false; totAlAmt.Visible = false; MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; } //{ // lblCustName.Text = ""; // DataSet ds1 = new DataSet(); // ds1 = AccountLeadgerDetails.Get_Trial_Balance_Individual(CustCode, IsCustomer, Convert.ToDateTime(txtFromDate.Text.Trim()), Convert.ToDateTime(txttoDate.Text.Trim())); // gvLedger.DataSource = ds1; // gvLedger.DataBind(); //} } else { // gvLedger.DataSource = null; totAlAmt1.Visible = false; totAlAmt.Visible = false; MessageBox("No Records Found"); Button1.Visible = false; btnPrint.Visible = false; lbloutstndamt.Text = "0"; lblopbal1.Text = "0"; txtcustomerid.Focus(); } }