private void GetMaxClaimNo() { ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); txtClaimNo.Text = objClaimFrmDAL.GetClaimMax(string.IsNullOrEmpty(ddlFromCity.SelectedValue) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue), string.IsNullOrEmpty(txtPrefixNo.Text.Trim()) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()), Convert.ToInt64(ddlDateRange.SelectedValue)).ToString(); objClaimFrmDAL = null; }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { string strMsg = string.Empty; if (e.CommandName == "cmdEdit") { Response.Redirect("ClaimFrm.aspx?ClaimHeadIdno=" + e.CommandArgument, true); } else if (e.CommandName == "cmddelete") { objClaimFrmDAL = new ClaimFrmDAL(); long intValue = objClaimFrmDAL.Delete(Convert.ToInt32(e.CommandArgument)); objClaimFrmDAL = null; if (intValue > 0) { this.BindGrid(); strMsg = "Record deleted successfully."; } else { if (intValue == -1) { strMsg = "Record can not be deleted. It is in use!"; } else { strMsg = "Record not deleted."; } } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); } }
protected void lnkbtnSubmit_Click(object sender, EventArgs e) { try { ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); if ((grdSearchRecords != null) && (grdSearchRecords.Rows.Count > 0)) { string SerialIdDetlValue = string.Empty; for (int count = 0; count < grdSearchRecords.Rows.Count; count++) { CheckBox ChkGr = (CheckBox)grdSearchRecords.Rows[count].FindControl("chkId"); if ((ChkGr != null) && (ChkGr.Checked == true)) { HiddenField hidSerialIdno = (HiddenField)grdSearchRecords.Rows[count].FindControl("hidSerialIdno"); SerialIdDetlValue = SerialIdDetlValue + hidSerialIdno.Value + ","; } } if (SerialIdDetlValue != "") { SerialIdDetlValue = SerialIdDetlValue.Substring(0, SerialIdDetlValue.Length - 1); } if (SerialIdDetlValue == "") { ShowMessageErr("Please select atleast one Serial No."); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } else { string Result = String.Empty; DataTable dt = new DataTable(); DataRow Dr; if (RDbSaleBill.Checked == true) { dt = objClaimFrmDAL.Select(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(SerialIdDetlValue)); } else { dt = objClaimFrmDAL.SelectClaimDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(SerialIdDetlValue)); } if (dt != null && dt.Rows.Count > 0) { objClaimFrmDAL = null; ViewState["dt"] = dt; } this.BindGridT(); } } } catch (Exception Ex) { ApplicationFunction.ErrorLog(Ex.Message); } }
private void Populate(Int64 ClaimHeadIdno) { ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); tblClaimHead ObjHead = objClaimFrmDAL.Select_ClaimHead(ClaimHeadIdno); if (ObjHead != null) { ViewState["ClaimHeadIdno"] = ClaimHeadIdno; ddlDateRange.SelectedValue = Convert.ToString(ObjHead.Year_Idno); txtPrefixNo.Text = ObjHead.Prefix_No.ToString(); txtClaimDate.Text = string.IsNullOrEmpty(ObjHead.ClaimHead_Date.ToString()) ? "" : Convert.ToDateTime(ObjHead.ClaimHead_Date).ToString("dd-MM-yyyy"); if ((string.IsNullOrEmpty(Convert.ToString(ObjHead.Claim_Against)) ? 0 : Convert.ToInt64(ObjHead.Claim_Against)) > 0) { RDbParty.Checked = true; } else { RDbSaleBill.Checked = true; } txtClaimNo.Text = string.IsNullOrEmpty(ObjHead.Claim_No.ToString()) ? "" : Convert.ToString(ObjHead.Claim_No); ddlFromCity.SelectedValue = string.IsNullOrEmpty(ObjHead.FromLoc_Idno.ToString())? "0" : Convert.ToString(ObjHead.FromLoc_Idno); ddlParty.SelectedValue = string.IsNullOrEmpty(ObjHead.Prty_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Prty_Idno); ddlCompanyName.SelectedValue = string.IsNullOrEmpty(ObjHead.Comp_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Comp_Idno); RDbParty.Enabled = false; RDbSaleBill.Enabled = false; ddlFromCity.Enabled = false; imgSearch.Visible = false; dtTemp = CreateDt(); string Result = String.Empty; var ClaimNo = objClaimFrmDAL.SelectSaleBillNo(Convert.ToInt64(ClaimHeadIdno)); if (ClaimNo != null && ClaimNo > 0) { lblSbillNo.Text = "Sale Bill No : " + ClaimNo.ToString(); } DataTable dt = new DataTable(); if ((string.IsNullOrEmpty(Convert.ToString(ObjHead.Claim_Against)) ? 0 : Convert.ToInt64(ObjHead.Claim_Against)) > 0) { dt = objClaimFrmDAL.SelectClaimParty(ApplicationFunction.ConnectionString(), ClaimHeadIdno); } else { dt = objClaimFrmDAL.SelectClaimDetails(ApplicationFunction.ConnectionString(), ClaimHeadIdno); } if (dt != null && dt.Rows.Count > 0) { objClaimFrmDAL = null; ViewState["dt"] = dt; } this.BindGridT(); ViewState["dt"] = dtTemp; this.BindGridT(); } }
protected void Page_Load(object sender, EventArgs e) { //if (Request.UrlReferrer == null) //{ // base.AutoRedirect(); //} #region is Postback............ if (!Page.IsPostBack) { ClaimFrmDAL obj = new ClaimFrmDAL(); txtClaimDate.Attributes.Add("onkeypress", "return notAllowAnything(event);"); dtTemp = CreateDt(); ViewState["dt"] = dtTemp; this.BindDateRange(); this.BindPartyName(); this.BindCompany(); if (Convert.ToString(Session["Userclass"]) == "Admin") { this.BindCity(); } else { this.BindCity(Convert.ToInt64(Session["UserIdno"])); } ddlDateRange.SelectedIndex = 0; ddlDateRange_SelectedIndexChanged(null, null); GetMaxClaimNo(); if (Request.QueryString["ClaimHeadIdno"] != null) { this.Populate(Convert.ToInt64(Request.QueryString["ClaimHeadIdno"].ToString())); var ClaimExist = obj.Exists(Convert.ToInt64(Request.QueryString["ClaimHeadIdno"])); if (ClaimExist != null && ClaimExist.Count > 0) { DivSave.Visible = false; } else { DivSave.Visible = true; } //lnkbtnPrint.Visible = true; ddlDateRange.Enabled = false; lnkbtnNew.Visible = true; } else { lnkbtnNew.Visible = false; } } #endregion }
private void BindGrid() { ClaimFrmDAL objClaim = new ClaimFrmDAL(); string ClaimNo = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text)) ? "" : Convert.ToString(txtClaimNo.Text); Int64 YearIdno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlPartyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlPartyName.SelectedValue); Int64 CompanyIdno = string.IsNullOrEmpty(Convert.ToString(ddlCompName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompName.SelectedValue); Int64 LocationFrom = string.IsNullOrEmpty(Convert.ToString(ddlLocation.SelectedValue)) ? 0 : Convert.ToInt64(ddlLocation.SelectedValue); DateTime?dtfrom = null; DateTime?dtto = null; if (string.IsNullOrEmpty(Convert.ToString(txtDateFrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(txtDateTo.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)); } var lstGridData = objClaim.SelectSearchListReport(dtfrom, dtto, ClaimNo, PartyIdno, LocationFrom, CompanyIdno, YearIdno); objClaim = null; if (lstGridData != null && lstGridData.Count > 0) { grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; imgBtnExcel.Visible = true; int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): 0 "; imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete"); Int64 intClaimHeadIdno = Convert.ToInt64(DataBinder.Eval(e.Row.DataItem, "ClaimHead_Idno")); if (intClaimHeadIdno > 0) { ClaimFrmDAL obj = new ClaimFrmDAL(); var ClaimExist = obj.Exists(Convert.ToInt64(intClaimHeadIdno)); obj = null; if (ClaimExist != null && ClaimExist.Count > 0) { lnkbtnDelete.Visible = false; } else { lnkbtnDelete.Visible = true; } } } }
protected void lnkbtnSave_Click(object sender, EventArgs e) { string msg = ""; DateTime?ClaimDate = null; ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); DateTime CurrentDate = System.DateTime.Now; Int64 intAgainst = 0; if (RDbSaleBill.Checked == true) { intAgainst = 0; } else { intAgainst = 1; } if (grdMain.Rows.Count > 0) { DTMain = CreateDt(); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno"); HiddenField hidSbillIdno = (HiddenField)row.FindControl("hidSbillIdno"); TextBox txtDefRemark = (TextBox)row.FindControl("txtDefRemark"); TextBox txtVchAppDetl = (TextBox)row.FindControl("txtVchAppDetl"); ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidSbillIdno.Value, txtDefRemark.Text, txtVchAppDetl.Text); } tblClaimHead objClaimHead = new tblClaimHead(); if (txtClaimDate.Text == "") { objClaimHead.ClaimHead_Date = null; } else { objClaimHead.ClaimHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } objClaimHead.Claim_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim()); objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()); objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue); objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue); objClaimHead.Claim_Against = intAgainst; objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue); Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (ViewState["ClaimHeadIdno"] != null) { objClaimHead.Date_Modified = System.DateTime.Now; lnkbtnNew.Visible = false; value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(ViewState["ClaimHeadIdno"].ToString()), DTMain); objClaimFrmDAL = null; } else { objClaimHead.Date_Added = System.DateTime.Now; value = objClaimFrmDAL.Insert(objClaimHead, DTMain); objClaimFrmDAL = null; } if (ViewState["ClaimHeadIdno"] != null) { if (value > 0 && (ViewState["ClaimHeadIdno"] != null)) { ShowMessage("Record Update successfully"); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not Update"); tScope.Dispose(); } } else { if (value > 0 && (ViewState["ClaimHeadIdno"] == null)) { ShowMessage("Record saved Successfully "); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not saved Successfully "); tScope.Dispose(); } } } } else { ShowMessageErr("Please Search and Select Serial Number."); return; } }
protected void lnkbtnSearch_OnClick(object sender, EventArgs e) { ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); if (RDbSaleBill.Checked == true) { if (txtSBillNo.Text == "" && ddlDivPrtyName.SelectedValue == "0") { DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Sale Bill Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return; } else { grdSearchRecords.Visible = true; DataTable dt = CreateDivDt(); Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue); DateTime? DateFrom = null; DateTime?DateTo = null; DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text)); DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text)); Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue); string SbillNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim())); var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, SbillNo, PartyIdno, Location, intyearid); if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno"))); string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo"))); string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo")); string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo")); string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno")); string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "SBillDate")).ToString("dd-MM-yyyy")); string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName")); string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName")); string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno")); ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId); } ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno"))); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } } else { grdSearchRecords.Visible = true; DataTable dt = CreateDivDt(); Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue); Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue); var lst = objClaimFrmDAL.SearchByParty(PartyIdno, Location, intyearid); if (lst != null && lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno"))); string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo"))); string PrefNo = ""; string BillNo = "0"; string SbillIdNo = "0"; string SBillDate = ""; string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName")); string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName")); string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno")); ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId); } ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno"))); ViewState["dtDivGrid"] = dt; dt.Dispose(); this.BindDivGrid(); DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } else { DivErrorMsg.Visible = false; lblDivErrorMsg.InnerText = ""; } objClaimFrmDAL = null; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); } }