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;
}
}
