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();
}
}
