protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdEdit")
{
Response.Redirect("FuelSlip.aspx?FuelSlipIdno=" + e.CommandArgument, true);
}
else if (e.CommandName == "cmddelete")
{
FuelSlipDAL objItemMast = new FuelSlipDAL();
long intValue = objItemMast.Delete(Convert.ToInt32(e.CommandArgument));
objItemMast = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
//ddlGroupType.Focus();
}
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);
}
}
private void BindGrid()
{
FuelSlipDAL objFuelSlipDAL = new FuelSlipDAL();
var lstGridData = objFuelSlipDAL.Select(string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue), string.IsNullOrEmpty(ddlLocation.SelectedValue) ? 0 : Convert.ToInt64(ddlLocation.SelectedValue), string.IsNullOrEmpty(ddlLorry.SelectedValue) ? 0 : Convert.ToInt64(ddlLorry.SelectedValue), string.IsNullOrEmpty(ddlDriver.SelectedValue) ? 0 : Convert.ToInt64(ddlDriver.SelectedValue), string.IsNullOrEmpty(ddlPPump.SelectedValue) ? 0 : Convert.ToInt64(ddlPPump.SelectedValue), Convert.ToInt64((txtSlipNo.Text) == "" ? "0" : txtSlipNo.Text));
objFuelSlipDAL = 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;
prints.Visible = false;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
private void BindDriver()
{
FuelSlipDAL objclsFuelSlip = new FuelSlipDAL();
var objFuelSlip = objclsFuelSlip.SelectDriver();
objclsFuelSlip = null;
ddlDriver.DataSource = objFuelSlip;
ddlDriver.DataTextField = "Driver_Name";
ddlDriver.DataValueField = "Driver_Idno";
ddlDriver.DataBind();
ddlDriver.Items.Insert(0, new ListItem(" ----Select---- ", "0"));
}
private void BindPump()
{
FuelSlipDAL objclsFuelSlip = new FuelSlipDAL();
var objFuelSlip = objclsFuelSlip.SelectPCompName();
objclsFuelSlip = null;
ddlPPump.DataSource = objFuelSlip;
ddlPPump.DataTextField = "Acnt_Name";
ddlPPump.DataValueField = "Acnt_Idno";
ddlPPump.DataBind();
ddlPPump.Items.Insert(0, new ListItem(" ----Select---- ", "0"));
}
public void Countall()
{
FuelSlipDAL objFuelSlip = new FuelSlipDAL();
Int64 count = objFuelSlip.Countall(string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue));
if (count > 0)
{
lblTotalRecord.Text = "T. Record (s):" + count;
}
else
{
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
