protected void ddlType_IndexChanged(object sender, EventArgs e) { if (txtToDate.Text == "" && txtFromDate.Text == "") { lblMessage.Text = "Please Select Dates"; return; } LoadEmptyGrid(); lblMessage.Text = string.Empty; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@Type", SqlDbType.Char, 3), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //0 new SqlParameter("@ToDate", SqlDbType.DateTime), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlTypes.SelectedValue; param[2].Value = sysFunc.SaveDate(txtFromDate.Text); param[3].Value = sysFunc.SaveDate(txtToDate.Text); ds = ObjGenral.FillDataSet("sp_2W_Service_GetClaimBillingData_new", param); if (ds.Tables[0].Rows.Count > 0) { Grdbillings.DataSource = ds; Grdbillings.DataBind(); Session["JENDetail"] = ds.Tables[0]; if (ds.Tables[0].Rows.Count > 0) { foreach (GridViewRow gvr in Grdbillings.Rows) { PST = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["HandlingAmount"].ToString()) + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["PSTSubletAmount"].ToString()) + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["PSTLaborAmount"].ToString()); GST = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["GSTAmount"].ToString()); TotalAmount = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["TotalAmount"].ToString()); CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); Chk.Checked = true; //ChkBox.Checked = true; } txtLabPST.Text = PST.ToString(); txtGSTAmt.Text = GST.ToString(); txtTotalAmount.Text = TotalAmount.ToString(); //CalculatePSTPercentage(); } } else { //txtPstAmt.Text = ""; //txtPerc.Text = ""; lblMessage.Text = "No Record Found !!!"; } }
protected void btnAdjAmt_Click(object sender, EventArgs e) { if (txtins_amount.Text == "") { SysFunc.UserMsg(success_add_item, Color.Red, "Please Enter Amount First!", txtins_amount); } double InsAmt, AdvBal; AdvBal = SysFunctions.CustomCDBL(txtBalance.Text); InsAmt = SysFunctions.CustomCDBL(txtins_amount.Text); AdvBal = SysFunctions.CustomCDBL(AdvBal - InsAmt); txtBalance.Text = AdvBal.ToString(); Session["Adj"] = "Adj"; }
private int GetTotalCount() { string sql = "Select Count(*) from CustomerInvoice where Delflag='N' and DealerCode='" + Session["DealerCode"].ToString() + "'"; int count = 0; dt = new DataTable(); dt = sysfun.GetData(sql); if (dt.Rows.Count > 0) { count = Convert.ToInt16(SysFunctions.CustomCDBL(dt.Rows[0][0].ToString())); } return(count); }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtTaxHead.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Tax Head should not left blank", txtTaxHead); return; } //if (txt.Text == "") //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Customer should not left blank", txtreg); // return; //} //if (txtRemarks.Text == "") //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtreg); // return; //} DataTable dt = (DataTable)Session["TaxTypeDS"]; try { string max = sysFuncs.GetNewMaxID("TaxType", "TaxID", 2, "COMON"); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@TaxID", SqlDbType.Char, 2), //1 new SqlParameter("@TaxHead", SqlDbType.VarChar, 50), //2 new SqlParameter("@TaxPer", SqlDbType.Decimal), //3 new SqlParameter("@Active", SqlDbType.Char, 1), //4 new SqlParameter("@Type", SqlDbType.VarChar, 50), //5 new SqlParameter("@TaxApplicable", SqlDbType.VarChar, 20), //6 new SqlParameter("@AccCode", SqlDbType.Char, 16), //7 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8 new SqlParameter("@UpdDate", SqlDbType.DateTime), //9 new SqlParameter("@UpdTime", SqlDbType.DateTime), //10 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 11 }; string activeCheck = ""; if (CheckId.Checked) { activeCheck = "Y"; } else { activeCheck = "N"; } // txtAccCode.Text = textAccCode; param[0].Value = "COMON"; param[1].Value = max; param[2].Value = txtTaxHead.Text; param[3].Value = SysFunctions.CustomCDBL(txtTaxPercent.Text); param[4].Value = activeCheck; param[5].Value = ddlType.Text; param[6].Value = ddlTaxApplicable.Text; param[7].Value = txtAccCode.Text; param[8].Value = Session["UserName"].ToString(); param[9].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[10].Value = DateTime.Now; param[11].Value = "1"; if (sysFunc.ExecuteSP_NonQuery("SP_Insert_TaxType", param)) { sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Record " + max + " Insert Sucessfully", txtTaxId); } else { sysFuncs.UserMsg(lblMessage, Color.Green, "Data Not Inserted", txtTaxId); } } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
//protected void ChkBox_CheckedChanged(object sender, EventArgs e) //{ // if (ChkBox.Checked) // { // foreach (GridViewRow gvr in Grdbillings.Rows) // { // TotalAmount = TotalAmount + Convert.ToDecimal(gvr.Cells[5].Text.Trim()); // CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); // Chk.Checked = true; // } // txtTotalAmount.Text = TotalAmount.ToString(); // CalculatePSTPercentage(); // } // else // { // foreach (GridViewRow gvr in Grdbillings.Rows) // { // CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); // Chk.Checked = false; // txtTotalAmount.Text = "0.00"; // //txtPstAmt.Text = "0.00"; // } // } //} protected void btnSave_Click(object sender, EventArgs e) { if (!sec.UserRight("2583", "002")) { Response.Redirect("~/Test.aspx"); } try { int grd = Grdbillings.Rows.Count; if (grd > 0) { //Auto Generated Code// DateTime dt = DateTime.Now; string strYear = dt.Year.ToString(); string BillNo; if (ddlBillingNo.SelectedValue.Trim() == "0") { BillNo = ObjGenral.AutoGen("JENBillMaster", "JENBillNo", DateTime.Now.ToString("dd-MM-yyyy")); } else { BillNo = ddlBillingNo.SelectedValue.Trim(); } //Auto Generated Code// string Remarks = txtRemarks.Text.Trim().ToString(); float BillRecAmount = 0; string DelFlag = "N", PostFlag = "N"; string UpdUser = Session["UserName"].ToString(); //FFI PDI Master Insert here SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1 new SqlParameter("@BillDate", SqlDbType.DateTime), //2 new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //3 new SqlParameter("@BillQty", SqlDbType.Int), //4 new SqlParameter("@BillAmount", SqlDbType.Float, 15), //5 new SqlParameter("@BillRecAmount", SqlDbType.Float, 15), //6 new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7 new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8 new SqlParameter("@UpdUser", SqlDbType.VarChar, 5), //9 //new SqlParameter("@UpdDate",SqlDbType.DateTime),//10 //new SqlParameter("@UpdTime",SqlDbType.DateTime),//11 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //12 new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //13 new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //14 new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //15 new SqlParameter("@SoftwareVersion", SqlDbType.VarChar, 25), //16 new SqlParameter("@BillType", SqlDbType.VarChar, 5), //17 new SqlParameter("@VehType", SqlDbType.Char, 3), //17 new SqlParameter("@CreditNo", SqlDbType.VarChar, 50), //17 new SqlParameter("@GSTAmount", SqlDbType.Decimal, 50), //17 new SqlParameter("@SSTAmount", SqlDbType.Decimal, 50), //17 //new SqlParameter("@SSTAge",SqlDbType.Decimal,18),//18 //new SqlParameter("@SSTAmount",SqlDbType.Decimal,18),//19 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = BillNo; param[2].Value = ObjGenral.SaveDate(txtBillDate.Text); //param[2].Value = txtBillDate.Text; param[3].Value = Remarks.ToUpper(); param[4].Value = Grdbillings.Rows.Count; param[5].Value = txtTotalAmount.Text.Trim().ToString(); param[6].Value = BillRecAmount; param[7].Value = DelFlag; param[8].Value = PostFlag; param[9].Value = Session["UserName"].ToString(); //param[10].Value = ObjGenral.SaveDate(DateTime.Now.ToString()); //param[11].Value = ObjGenral.SaveTime(DateTime.Now.ToString()); param[10].Value = GlobalVar.mUserIPAddress; param[11].Value = "C"; param[12].Value = null; param[13].Value = null; param[14].Value = null; param[15].Value = ddlTypes.SelectedValue.ToString(); param[16].Value = txtCreditNo.Text; param[17].Value = txtGSTAmt.Text.Trim(); param[18].Value = txtLabPST.Text.Trim(); if (ObjTrans.BeginTransaction(ref Trans) == true) { if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillMaster_Insert", param, Trans)) { lblLastBillNo.Text = "Last Code Generated : " + " " + BillNo; } } else { lblMessage.Text = "Error"; } //FFI PDI Master Insert here //Insert Detail Data Here foreach (GridViewRow gvr in Grdbillings.Rows) { string DealerCode = Session["DealerCode"].ToString(); string PPRCode = gvr.Cells[1].Text.Trim().ToString(); string BillNoDetail = BillNo; // string Billtype = ddlTypes.SelectedValue.ToString(); string BillAmount = gvr.Cells[5].Text.Trim().ToString(); CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@JENBillNo", SqlDbType.Char, 8), //1 new SqlParameter("@PPRCode", SqlDbType.Char, 8), //2 new SqlParameter("@PPRDate", SqlDbType.DateTime), //3 new SqlParameter("@ChassisNo", SqlDbType.VarChar, 15), //4 new SqlParameter("@Parts", SqlDbType.Float), //5 new SqlParameter("@Sublet", SqlDbType.Float), //6 new SqlParameter("@Labor", SqlDbType.Float), //7 new SqlParameter("@TotalAmount", SqlDbType.Float), //8 new SqlParameter("@GSTAmount", SqlDbType.Float), //9 new SqlParameter("@PSTLaborAmount", SqlDbType.Float), //10 new SqlParameter("@PSTSublet", SqlDbType.Float), //11 new SqlParameter("@HandlingAmount", SqlDbType.Float), //12 }; param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = BillNoDetail; param1[2].Value = PPRCode; param1[3].Value = sysFunc.SaveDate(gvr.Cells[2].Text.Trim().ToString()); param1[4].Value = gvr.Cells[4].Text.Trim().ToString(); param1[5].Value = SysFunctions.CustomCDBL(gvr.Cells[12].Text); param1[6].Value = SysFunctions.CustomCDBL(gvr.Cells[13].Text); param1[7].Value = SysFunctions.CustomCDBL(gvr.Cells[14].Text); param1[8].Value = SysFunctions.CustomCDBL(gvr.Cells[15].Text); param1[9].Value = SysFunctions.CustomCDBL(gvr.Cells[7].Text); param1[10].Value = SysFunctions.CustomCDBL(gvr.Cells[9].Text); param1[11].Value = SysFunctions.CustomCDBL(gvr.Cells[11].Text); param1[12].Value = SysFunctions.CustomCDBL(gvr.Cells[6].Text); // param1[3].Value = Billtype; if (Chk.Checked == true) { if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1, Trans)) { lblMessage.Text = "Record Has been Inserted Sucessfully !!!"; ClearAll(); } // ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1,Trans); } //Insert Detail Data Here } } else { string script = "alert(\"User should select some Bills !!!\");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } } catch (Exception ex) { ObjTrans.RollBackTransaction(ref Trans); lblMessage.Text = ex.Message; } ObjTrans.CommittTransaction(ref Trans); }