private void BindGrid() { VechDetlClmPrtyDAL objGrid = new VechDetlClmPrtyDAL(); Int64 AcntIdno = string.IsNullOrEmpty(Convert.ToString(Request.QueryString["AcntIdno"])) ? 0 : Convert.ToInt64(Request.QueryString["AcntIdno"]); if (AcntIdno > 0) { var lst = objGrid.SelectAcntName(AcntIdno); if (lst != null) { lblAcntName.Text = string.IsNullOrEmpty(Convert.ToString(lst.Acnt_Name)) ? "" : Convert.ToString(lst.Acnt_Name.ToUpper()); lblAcntName.Visible = true; } Int64 LocIdno = string.IsNullOrEmpty(Convert.ToString(ddlLocation.SelectedValue)) ? 0 : Convert.ToInt64(ddlLocation.SelectedValue); Int32 YearIdno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue); IList lstGridData = objGrid.SelectAllDetails(AcntIdno, LocIdno, YearIdno); objGrid = null; if (lstGridData != null && lstGridData.Count > 0) { grdMain.DataSource = lstGridData; grdMain.DataBind(); } else { grdMain.DataSource = null; grdMain.DataBind(); } } else { Response.Redirect(""); } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { BindDropdownDAL objDropDal = new BindDropdownDAL(); Int64 StckDetlIdno = 0; VechDetlClmPrtyDAL objDAL = new VechDetlClmPrtyDAL(); Int32 intYearIdno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue); Int64 intLocIdno = string.IsNullOrEmpty(Convert.ToString(ddlLocation.SelectedValue)) ? 0 : Convert.ToInt64(ddlLocation.SelectedValue); Int64 intItemIdno = string.IsNullOrEmpty(Convert.ToString(ddlItemName.SelectedValue)) ? 0 : Convert.ToInt64(ddlItemName.SelectedValue); string strSerialNo = string.IsNullOrEmpty(Convert.ToString(txtSerialNo.Text)) ? "" : Convert.ToString(txtSerialNo.Text); string strCompName = string.IsNullOrEmpty(Convert.ToString(txtCompName.Text)) ? "" : Convert.ToString(txtCompName.Text); string strPurFrom = string.IsNullOrEmpty(Convert.ToString(txtPurchaseFrom.Text)) ? "" : Convert.ToString(txtPurchaseFrom.Text); Int32 intTyreType = string.IsNullOrEmpty(Convert.ToString(ddltype.SelectedValue)) ? 0 : Convert.ToInt32(ddltype.SelectedValue); Int64 intAcntIdno = string.IsNullOrEmpty(Convert.ToString(ddltype.SelectedValue)) ? 0 : Convert.ToInt64(ddltype.SelectedValue); double ddlOpenRate = string.IsNullOrEmpty(Convert.ToString(txtOpenRate.Text.Trim())) ? 0 : Convert.ToDouble(txtOpenRate.Text.Trim()); //Check Conditions Before Save Peeyush Kasuhik var lst1 = objDropDal.CheckSerialNo(strSerialNo); if (lst1 != null && lst1 > 0) { ShowMessageErr("Serial No already Exists !"); return; } if (string.IsNullOrEmpty(hidstckidno.Value) == true) { StckDetlIdno = objDAL.Insert(strSerialNo, intLocIdno, intItemIdno, strCompName, intTyreType, strPurFrom, intYearIdno, ddlOpenRate, (string.IsNullOrEmpty(Convert.ToString(Request.QueryString["AcntIdno"])) ? 0 : Convert.ToInt64(Request.QueryString["AcntIdno"]))); } else { StckDetlIdno = objDAL.Update((string.IsNullOrEmpty(Convert.ToString(hidstckidno.Value)) ? 0 : Convert.ToInt64(hidstckidno.Value)), strSerialNo, intLocIdno, intItemIdno, strCompName, intTyreType, strPurFrom, intYearIdno, ddlOpenRate, (string.IsNullOrEmpty(Convert.ToString(Request.QueryString["AcntIdno"])) ? 0 : Convert.ToInt64(Request.QueryString["AcntIdno"]))); } if (StckDetlIdno == 0) { ShowMessageErr("Record Not Saved "); } else if (StckDetlIdno == -1) { ShowMessageErr("Record already exists."); } else if (StckDetlIdno > 0) { if (hidstckidno.Value == "") { ShowMessage("Record Saved Successfully"); } else { ShowMessage("Record Updated Successfully."); } this.ClearControls(); this.BindGrid(); } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cmdedit") { Int64 stckDetlIdno = string.IsNullOrEmpty(Convert.ToString(e.CommandArgument)) ? 0 : Convert.ToInt64(e.CommandArgument); this.Populate(stckDetlIdno); } else if (e.CommandName == "cmddelete") { VechDetlClmPrtyDAL obj = new VechDetlClmPrtyDAL(); Int64 stckDetlIdno = string.IsNullOrEmpty(Convert.ToString(e.CommandArgument)) ? 0 : Convert.ToInt64(e.CommandArgument); int value = obj.Delete(stckDetlIdno); obj = null; if (value > 0) { ShowMessage("Record Deleted Successfully"); } this.ClearControls(); this.BindGrid(); } }
private void Populate(Int64 StckDetlIdno) { VechDetlClmPrtyDAL obj = new VechDetlClmPrtyDAL(); Stckdetl lst = obj.SelectById(StckDetlIdno); if (lst != null) { ddlDateRange.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.yearId)) ? "0" : Convert.ToString(lst.yearId); ddlLocation.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.Loc_Idno)) ? "0" : Convert.ToString(lst.Loc_Idno); ddlItemName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.ItemIdno)) ? "0" : Convert.ToString(lst.ItemIdno); txtSerialNo.Text = string.IsNullOrEmpty(Convert.ToString(lst.SerialNo)) ? "" : Convert.ToString(lst.SerialNo); txtCompName.Text = string.IsNullOrEmpty(Convert.ToString(lst.CompName)) ? "" : Convert.ToString(lst.CompName); txtPurchaseFrom.Text = string.IsNullOrEmpty(Convert.ToString(lst.PurFrom)) ? "" : Convert.ToString(lst.PurFrom); ddltype.SelectedValue = string.IsNullOrEmpty(Convert.ToString(lst.Type)) ? "0" : Convert.ToString(lst.Type); txtOpenRate.Text = string.IsNullOrEmpty(Convert.ToString(lst.OpenRate)) ? "" : Convert.ToString(lst.OpenRate); hidstckidno.Value = StckDetlIdno.ToString(); } else { this.ClearControls(); } }