protected void BindGridview()
{
DataSet ds = new DataSet();
grdconfirm.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(id), "allbydocno", Convert.ToInt32(strFY)).Tables[0];
grdconfirm.DataBind();
}
protected void btnget_Click(object sender, EventArgs e)
{
try
{
lblmessage.InnerHtml = "";
pnlDetails.Visible = true;
docno.InnerHtml = txtdocno.Text.Trim();
// upDetails.Visible = true;
txtempc.Visible = true;
lblemp.Visible = true;
btnPrint.Visible = true;
txtremark.Visible = true;
DataSet ds6 = new DataSet();
//ds6 = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno");
ds6 = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno", Convert.ToInt32(strFY));
grdconfirm.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno", Convert.ToInt32(strFY)).Tables[0];
grdconfirm.DataBind();
// pnlDetails.Visible = true;
grdconfirm.Visible = true;
int id = Convert.ToInt32(ds6.Tables[1].Rows[0]["CustID"]);
lblempname1.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0]["FirstName"]) + " " + Convert.ToString(ds6.Tables[1].Rows[0]["LastName"]) + " ";
lblcustname.InnerHtml = " " + Convert.ToString(ds6.Tables[1].Rows[0]["CustName"]);
lblspinstruction.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["SpInstruction"]);
lbldcdate.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["DocumentDate"]);
lblorder.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["OrderDate"]);
ViewState["EmailID"] = Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]);
lblemailid.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]);
//strEmailID = Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]);
DataSet ds7 = G_GetPass.CustEMail_LocalEntry(id);
ViewState["SEmailid"] = Convert.ToString(ds7.Tables[0].Rows[0]["SEmailID"]);
if (Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]) == "")
{
lblEmailAlert.Visible = true;
lblEmailAlert.ForeColor = System.Drawing.Color.Red;
lblEmailAlert.Text = "Add email id";
btnEmail.Enabled = false;
}
else
{
lblEmailAlert.Visible = false;
btnEmail.Enabled = true;
}
string jv = "";
if (grdconfirm.Rows.Count <= 0)
{
btnconfirm.Visible = false;
jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='none';";
}
else
{
btnconfirm.Visible = true;
jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='visible';";
}
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true);
}
catch { }
txtempc.Focus();
}
public void bindReport()
{
if (Request.QueryString["d"] != null)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
dt = DCDetails.DC_Get_InvoiceDetails_On_subdocID(Convert.ToDecimal(Request.QueryString["sd"].ToString()), Convert.ToInt32(Request.QueryString["d"].ToString()));
dt1 = DCDetails.Rep_DC_Get_Datails_OnSubdocno(Convert.ToInt32(Request.QueryString["d"].ToString()));
// decimal Amount = Convert.ToDecimal(dt.Rows[0]["TotalAmount"]);
// DataSet ds1 = new DataSet();
// ds1 = ActualInvoiceDetails.GetConvertion_fromnumber(Amount);
// dv.
//objds.Tables.Add(dt);
// ds.Tables.Add(dt1.Tables[0]);
// DataView dv1 = new DataView();
// ds.Tables.Add(DCDetails.DC_Get_InvoiceDetails_On_subdocID(Convert.ToDecimal(Request.QueryString["sd"].ToString())).Tables[0]);
// ds.Tables.Add(DCDetails.Rep_DC_Get_Datails_OnSubdocno(Convert.ToInt32(Request.QueryString["d"].ToString())).Tables[0]);
// DataView dv1 = new DataView(ds1.Tables[0]);
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("../Report/PrintInvoice.rpt"));
rd.Database.Tables[0].SetDataSource(dt);
rd.Database.Tables[1].SetDataSource(dt1);
// rd.Database.Tables[2].SetDataSource(ds1.Tables[0]);
// rd.SetDataSource(dt);
// rd.SetDataSource(dt1);
// rd.SetParameterValue(1, Convert.ToDecimal(Request.QueryString["sd"].ToString()));
// rd.SetParameterValue(0,Convert.ToInt32(Request.QueryString["d"].ToString()));
CrptInvoice.ReportSource = rd;
CrptInvoice.DataBind();
}
}
public void BindPanel()
{
RdBValue = RdlView.SelectedValue.ToString();
if (RdBValue == "Customer")
{
BindCustomer();
Pnlcust.Visible = true;
// pnlDetails.Visible = false;
Rptrpending.Visible = true;
// Panel1.Visible = false;
upDocNo.Update();
RepDetailsConfirm.DataBind();
Rptrpending.DataBind();
}
if (RdBValue == "All")
{
Pnlcust.Visible = false;
// pnlDetails.Visible = false;
// Panel1.Visible = true;
Rptrpending.Visible = true;
Rptrpending.DataSource = DCDetails.Get_DC_Completed_IsApproved(Convert.ToInt32(strFY));
Rptrpending.DataBind();
upDocNo.Update();
RepDetailsConfirm.DataBind();
}
}
protected void grdBookDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DCDetails _objdcd = new DCDetails();
DCDid = Convert.ToInt32(((Label)grdBookDetails.Rows[e.RowIndex].FindControl("lblDCDetailID")).Text);
try
{
if (DCDid != 0)
{
_objdcd.DCDetailID = DCDid;
_objdcd.IsActive = false;
_objdcd.Amount = 0;
_objdcd.Rate = 0;
_objdcd.Discount = 0;
_objdcd.Save();
}
DataTable dt1 = new DataTable();
dt1 = (DataTable)Session["tempDCData"];
dt1.Rows[e.RowIndex].Delete();
grdBookDetails.DataSource = dt1;
grdBookDetails.DataBind();
Session["tempDCData"] = dt1;
loder("Successfully Deleted...");
}
catch
{
}
}
protected void btnPrint_Click1(object sender, EventArgs e)
{
Session["DATAREP"] = null;
string AllDock = "";
bool checkAll = false;
if (Rptrpending.Items[0].Selected == true)
{
checkAll = true;
}
for (int i = 1; i < Rptrpending.Items.Count; i++)
{
if (checkAll == true)
{
AllDock = AllDock + Rptrpending.Items[i].Value.ToString() + ",";
}
else if (Rptrpending.Items[i].Selected == true)
{
AllDock = AllDock + Rptrpending.Items[i].Value.ToString() + ",";
}
}
AllDock = AllDock + "0";
DataTable dt = new DataTable();
dt = DCDetails.DC_Get_InvoiceDetails_On_subdocID(0, AllDock, "");
Session["DATAREP"] = dt;
fillReport();
}
protected void RepDetailsConfirm_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
TextBox txtFright = null;
TextBox txttax = null;
Label lbltotalamt = null;
Label lbltotalAmtget = null;
txtFright = (TextBox)e.Item.FindControl("txtfrieght");
txttax = (TextBox)e.Item.FindControl("txttax");
lbltotalamt = (Label)e.Item.FindControl("lbltotalamt");
lbltotalAmtJS = (Label)e.Item.FindControl("lbltotalAmtJS");
Label SubConfirmID = (Label)e.Item.FindControl("SubConfirmID");
GridView grdView = (GridView)e.Item.FindControl("grdapproval");
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));
ViewState["staticDS"] = stDS;
}
DataView dv = new DataView(stDS.Tables[1]);
dv.RowFilter = "SubConfirmID = " + SubConfirmID.Text.Trim();
grdView.DataSource = dv;
grdView.DataBind();
int ID = Convert.ToInt32(stDS.Tables[2].Rows[0]["CustID"]);
lblempname1.InnerHtml = Convert.ToString(stDS.Tables[2].Rows[0]["FirstName"]) + " " + Convert.ToString(stDS.Tables[2].Rows[0]["LastName"]) + " ";
lblcustname.InnerHtml = " " + Convert.ToString(stDS.Tables[2].Rows[0]["CustDetails"]);
ViewState["cname"] = Convert.ToString(stDS.Tables[2].Rows[0]["CustDetails"]);
lblEmail.Text = Convert.ToString(stDS.Tables[2].Rows[0]["Email"]);
lblMobNo.Text = Convert.ToString(stDS.Tables[2].Rows[0]["mobNo"]);
((TextBox)e.Item.FindControl("txtdateabc")).Text = DateTime.Now.ToString("dd/MM/yyyy");
txtfrieght.Text = "0";
txttax.Text = "0";
((Label)e.Item.FindControl("LblRemark")).Text = stDS.Tables[2].Rows[0]["Remark"].ToString();
((Label)e.Item.FindControl("lblCustId1")).Text = stDS.Tables[2].Rows[0]["CustId"].ToString();
//Updated By Rupesh 17/10/2014
((TextBox)e.Item.FindControl("txtbundles")).Text = stDS.Tables[1].Rows[0]["Bundles"].ToString();
//
DataSet ds7 = G_GetPass.CustEMail_LocalEntry(ID);
ViewState["SEmailid"] = Convert.ToString(ds7.Tables[0].Rows[0]["SEmailID"]);
lbltotalamt.Text = tamount.Text.ToString();
if (stDS.Tables[2].Rows.Count > 0)
{
((TextBox)e.Item.FindControl("lbltransporter")).Text = stDS.Tables[2].Rows[0]["Transporter"].ToString();
}
lbltotalAmtJS.Text = tamount.Text.ToString();
txtfrieght.Attributes.Add("onkeyup", "sumCharges('" + txtfrieght.ClientID + "','" + txttax.ClientID + "','" + lbltotalAmtJS.ClientID + "','" + lbltotalamt.ClientID + "')");
txttax.Attributes.Add("onkeyup", "sumCharges('" + txtfrieght.ClientID + "','" + txttax.ClientID + "','" + lbltotalAmtJS.ClientID + "','" + lbltotalamt.ClientID + "')");
}
protected void btncancel_Click(object sender, EventArgs e)
{
try
{
DCMaster _objDC = new DCMaster();
DCDetails _objdetails = new DCDetails();
if (Pflag == true)
{
if (lbldocumentno.Text != "")
{
foreach (GridViewRow row in grdOrderDetails.Rows)
{
_objdetails.DCDetailID = Convert.ToInt32(((Label)row.FindControl("lbldcdetailid")).Text);
_objdetails.CanceledQty = Convert.ToInt32(((Label)row.FindControl("lblavailable")).Text);
_objdetails.Cancel = false;
_objdetails.PCancel = true;
_objdetails.UpdateDCDetails();
}
_objDC.DocNo = Convert.ToInt32(lbldocumentno.Text.ToString());
_objDC.IsCanceled = true;
_objDC.FinancialYearFrom = Convert.ToInt32(strFY);
_objDC.Remark = txtRemark.Text.ToString();
_objDC.update(1);
tabledetails.Visible = false;
}
// message("Is Partial True");
}
else
{
// message("Is Partial False");
if (lbldocumentno.Text != "")
{
foreach (GridViewRow row in grdOrderDetails.Rows)
{
_objdetails.DCDetailID = Convert.ToInt32(((Label)row.FindControl("lbldcdetailid")).Text);
_objdetails.CanceledQty = Convert.ToInt32(((Label)row.FindControl("lblavailable")).Text);
_objdetails.Cancel = true;
_objdetails.PCancel = false;
_objdetails.UpdateDCDetails();
}
_objDC.DocNo = Convert.ToInt32(lbldocumentno.Text.ToString());
_objDC.IsCanceled = true;
_objDC.FinancialYearFrom = Convert.ToInt32(strFY);
_objDC.Remark = txtRemark.Text.ToString();
_objDC.update(1);
}
}
ClearData();
// btncancel.Visible = false;
PnlCancel(false);
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ChetanaCompanyName"] != "" || Session["ChetanaCompanyName"] != null)
{
if (Session["FY"] != "" || Session["FY"] != null)
{
strChetanaCompanyName = Session["ChetanaCompanyName"].ToString();
strFY = Session["FY"].ToString();
}
else
{
Session.Clear();
}
}
if (!Page.IsPostBack)
{
ViewState["cname"] = null;
SMSSend.Text = "NO";
if (ConfigurationManager.AppSettings["SMS_INV_SEND"] != null)
{
SMSSend.Text = ConfigurationManager.AppSettings["SMS_INV_SEND"].ToString();
}
Session["saved"] = null;
docno.InnerHtml = "Not Selected";
if (Request.QueryString["c"] != null)
{
//Rptrpending.DataSource = DCMaster.Get_ApprovedDocNo(Convert.ToInt32(strFY));
DataView dv = new DataView(DCMaster.Get_ApprovedDocNo(Convert.ToInt32(strFY)).Tables[0]);
dv.RowFilter = "CustomerId = " + Request.QueryString["c"].ToString();
Rptrpending.DataSource = dv.ToTable();
Rptrpending.DataBind();
if (Request.QueryString["d"] != null)
{
try
{
stDS = new DataSet();
docno.InnerHtml = Request.QueryString["d"].ToString().Trim();
stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString()), "confirmed", Convert.ToInt32(strFY));
ViewState["staticDS"] = stDS;
RepDetailsConfirm.DataSource = stDS.Tables[0];
RepDetailsConfirm.DataBind();
lblmessage.InnerHtml = "";
}
catch (Exception ex)
{
}
}
}
}
}
protected void btnget_Click(object sender, EventArgs e)
{
stDS = new DataSet();
docno.InnerHtml = txtDocno.Text.Trim();
stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed", Convert.ToInt32(strFY));
ViewState["staticDS"] = stDS;
RepDetailsConfirm.DataSource = stDS.Tables[0];
RepDetailsConfirm.DataBind();
lblmessage.InnerHtml = "";
}
protected void btnget_Click(object sender, EventArgs e)
{
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();
lblmessage.InnerHtml = "";
//pnldetails.Visible = true;
// updategenerate.Update();
}
public void SaveDCDetails(int docNo)
{
DCDetails _objDCD = new DCDetails();
try
{
foreach (GridViewRow row in grdBookDetails.Rows)
{
_objDCD.DCDetailID = Convert.ToInt32(((Label)row.FindControl("lblDCDetailID")).Text);
_objDCD.DocumentNo = docNo;
_objDCD.BookCode = ((Label)row.FindControl("lblBookCode")).Text;
_objDCD.BookName = ((Label)row.FindControl("lblBookName")).Text;
_objDCD.Standard = ((Label)row.FindControl("lblStandard")).Text;
_objDCD.Medium = ((Label)row.FindControl("lblMedium")).Text;
Reqty = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text);
givqty = Convert.ToInt32(((Label)row.FindControl("lblgivedqty")).Text);
_objDCD.Quantity = Reqty + givqty;
// string DDate = ((TextBox)row.FindControl("txtDeldate")).Text;
// DDate = DDate.Split('/')[1] + "/" + DDate.Split('/')[0] + "/" + DDate.Split('/')[2];
string DDate = txtDeliverydte.Text.Split('/')[1] + "/" + txtDeliverydte.Text.Split('/')[0] + "/" + txtDeliverydte.Text.Split('/')[2];
_objDCD.DeliveryDate = Convert.ToDateTime(DDate);
_objDCD.Rate = Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text);
_objDCD.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtDiscount")).Text);
discount = Convert.ToDecimal(((TextBox)row.FindControl("txtDiscount")).Text);
amt = Convert.ToDecimal(((TextBox)row.FindControl("txtrate")).Text) * Reqty;
Tdiscount = amt * (discount / 100);
amt = amt - Tdiscount;
if (((Label)row.FindControl("lblAmt")).Text != "")
{
_objDCD.Amount = Convert.ToDecimal(amt);
}
else
{
_objDCD.Amount = 0;
}
//_objDCD.Publisher = ((Label)row.FindControl("lblPublisher")).Text;
_objDCD.CreatedBy = Convert.ToString(Session["UserName"]);
_objDCD.IsActive = true;
_objDCD.Save();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["d"] != null && Request.QueryString["sd"] != null)
{
DataSet ds = new DataSet();
ds = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), "approved");
DataView dv = new DataView(ds.Tables[1]);
dv.RowFilter = "SubConfirmID =" + Request.QueryString["sd"].ToString().Trim();
// DocumentNo.InnerHtml = ds.Tables[1].Rows[0]["DocumentNo"].ToString();
orderno.InnerHtml = ds.Tables[2].Rows[0]["OrderNo"].ToString();
Todaydate.InnerHtml = DateTime.Now.ToString("dd/MM/yyyy");
Subconfirmid.InnerHtml = Request.QueryString["sd"].ToString();
custname.InnerHtml = ds.Tables[2].Rows[0]["CustName"].ToString() + ",";
custadd.InnerHtml = ds.Tables[2].Rows[0]["Address"].ToString().Replace(",", ",<br/>") + " </br> "
+ ds.Tables[2].Rows[0]["City"].ToString() + ", " + ds.Tables[2].Rows[0]["State1"].ToString();
spnaddress.InnerHtml = ds.Tables[2].Rows[0]["Zip"].ToString();
lblpersonincharge.InnerHtml = ds.Tables[2].Rows[0]["PIncharge"].ToString();
// lbldate.InnerHtml = ds.Tables[2].Rows[0]["PIncharge"].ToString() ;
LBLBUNDLES.InnerHtml = ds.Tables[1].Rows[0]["Bundles"].ToString();
lbltransporter.InnerHtml = ds.Tables[1].Rows[0]["Transporter"].ToString();
lrno.InnerHtml = ds.Tables[1].Rows[0]["LRNo"].ToString();
grdapproval.DataSource = dv;
grdapproval.DataBind();
DataView dv1 = new DataView(ds.Tables[3]);
dv1.RowFilter = "SubConfirmID = " + Request.QueryString["sd"].ToString().Trim();
if (dv1.Count > 0)
{
lblfreight.InnerHtml = dv1[0].Row["Freight"].ToString();
lbltax.InnerHtml = dv1[0].Row["Tax"].ToString();
decimal frt = Convert.ToDecimal(dv1[0].Row["Freight"].ToString());
decimal tx = Convert.ToDecimal(dv1[0].Row["Tax"].ToString());
tamt = frt + tx + totalamount;
Lbltotalamt.InnerHtml = tamt.ToString();
}
else
{
lblfreight.InnerHtml = "0";
lbltax.InnerHtml = "0";
Lbltotalamt.InnerHtml = totalamount.ToString();
}
DataSet ds1 = new DataSet();
ds1 = ActualInvoiceDetails.GetConvertion_fromnumber(tamt);
lblrupees.InnerHtml = ds1.Tables[0].Rows[0][0].ToString() + " Only";
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
string strinvno = "";
foreach (GridViewRow row in grdinvDetails.Rows)
{
strinvno = strinvno + ((Label)row.FindControl("lblInvoiceNo")).Text.Trim() + ",";
}
DataTable dt = new DataTable();
dt = DCDetails.DC_Get_InvoiceDetails_On_subdocID(Convert.ToDecimal(strFY), strinvno, Convert.ToString(Session["UserName"]));
Session["DATAREPInv"] = dt;
fillReport();
}
protected void RdlView_SelectedIndexChanged(object sender, EventArgs e)
{
RdBValue = RdlView.SelectedValue.ToString();
if (RdBValue == "Customer")
{
BindCustomer();
Pnldate.Visible = false;
// pnlcity.Visible = false;
Pnlcust.Visible = true;
pnlDetails.Visible = false;
Panelrepeater.Visible = false;
Rptrpending.Visible = true;
// updateapprove.Update();
// pnlconfirm.Visible = false;
// DDLCustomer.Items.Insert(0, new ListItem("- Select Customer-", "0"));
}
if (RdBValue == "invoiceDate")
{
Pnldate.Visible = true;
// pnlcity.Visible = false;
Pnlcust.Visible = false;
pnlDetails.Visible = false;
Rptrpending.Visible = true;
Panelrepeater.Visible = false;
//updateapprove.Update();
// pnlconfirm.Visible = false;
}
if (RdBValue == "All")
{
Pnldate.Visible = false;
// pnlcity.Visible = false;
Pnlcust.Visible = false;
Rptrpending.Visible = true;
Panelrepeater.Visible = true;
Rptrpending.DataSource = DCDetails.Get_DC_Completed_IsApproved(Convert.ToInt32(strFY));
Rptrpending.DataBind();
Rptrpending.Items.Insert(0, new ListItem("All", "0"));
//updateapprove.Update();
// Bind_DDL_SuperZone();
// pnlconfirm.Visible = true;
pnlDetails.Visible = false;
}
}
protected void grdapproval_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Repeater objrep = ((Repeater)this.FindControl("RepDetailsConfirm"));
// RepeaterCommandEventArgs s = (RepeaterCommandEventArgs)(e);
// decimal subdoc = Convert.ToDecimal((s.CommandArgument.ToString().Trim()));
GridView objgrid1 = (GridView)(sender);
ActualInvoiceDetails _objinvoice = new ActualInvoiceDetails();
invoiceId = Convert.ToInt32(((Label)objgrid1.Rows[e.RowIndex].FindControl("lblgenerateinvoiceid")).Text);
try
{
if (invoiceId != 0)
{
_objinvoice.GanerateinvoiceId = invoiceId;
_objinvoice.IsActive = false;
_objinvoice.IsDeleted = true;
_objinvoice.SubDocId = Convert.ToDecimal(((Label)objgrid1.Parent.FindControl("SubConfirmID")).Text);
decimal amt1 = Convert.ToDecimal(((Label)objgrid1.Rows[e.RowIndex].FindControl("lblamt")).Text);
decimal amount1 = Convert.ToDecimal(((Label)objgrid1.Parent.FindControl("lblallTotalamt")).Text);
decimal tamount1 = amount1 - amt1;
_objinvoice.TotalAmount = tamount1;
_objinvoice.FinancialYearFrom = strFY.ToString();
if (objgrid1.Rows.Count == 1)
{
_objinvoice.flag = "DeleteInvoice" + "!" + Session["UserName"].ToString();
}
else
{
_objinvoice.flag = "invoice";
}
_objinvoice.DeleteActual_InvoiceDetails(1);
}
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
{
}
}
protected void btnget_Click(object sender, EventArgs e)
{
stDS = new DataSet();
docno.InnerHtml = txtDocno.Text.Trim();
stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed", Convert.ToInt32(strFY));
ViewState["staticDS"] = stDS;
RepDetailsConfirm.DataSource = stDS.Tables[0];
RepDetailsConfirm.DataBind();
lblmessage.InnerHtml = "";
// ((TextBox)((Button)(sender)).Parent.FindControl("txtfrieght")).Text = "0";
// ((TextBox)((Button)(sender)).Parent.FindControl("txttax")).Text = "0";
// ((Label)((Button)(sender)).Parent.FindControl("lbltotalamt")).Text = tamount.ToString();
// ((TextBox)RepDetailsConfirm.FindControl("txtfrieght")).Text = "0";
// RepDetailsConfirm.F
//(Label)e.Row.Parent.Parent.Parent.FindControl("lbltotalAmtget");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["d"] != null)
{
DataSet ds = new DataSet();
ds = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), "allbydocno", Convert.ToInt32(Request.QueryString["sd"].ToString().Trim()));
DataView dv = new DataView(ds.Tables[0]);
DocumentNo.InnerHtml = ds.Tables[0].Rows[0]["DocumentNo"].ToString();
Todaydate.InnerHtml = DateTime.Now.ToString("dd MMM yyyy");
custname.InnerHtml = ds.Tables[1].Rows[0]["CustName1"].ToString();
spnaddress.InnerHtml = ds.Tables[1].Rows[0]["Address"].ToString();
spinstruction.InnerHtml = ds.Tables[1].Rows[0]["SpInstruction"].ToString();
State.InnerHtml = ds.Tables[1].Rows[0]["city"].ToString() + " , " + ds.Tables[1].Rows[0]["State"].ToString();
grdpending.DataSource = dv;
grdpending.DataBind();
// grdconfirm.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), "allbydocno").Tables[0];
// grdconfirm.DataBind();
}
}
protected void btnget_Click(object sender, EventArgs e)
{
try
{
lblmessage.InnerHtml = "";
pnlDetails.Visible = true;
docno.InnerHtml = txtdocno.Text.Trim();
// upDetails.Visible = true;
txtempc.Visible = true;
lblemp.Visible = true;
btnPrint.Visible = true;
txtremark.Visible = true;
DataSet ds6 = new DataSet();
//ds6 = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno");
ds6 = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno", Convert.ToInt32(strFY));
grdconfirm.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno", Convert.ToInt32(strFY)).Tables[0];
grdconfirm.DataBind();
// pnlDetails.Visible = true;
grdconfirm.Visible = true;
lblempname1.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0][0]) + " " + Convert.ToString(ds6.Tables[1].Rows[0][1]) + " ";
lblcustname.InnerHtml = " " + Convert.ToString(ds6.Tables[1].Rows[0][2]);
lblspinstruction.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["SpInstruction"]);
lbldcdate.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["DocumentDate"]);
lblorder.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["OrderDate"]);
string jv = "";
if (grdconfirm.Rows.Count <= 0)
{
btnconfirm.Visible = false;
jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='none';";
}
else
{
btnconfirm.Visible = true;
jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='visible';";
}
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true);
DDLCustomer.Focus();
}
catch { }
}
protected void img01_Click(object sender, ImageClickEventArgs e)
{
ImageButton img = (ImageButton)(sender);
if (img.CommandName.ToLower() == "p")
{
grdconfirm.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(img.CommandArgument.Trim()),
"helpdesk", Convert.ToInt32(0)).Tables[1];
grdconfirm.DataBind();
ModalPopUpDocNum.Show();
UpdatePanel7.Update();
}
else
{
stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(img.CommandArgument.Trim()), "helpdesk",
Convert.ToInt32(0));
RepDetailsApprove.DataSource = stDS.Tables[0];
RepDetailsApprove.DataBind();
ModalPopupExtender1.Show();
UpdatePanel8.Update();
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
string strinvno = "";
foreach (GridViewRow row in grdinvDetails.Rows)
{
if (strinvno == string.Empty)
{
strinvno = ((Label)row.FindControl("lblPendingDCNo")).Text.Trim();
}
else
{
strinvno = strinvno + "," + ((Label)row.FindControl("lblPendingDCNo")).Text.Trim();
}
}
DataTable dt = new DataTable();
dt = DCDetails.DC_Get_DCDetails_for_MultiPrint(Convert.ToInt32(strFY), strinvno);
Session["DATAREPPendingDC"] = dt;
fillReport();
}
public void bindReport()
{
if (Request.QueryString["d"] != null)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
dt = DCDetails.DC_Get_InvoiceDetails_On_subdocID(Convert.ToDecimal(Request.QueryString["sd"].ToString()), Convert.ToInt32(Request.QueryString["d"].ToString()));
dt1 = DCDetails.Rep_DC_Get_Datails_OnSubdocno(Convert.ToInt32(Request.QueryString["d"].ToString()));
ReportDocument rd = new ReportDocument();
if (Request.QueryString["type"] == "without")
{
rd.Load(Server.MapPath("../Report/PrintInvoiceWithoutDiscount.rpt"));
}
else if (Request.QueryString["type"] == "GST")
{
rd.Load(Server.MapPath("../Report/GSTInvoice.rpt"));
}
else
{
rd.Load(Server.MapPath("../Report/PrintInvoice.rpt"));
}
// rd.Load(Server.MapPath("../Report/PrintInvoice.rpt"));
rd.Database.Tables[0].SetDataSource(dt);
rd.Database.Tables[1].SetDataSource(dt1);
// rd.Database.Tables[2].SetDataSource(ds1.Tables[0]);
// rd.SetDataSource(dt);
// rd.SetDataSource(dt1);
// rd.SetParameterValue(1, Convert.ToDecimal(Request.QueryString["sd"].ToString()));
// rd.SetParameterValue(0,Convert.ToInt32(Request.QueryString["d"].ToString()));
CrptInvoice.ReportSource = rd;
CrptInvoice.DataBind();
}
}
protected void btnget_Click(object sender, EventArgs e)
{
stDS = new DataSet();
pnlDetails.Visible = true;
docno.InnerHtml = txtDocno.Text.Trim();
stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "approved", Convert.ToInt32(strFY));
RepDetailsApprove.DataSource = stDS.Tables[0];
RepDetailsApprove.DataBind();
// ((Label)((Button)(sender)).Parent.FindControl("lblfright")).Text = (stDS.Tables[1].Rows[0]["Freight"]).ToString();
// ((Label)((Button)(sender)).Parent.FindControl("lbltax")).Text = (stDS.Tables[1].Rows[0]["Tax"]).ToString();
// ((Label)((Button)(sender)).Parent.FindControl("lbltotalamt")).Text = (stDS.Tables[1].Rows[0]["TotalAmount"]).ToString();
string jv = "";
if (RepDetailsApprove.Items.Count <= 0)
{
jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_Print_Invoice1_btnapproval').style.display='none';";
}
else
{
jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_Print_Invoice1_btnapproval').style.display='block';";
}
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true);
}
protected void btnPrint_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 = "admin";
_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();
Rptrpending.Items.Insert(0, new ListItem("All", "0"));
((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() + "')", true);
}
catch (Exception ex)
{
MessageBox(ex.Message.ToString());
((Button)(sender)).Enabled = true;
}
//}
}
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();
}
}
}
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 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 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();
}
