protected void btnget_Click(object sender, EventArgs e) { lblviewCNNo.Text = txtCnno.Text.Trim(); CNNo = Convert.ToInt32(txtCnno.Text.Trim()); // Bindgrdcn(); //grdcn.DataSource = CreditNote.PrintCN(CNNo); //grdcn.DataBind(); DataSet grid = new DataSet(); grid = CreditNote.EditCN(Convert.ToInt32(strFY), CNNo); grdBookDetails.DataSource = grid; grdBookDetails.DataBind(); Session["tempDCData1"] = grid.Tables[0]; DataSet ds6 = new DataSet(); ds6 = CreditNote.PrintCN(Convert.ToInt32(strFY), CNNo); if (ds6.Tables[1].Rows.Count > 0) { txtCNDate.Text = ds6.Tables[1].Rows[0]["CNDate"].ToString(); lblCustN.Text = ds6.Tables[1].Rows[0]["CustName"].ToString(); lbledit.Text = Convert.ToInt32(ds6.Tables[1].Rows[0]["IsEdit"]).ToString(); txtGCN.Text = ds6.Tables[1].Rows[0]["GCN"].ToString(); txtSCN.Text = ds6.Tables[1].Rows[0]["SCN"].ToString(); txtlRNO.Text = ds6.Tables[1].Rows[0]["LrNo"].ToString(); lbltransporter.Text = ds6.Tables[1].Rows[0]["TransportName"].ToString(); lblflagdc.Text = ds6.Tables[1].Rows[0]["Flag"].ToString(); CustCode = ds6.Tables[1].Rows[0]["CustCode"].ToString(); if (ds6.Tables[1].Rows[0]["IsExciseApplicable"].ToString() == "1") { ISExcise.Checked = true; } else { ISExcise.Checked = false; } } if (lbledit.Text == "0") { btn_Save.Enabled = false; btn_Save.BorderColor = System.Drawing.Color.Red; btn_Save.ToolTip = "Record Editing Locked"; } else { btn_Save.BorderColor = System.Drawing.Color.Green; btn_Save.Enabled = true; btn_Save.ToolTip = ""; } btn_Save.Visible = true; PnlAddbk.Visible = true; PnlPrint.Visible = false; btnPrint.Visible = false; grdBookDetails.Focus(); //UpdatePanel1.Update(); }
protected void grdBookDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { cndate = txtCNDate.Text.Split('/')[2] + "/" + txtCNDate.Text.Split('/')[1] + "/" + txtCNDate.Text.Split('/')[0]; cndt = Convert.ToDateTime(cndate); int r1 = grdBookDetails.Rows.Count; int cntr1 = 0; if (Session["UserName"] != null) { CNNo = Convert.ToInt32(txtCnno.Text.Trim()); CreditNote _obedtcn = new CreditNote(); LedgerCN _obedtld = new LedgerCN(); try { foreach (GridViewRow Row in grdBookDetails.Rows) { CheckBox chkBxSelect = (CheckBox)Row.FindControl("chkBxSelect"); if (chkBxSelect != null) { if (chkBxSelect.Checked == true) { // bool chkbx = ((CheckBox)Row.FindControl("chkBxSelect")).; string RQty = (((TextBox)Row.FindControl("txtretquty")).Text.Trim()); //string DfQty = ((TextBox)Row.FindControl("txtdefquty")).Text; string CrQty = (((TextBox)Row.FindControl("txtquty")).Text.Trim()); string AtID = (((Label)Row.FindControl("lblDAutoID")).Text.Trim()); _obedtcn.AutoID = Convert.ToInt32(AtID); _obedtcn.CNNo = CNNo; //_obedtcn.CustCode = (DDLCustomer.SelectedValue); _obedtcn.CustCode = CustCode; //txtcustomer.Text.Trim().ToString(); _obedtcn.BookCode = (((Label)Row.FindControl("lblBookCode")).Text.Trim()); _obedtcn.Rate = Convert.ToDecimal(((TextBox)Row.FindControl("txtrate")).Text.Trim()); _obedtcn.Discount = Convert.ToDecimal(((TextBox)Row.FindControl("txtDiscount")).Text.Trim()); _obedtcn.ReturnQty = Convert.ToInt32(CrQty); _obedtcn.Comment = (((TextBox)Row.FindControl("txtcmmt")).Text.Trim()); _obedtcn.IsActive = true; _obedtcn.UpdatedBy = Session["UserName"].ToString(); _obedtcn.Flag = (((Label)Row.FindControl("lblflag")).Text.Trim()); _obedtcn.TotReturnQty = Convert.ToInt32(RQty); _obedtcn.DefectQty = 0; _obedtcn.IsDeleted = true; _obedtcn.strFY = Convert.ToInt32(strFY); _obedtcn.CNDate = cndt; _obedtld.CNDate = cndt; if (txtGCN.Text != "") { _obedtcn.GCN = Convert.ToInt32(txtGCN.Text); } else { _obedtcn.GCN = 0; } if (txtSCN.Text != "") { _obedtcn.SCN = Convert.ToInt32(txtSCN.Text); } else { _obedtcn.SCN = 0; } _obedtcn.LrNo = txtlRNO.Text.Trim().ToString(); _obedtcn.TransportName = lbltransporter.Text.Trim().ToString(); _obedtcn.Update_CN(Convert.ToInt32(strFY)); cntr1 = cntr1 + 1; } } } //_obedtcn.AutoID = Convert.ToInt32(AtID); //_obedtcn.CNNo = CNNo; //_obedtcn.CustCode = (DDLCustomer.SelectedValue); //_obedtcn.BookCode = ((Label)grdBookDetails.Rows[e.NewEditIndex].FindControl("lblBookCode")).Text; //_obedtcn.Rate = Convert.ToDecimal(((TextBox)grdBookDetails.Rows[e.NewEditIndex].FindControl("txtrate")).Text.Trim()); //_obedtcn.Discount = Convert.ToDecimal(((TextBox)grdBookDetails.Rows[e.NewEditIndex].FindControl("txtDiscount")).Text.Trim()); //_obedtcn.ReturnQty = Convert.ToInt32(CrQty); //_obedtcn.Comment = ((TextBox)grdBookDetails.Rows[e.NewEditIndex].FindControl("txtcmmt")).Text; //_obedtcn.IsActive = true; //_obedtcn.UpdatedBy = Session["UserName"].ToString(); //_obedtcn.Flag = ((Label)grdBookDetails.Rows[e.NewEditIndex].FindControl("lblflag")).Text; //_obedtcn.TotReturnQty = Convert.ToInt32(RQty); //_obedtcn.DefectQty = 0; //_obedtcn.IsDeleted = false; //_obedtcn.Update_CN(); if (cntr1 == 0) { MessageBox("Select Record To Delete"); } if (cntr1 > 0) { _obedtld.CNNo = CNNo; _obedtld.strFY = Convert.ToInt32(Convert.ToInt32(strFY)); _obedtld.CNDate = cndt; _obedtld.Ledger_CN(); MessageBox("Record Deleted Successfully"); CustCode = null; txtcustomer.Text = ""; lblCustName.Text = ""; // Bindgrdcn(); DataSet grid = new DataSet(); grid = CreditNote.EditCN(Convert.ToInt32(strFY), CNNo); grdBookDetails.DataSource = grid; grdBookDetails.DataBind(); quantity = 0; tamount = 0; DataTable dt1 = new DataTable(); dt1 = DCReturnBook.GetCustAddress(cust, "CNCustlist").Tables[0]; if (dt1.Rows.Count > 0) { lblCNNo.Text = (txtCnno.Text.Trim()); lblCustName1.Text = dt1.Rows[0]["CustName"].ToString(); lblCustAddress.Text = dt1.Rows[0]["Address"].ToString(); } PnlAddbk.Visible = true; btn_Save.Visible = true; PnlPrint.Visible = false; btnPrint.Visible = false; } } catch { } grdBookDetails.Focus(); } }