protected void linkbtnEdit_Click(object sender, EventArgs e) { LinkButton lb = (LinkButton)sender; GridViewRow gr = (GridViewRow)lb.NamingContainer; ViewState["id"] = ((Label)gr.FindControl("labelNOTICE_ID")).Text; string nid = ViewState["id"].ToString(); ProductInvoice_Master dm = ProductInvoice_Master.GetByINVOICE_ID(int.Parse(nid)); ddlItem.SelectedValue = dm.ITEM_ID.ToString(); txtItemCode.Text = ITEM_MASTER.GetByITEM_ID(ddlItem.SelectedIndex).CODE; txtcgst.Text = dm.CGST_RATE.ToString(); txtsgst.Text = dm.SGST_RATE.ToString(); txtigst.Text = dm.IGST_RATE.ToString(); numqty.Text = dm.QUANTITY.ToString(); txtrate.Text = dm.RATE_PER.ToString(); btnsave.Text = "Update"; }
protected void btnsave_Click(object sender, EventArgs e) { try { decimal maxrateigst = 0; decimal total = 0; ProductInvoice_Master ln = new ProductInvoice_Master(); total = decimal.Parse(numqty.Text) * decimal.Parse(txtrate.Text.Trim()); if (btnsave.Text == "Submit") { if (string.IsNullOrEmpty(numqty.Text)) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Plz Enter Quantity..');</Script>", false); numqty.Focus(); return; } else { decimal qt = decimal.Parse(numqty.Text.Trim()); if (qt <= 0) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Quantity must be greater than zero..');</Script>", false); numqty.Focus(); return; } } ln.INVOICE_ID = ProductInvoice_Master.MaxId() + 1; ln.ITEM_ID = int.Parse(ddlItem.SelectedValue); ln.ITEMNAME = ITEM_MASTER.GetByITEM_ID(ln.ITEM_ID).ITEMNAME; ln.HSNCODE = ITEM_MASTER.GetByITEM_ID(ln.ITEM_ID).HSNCODE; ln.QUANTITY = decimal.Parse(numqty.Text); ln.RATE_PER = decimal.Parse(txtrate.Text.Trim()); ln.TOTAL = total; decimal cgst = decimal.Parse(txtcgst.Text.Trim()); decimal sgst = decimal.Parse(txtsgst.Text.Trim()); decimal igst = decimal.Parse(txtigst.Text.Trim()); if (cgst > maxrate) { maxrate = cgst; } if (sgst > maxrate) { maxrate = sgst; } if (igst > maxrate) { maxrate = igst; } maxrateigst = maxrate; ln.CGST_AMT = (total * cgst) / 100; ln.SGST_AMT = (total * sgst) / 100; ln.IGST_AMT = (total * igst) / 100; ln.CGST_RATE = cgst; ln.SGST_RATE = sgst; ln.IGST_RATE = igst; ln.BILL_ID = billid; ln.REMARKS = ""; ln.INVOICE_DATE = System.DateTime.Today; ln.Bil_Stutas = "Waiting"; ln.Save(); } else if (btnsave.Text == "Update") { ln = ProductInvoice_Master.GetByINVOICE_ID(int.Parse(ViewState["id"].ToString())); ln.INVOICE_ID = int.Parse(ViewState["id"].ToString()); ln.ITEM_ID = int.Parse(ddlItem.SelectedValue); ln.ITEMNAME = ITEM_MASTER.GetByITEM_ID(ln.ITEM_ID).ITEMNAME; ln.HSNCODE = ITEM_MASTER.GetByITEM_ID(ln.ITEM_ID).HSNCODE; ln.QUANTITY = decimal.Parse(numqty.Text); ln.RATE_PER = decimal.Parse(txtrate.Text.Trim()); ln.TOTAL = total; decimal cgst = decimal.Parse(txtcgst.Text.Trim()); decimal sgst = decimal.Parse(txtsgst.Text.Trim()); decimal igst = decimal.Parse(txtigst.Text.Trim()); if (cgst > maxrate) { maxrate = cgst; } if (sgst > maxrate) { maxrate = sgst; } if (igst > maxrate) { maxrate = igst; } maxrateigst = maxrate; ln.CGST_AMT = (total * cgst) / 100; ln.SGST_AMT = (total * sgst) / 100; ln.IGST_AMT = (total * igst) / 100; ln.CGST_RATE = cgst; ln.SGST_RATE = sgst; ln.IGST_RATE = igst; ln.BILL_ID = billid; ln.REMARKS = ""; ln.INVOICE_DATE = System.DateTime.Today; ln.Bil_Stutas = "Waiting"; ln.Save(); ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Update Successfully...');</Script>", false); } grid(); ddlItem.SelectedIndex = 0; ClearControls(this); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert(error);</script>", false); } }