protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) { DtTemp = (DataTable)ViewState["dt"]; if (DtTemp == null && DtTemp.Rows.Count > 0) { ShowMessage("Please enter details"); return; } Int64 HeadId = 0; PaymentRecDAL obj = new PaymentRecDAL(); HeadId = obj.Insert(DtTemp, Convert.ToInt32(drpChallanDetail.SelectedValue), Convert.ToDouble(txtNetAmnt.Text)); obj = null; if (HeadId > 0) { ShowMessage("Record save successfully"); } else if (HeadId < 0) { ShowMessage("Summary No already exists"); } else { ShowMessage("Record not saved successfully"); } this.ClearAll(); }
public void ChallanDetail() { PaymentRecDAL obj = new PaymentRecDAL(); DataTable lst = obj.FetchChallanDetail(constring, Convert.ToInt32(ddlDateRange.SelectedValue)); if (lst.Rows.Count > 0) { drpChallanDetail.DataSource = lst; drpChallanDetail.DataTextField = "chln_Detl"; drpChallanDetail.DataValueField = "Chln_Idno"; drpChallanDetail.DataBind(); drpChallanDetail.Items.Insert(0, new ListItem("--Select--", "0")); } }
protected void drpChallanDetail_SelectedIndexChanged(object sender, EventArgs e) { try { if (drpChallanDetail.SelectedIndex >= 0) { PaymentRecDAL obj = new PaymentRecDAL(); DataTable DsChlnDetMst = obj.FillChlnDetMast(ApplicationFunction.ConnectionString(), Convert.ToInt32(drpChallanDetail.SelectedValue)); Gridmainhead.DataSource = null; Gridmainhead.DataSource = DsChlnDetMst; Gridmainhead.DataBind(); txtNetAmnt.Text = Convert.ToDouble(obj.FillChlnDetNetAmnt(ApplicationFunction.ConnectionString(), Convert.ToInt32(drpChallanDetail.SelectedValue))).ToString("N2"); DataTable DtPay = obj.SelectPayDet(ApplicationFunction.ConnectionString(), Convert.ToInt32(drpChallanDetail.SelectedValue)); grdMain.DataSource = null; grdMain.DataSource = DtPay; grdMain.DataBind(); ViewState["dt"] = (DataTable)DtPay; } else { Gridmainhead.DataSource = null; Gridmainhead.DataBind(); grdMain.DataSource = null; grdMain.DataBind(); txtNetAmnt.Text = "0.00"; } } catch (Exception Ex) { } }
protected void imgBtnDelete_Click(object sender, ImageClickEventArgs e) { try { if (drpChallanDetail.SelectedIndex > 0) { PaymentRecDAL obj = new PaymentRecDAL(); int value = 0; value = obj.Delete(Convert.ToInt32(drpChallanDetail.SelectedValue)); if (value > 0) { ShowMessage("Record delete successfully"); } else { ShowMessage("Record not delete successfully"); } } } catch (Exception ex) { } }