protected void btnSaveRecpt_Click(object sender, EventArgs e) { try { recId = int.Parse(txtRecNo.Text); if (validate()) { CustomValidator1.IsValid = true; CustomValidator1.ErrorMessage = ""; int intReceiptNo = Convert.ToInt32(txtRecNo.Text); DateTime dateReceiptDate = Convert.ToDateTime(txtRecDate.Text); int mode = 0; int intClId = Convert.ToInt32(txtClId.Text); int intGrpId; if (txtGrpId.Text == "") intGrpId = 0; else intGrpId = Convert.ToInt32(txtGrpId.Text); string strpaytyp = DRpDwnLstPmntTyp.SelectedItem.Text; double doubleAmt = Convert.ToDouble(txtAmt.Text); double doubleTDS = Convert.ToDouble(txtTDSReadOnly.Text); double doubledisc = Convert.ToDouble(txtDisc.Text); string strBnkNm = txtBnkNm.Text; string strChqDftNo = txtChqOrDftNo.Text; DateTime dtChqDftDate = Convert.ToDateTime(txtChqOrDftDt.Text); int intAgainstBills = 0; if (chkAgainstBills.Checked == true) intAgainstBills = 1; else intAgainstBills = 0; double doublebalAmt = double.Parse(txtBalamt.Text); int intTDSCertRecvd = 0; if (chkbxTDSCertRecvd.Checked == true) intTDSCertRecvd = 1; else intTDSCertRecvd = 0; string strCmmnts = txtCoommnts.Text; string strClNm = DrplstClRec.SelectedItem.Text; string strSubGrpNm = txtSubGrpNm.Text; int intIsDel = 0; if (rbtnlstIsDel.SelectedItem.Text == "Yes") intIsDel = 1; else intIsDel = 0; double BillAmt = Convert.ToDouble(txtBllAmt.Text); double TDSPerc = Convert.ToDouble(txtTDSPerc.Text); int intApp = 0; if (chkbxAppRecpt.Checked == true) intApp = 1; else intApp = 0; BLAddReceipt bladdRec = new BLAddReceipt(); if (Request.QueryString["ReceiptId"] != null) { mode = 1; RecId = int.Parse(Request.QueryString["ReceiptId"]); bladdRec.UpdateReceipt(RecId, dateReceiptDate, intGrpId, strpaytyp, doubleAmt, doubleTDS, doubledisc, strBnkNm, strChqDftNo, dtChqDftDate, intAgainstBills, doublebalAmt, intTDSCertRecvd, strCmmnts, strSubGrpNm, intIsDel, BillAmt, TDSPerc, intApp); updateAdjustAmount(mode, RecId); DrplstClRec.Enabled = true; lblResult.Visible = true; lblResult.Text = "Receipt Details are Updated Successfully"; BtnClearRec.Enabled = true; recId++; txtRecNo.Text = recId.ToString(); ClearAll(); } else { bladdRec.addReceipt(intReceiptNo, dateReceiptDate, intClId, intGrpId, strpaytyp, doubleAmt, doubleTDS, doubledisc, strBnkNm, strChqDftNo, dtChqDftDate, intAgainstBills, doublebalAmt, intTDSCertRecvd, strCmmnts, strClNm, strSubGrpNm, intIsDel, BillAmt, TDSPerc, intApp); updateAdjustAmount(mode, recId); recId++; txtRecNo.Text = recId.ToString(); foreach (GridViewRow gvrow in GrdVwInvoice.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { CheckBox chkSel = gvrow.Cells[0].FindControl("chksel") as CheckBox; Label invid = (gvrow.Cells[0].FindControl("lblInvoiceId") as Label); //Label lblamt = (gvrow.Cells[0].FindControl("lblamt") as Label); if (chkSel.Checked) { int InvoiceId = int.Parse(invid.Text); //int ReceiptId = intReceiptNo; string constr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand("SaveReciptInvoices_SP", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ReceiptId", recId); cmd.Parameters.AddWithValue("@InvoiceId", InvoiceId); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } lblResult.Visible = true; lblResult.Text = "Receipt Details are Added Successfully"; DrplstClRec.Enabled = true; ClearAll(); } } else { CustomValidator1.IsValid = false; CustomValidator1.ErrorMessage = "*"; CustomValidator1.ToolTip = "Enter Proper Amt"; } } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }
protected void DrplstClRec_SelectedIndexChanged(object sender, EventArgs e) { try { lblResult.Text = ""; string ClNm = DrplstClRec.SelectedItem.Text; BLAddReceipt bladdRec = new BLAddReceipt(); SqlDataReader dr = bladdRec.GetClientIdByNm1(ClNm); if (dr.HasRows) { dr.Read(); txtClId.Text = Convert.ToString(dr.GetInt32(0)); dr.Close(); } } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { try { SqlDataReader dr; BLAddReceipt blViewRec = new BLAddReceipt(); if ((HttpContext.Current.Session["LoginId"]) == null) { Response.Redirect("~/Login.aspx"); } txtChqOrDftDt.Text = System.DateTime.Now.ToShortDateString(); dr = blViewRec.GetMaxRecId(); if (dr.Read()) { if (dr.IsDBNull(0)) { recid = 0; } else { recid = dr.GetInt32(0); dr.Close(); } } recid++; if (!Page.IsPostBack) { txtRecNo.Text = recid.ToString(); dr = blViewRec.getClientRec(); if (dr.HasRows) { while (dr.Read()) DrplstClRec.Items.Add(dr.GetString(0)); DrplstClRec.Items.Insert(0, new ListItem("--Select--", "-1")); dr.Close(); } txtRecDate.Text = System.DateTime.Now.ToShortDateString(); txtChqOrDftDt.Text = System.DateTime.Now.ToShortDateString(); if (Request.QueryString["ReceiptId"] != null) { RecId = int.Parse(Request.QueryString["ReceiptId"]); SqlDataReader drGetRecDet = blViewRec.GetRecDetForUpdate(RecId); if (drGetRecDet.HasRows == true) { while (drGetRecDet.Read()) { txtRecNo.Text = (drGetRecDet.GetInt32(1)).ToString(); DateTime recdate = drGetRecDet.GetDateTime(2); txtRecDate.Text = recdate.ToShortDateString(); txtClId.Enabled = false; txtClId.Text = drGetRecDet.GetInt32(3).ToString(); int ClientId = int.Parse(txtClId.Text); txtGrpId.Text = drGetRecDet.GetInt32(4).ToString(); string paymenttype = drGetRecDet.GetString(5); DRpDwnLstPmntTyp.SelectedValue = paymenttype; txtAmt.Text = (drGetRecDet.GetSqlMoney(6)).ToString(); txtTDSReadOnly.Text = drGetRecDet.GetSqlMoney(7).ToString(); txtDisc.Text = drGetRecDet.GetSqlMoney(8).ToString(); txtBnkNm.Text = drGetRecDet.GetString(9); txtChqOrDftNo.Text = drGetRecDet.GetString(10).ToString(); DateTime chequedftdate = drGetRecDet.GetDateTime(11); txtChqOrDftDt.Text = chequedftdate.ToShortDateString(); bool isonacc = drGetRecDet.GetBoolean(12); if (isonacc == true) chkAgainstBills.Checked = true; else chkAgainstBills.Checked = false; txtBalamt.Text = drGetRecDet.GetSqlMoney(13).ToString(); bool tdsCerRecceived = drGetRecDet.GetBoolean(14); if (tdsCerRecceived == true) chkbxTDSCertRecvd.Checked = true; else chkbxTDSCertRecvd.Checked = false; txtCoommnts.Text = drGetRecDet.GetString(15); DrplstClRec.Enabled = false; DrplstClRec.SelectedValue = drGetRecDet.GetString(16); txtSubGrpNm.Text = drGetRecDet.GetString(17); bool isdel = drGetRecDet.GetBoolean(18); if (isdel == true) rbtnlstIsDel.Items.FindByValue("Yes").Selected = true; else rbtnlstIsDel.Items.FindByValue("No").Selected = true; txtBllAmt.Text = drGetRecDet.GetDecimal(19).ToString(); txtTDSPerc.Text = drGetRecDet.GetDecimal(20).ToString(); int app = drGetRecDet.GetInt32(21); if (app == 1) chkbxAppRecpt.Checked = true; else chkbxAppRecpt.Checked = false; //if against bills is true then diaplay invoice details in gridview if (chkAgainstBills.Checked == true) { SqlDataReader drGetInvForGirdview = blViewRec.GetInvoiceByAddRec1(ClientId, update); Panel1.Visible = true; GrdVwInvoice.Visible = true; GrdVwInvoice.DataSource = drGetInvForGirdview; GrdVwInvoice.DataBind(); } } drGetRecDet.Close(); BtnClearRec.Enabled = false; } } } else { lblAmtMsg.Text = ""; CalendarExtender1.SelectedDate = DateTime.ParseExact(txtChqOrDftDt.Text, CalendarExtender1.Format, null); CalendarExtender2.SelectedDate = DateTime.ParseExact(txtRecDate.Text, CalendarExtender2.Format, null); } } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }
protected void chkAgainstBills_CheckedChanged(object sender, EventArgs e) { try { if (Request.QueryString["ReceiptId"] != null) { if (chkAgainstBills.Checked == true) { Panel1.Visible = true; GrdVwInvoice.Visible = true; BLAddReceipt bladdInvce = new BLAddReceipt(); int ClId = Convert.ToInt32(txtClId.Text); getInvByAddRec(ClId, update); } } if (chkAgainstBills.Checked == true) { update = 0; Panel1.Visible = true; GrdVwInvoice.Visible = true; int ClId = Convert.ToInt32(txtClId.Text); getInvByAddRec(ClId, update); } else Panel1.Visible = false; } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }