protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cmdedit") { int Idno = Convert.ToInt32(e.CommandArgument); this.Populate(Idno); } else if (e.CommandName == "cmddelete") { FuelRateMasterDAL obj = new FuelRateMasterDAL(); int Idno = Convert.ToInt32(e.CommandArgument); Int32 result = obj.Delete(Idno); obj = null; if (result == 1) { this.ShowMessage("Records Delete Successfully."); } else { this.ShowMessageErr("Records Not Delete."); } this.ClearControls(); this.BindGrid(); } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtFuelRate.Text.Trim()) == true || Convert.ToDouble(txtFuelRate.Text.Trim()) <= 0) { this.ShowMessageErr("Rate Should be greater than Zero."); return; } if (drpFuel.SelectedValue == "0") { this.ShowMessageErr("Please select fuel."); drpFuel.Focus(); return; } Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString()); string smsg = string.Empty; Int64 FuelIdno = 0; FuelRateMasterDAL objDAL = new FuelRateMasterDAL(); tblFuelRateMaster tblobj = new tblFuelRateMaster(); tblobj.FuelRate_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim())); tblobj.Acnt_Idno = Convert.ToInt32(drpPump.SelectedValue); tblobj.Fuel_Rate = Convert.ToDouble(txtFuelRate.Text.Trim()); tblobj.Comp_Idno = Convert.ToInt32(cOMPiD); tblobj.ItemIdno = Convert.ToInt32(drpFuel.SelectedValue); tblobj.Status = true; tblobj.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue); tblobj.Date_Added = System.DateTime.Now; if (string.IsNullOrEmpty(hidIdno.Value) == true) { FuelIdno = objDAL.Insert(tblobj); } else { FuelIdno = objDAL.Update(tblobj, Convert.ToInt32(hidIdno.Value)); } if (FuelIdno == 0) { ShowMessageErr("Record Not Saved "); this.ClearControls(); } else if (FuelIdno < 0) { ShowMessageErr("Record already exists."); this.ClearControls(); } else if (FuelIdno > 0) { if (string.IsNullOrEmpty(hidIdno.Value) == true) { ShowMessage("Record Saved Successfully"); this.ClearControls(); } else { ShowMessage("Record Updated Successfully."); this.ClearControls(); } this.BindGrid(); this.ClearControls(); } }
private void BindFuel() { FuelRateMasterDAL objclsFuelSlip = new FuelRateMasterDAL(); var objFuelSlip = objclsFuelSlip.SelectItemName(); objclsFuelSlip = null; drpFuel.DataSource = objFuelSlip; drpFuel.DataTextField = "Item_Name"; drpFuel.DataValueField = "Item_Idno"; drpFuel.DataBind(); drpFuel.Items.Insert(0, new ListItem(" ----Select---- ", "0")); }
private void BindState() { drpPump.DataSource = null; FuelRateMasterDAL objDAL = new FuelRateMasterDAL(); var lst = objDAL.BindPump(); objDAL = null; drpPump.DataSource = lst; drpPump.DataTextField = "Acnt_Name"; drpPump.DataValueField = "Acnt_Idno"; drpPump.DataBind(); drpPump.Items.Insert(0, new ListItem("--Select Pump--", "0")); }
private void Populate(int Idno) { lnkbtnNew.Visible = true; FuelRateMasterDAL objDAL = new FuelRateMasterDAL(); tblFuelRateMaster tblMast = objDAL.SelectByID(Idno); objDAL = null; if (tblMast != null) { ddlDateRange.SelectedValue = Convert.ToString(tblMast.Year_Idno); txtDate.Text = Convert.ToString(Convert.ToDateTime(tblMast.FuelRate_Date).ToString("dd-MM-yyyy")); drpPump.SelectedValue = Convert.ToString(tblMast.Acnt_Idno); txtDate.Enabled = drpPump.Enabled = false; drpFuel.SelectedValue = Convert.ToString(tblMast.ItemIdno ?? 0); txtFuelRate.Text = Convert.ToString(tblMast.Fuel_Rate); hidIdno.Value = tblMast.FuelRate_Idno.ToString(); } }
private void BindGrid() { FuelRateMasterDAL obj = new FuelRateMasterDAL(); IList lstGridData = obj.BindRecords(Convert.ToInt32(drpPump.SelectedValue), Convert.ToInt32(ddlDateRange.SelectedValue)); obj = null; grdMain.DataSource = lstGridData; grdMain.DataBind(); if (lstGridData != null) { if (lstGridData.Count > 0) { DivGridShow.Visible = true; lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count; 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 { DivGridShow.Visible = false; lblTotalRecord.Text = "Total Record (s): 0"; lblcontant.Visible = false; divpaging.Visible = false; } } else { DivGridShow.Visible = false; lblTotalRecord.Text = "Total Record (s): 0"; lblcontant.Visible = false; divpaging.Visible = false; } }