private void BindPartyName()
{
LorryMasterDAL objLorrMast = new LorryMasterDAL();
var LorrMast = objLorrMast.SelectPartyName();
objLorrMast = null;
ddlPartyName.DataSource = LorrMast;
ddlPartyName.DataTextField = "Acnt_Name";
ddlPartyName.DataValueField = "Acnt_Idno";
ddlPartyName.DataBind();
ddlPartyName.Items.Insert(0, new ListItem("< Choose Party Name >", "0"));
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton imgBtnStatus = (ImageButton)e.Row.FindControl("imgBtnStatus");
bool status = Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "Status"));
//ImageButton imgBtnEdit = (ImageButton)e.Row.FindControl("imgBtnEdit");
////ImageButton imgBtnDelete = (ImageButton)e.Row.FindControl("imgBtnDelete");
//base.CheckUserRights(intFormId);
//if (base.Edit == false)
{
imgBtnStatus.Visible = true;
//imgBtnEdit.Visible = false;
//grdMain.Columns[4].Visible = false;
}
//if (base.Delete == false)
//{
// imgBtnDelete.Visible = false;
//}
//if ((base.Edit == false) && (base.Delete == false))
//{
// grdMain.Columns[5].Visible = false;
//}
if (status == false)
{
imgBtnStatus.ImageUrl = "~/Images/inactive.png";
}
else
{
imgBtnStatus.ImageUrl = "~/Images/active.png";
}
// Used to hide Delete button if ItemgrpId exists in GR Preparation,F.Mgmt---> Purchase Bill ,Material Issue, Trip Start
LinkButton imgBtnDelete = (LinkButton)e.Row.FindControl("lnkBtnDelete");
string LorryIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "LorryIdno"));
if (LorryIdno != "")
{
LorryMasterDAL obj = new LorryMasterDAL();
var ItemExist = obj.CheckItemExistInOtherMaster(Convert.ToInt32(LorryIdno));
if (ItemExist != null && ItemExist.Count > 0)
{
imgBtnDelete.Visible = false;
}
else
{
imgBtnDelete.Visible = true;
}
}
// end----
}
}
private void BindLorryStatusGrid()
{
LorryMasterDAL objDash = new LorryMasterDAL();
DataSet ds = objDash.SelectLorryDetails(ApplicationFunction.ConnectionString());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
grdMain.DataSource = ds;
grdMain.DataBind();
HideDiv.Visible = false;
Upload_div.Visible = true;
}
else
{
HideDiv.Visible = true;
Upload_div.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
txtOwnrNme.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.Print == false)
{
imgBtnExcel.Visible = false;
}
this.BindPartyName();
ddlPartyName.Focus();
LorryMasterDAL objLorrMast = new LorryMasterDAL();
lblTotalRecord.Text = "T Record (s):" + objLorrMast.Count();
}
}
// double dGrossAmount = 0, dBiltyAmount = 0, dShortAmount = 0, dTrServTaxAmount = 0,dConsignrServTaxAmount=0, dNetAmount = 0;
#endregion
#region Page Load Event ...
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
conString = ApplicationFunction.ConnectionString();
UFinYear = base.FatchFinYear(1);
if (!Page.IsPostBack)
{
//if (base.CheckUserRights(intFormId) == false)
//{
// Response.Redirect("PermissionDenied.aspx");
//}
if (base.View == false)
{
}
if (Request.QueryString["LorryDt"] != null)
{
string date = Convert.ToString(Request.QueryString["LorryDt"]);
LorryMasterDAL objDash = new LorryMasterDAL();
DataTable Dt = objDash.SelectLorryIDs(date, ApplicationFunction.ConnectionString());
string strAllIds = ""; int iCount = 0;
for (int i = 0; i < Dt.Rows.Count; i++)
{
strAllIds = strAllIds + Convert.ToString(Dt.Rows[i]["ID"]) + ",";
iCount++;
}
if (strAllIds.Length != 0)
{
strAllIds = strAllIds.Substring(0, strAllIds.Length - 1);
}
DataTable DtDet = objDash.SelectLorryDetDateWise(date, ApplicationFunction.ConnectionString());
DataTable DTemp = objDash.SelectLorrys(strAllIds, ApplicationFunction.ConnectionString());
//Fitness Date
if (DTemp.Rows.Count == 1)
{
for (int i = 0; i < DTemp.Rows.Count; i++)
{
for (int j = 0; j < DtDet.Rows.Count; j++)
{
if (Convert.ToInt32(DtDet.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[i]["Lorry_Idno"]) && Convert.ToString(DtDet.Rows[j]["Type"]) == "FIT")
{
Fit += 1;
}
if (Convert.ToInt32(DtDet.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[i]["Lorry_Idno"]) && Convert.ToString(DtDet.Rows[j]["Type"]) == "INS")
{
Ins += 1;
}
if (Convert.ToInt32(DtDet.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[i]["Lorry_Idno"]) && Convert.ToString(DtDet.Rows[j]["Type"]) == "RC")
{
RC += 1;
}
if (Convert.ToInt32(DtDet.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[i]["Lorry_Idno"]) && Convert.ToString(DtDet.Rows[j]["Type"]) == "NAT")
{
Nat += 1;
}
if (Convert.ToInt32(DtDet.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[i]["Lorry_Idno"]) && Convert.ToString(DtDet.Rows[j]["Type"]) == "AUTH")
{
Auth += 1;
}
}
if (Fit == 0)
{
DTemp.Rows[i]["Fitness_Date"] = "";
}
if (Ins == 0)
{
DTemp.Rows[i]["Ins_Valid_Date"] = "";
}
if (RC == 0)
{
DTemp.Rows[i]["RC_Date"] = "";
}
if (Nat == 0)
{
DTemp.Rows[i]["Nat_Permit_Date"] = "";
}
if (Auth == 0)
{
DTemp.Rows[i]["Auth_Permit_Date"] = "";
}
}
}
else
{
DataTable dtnew = new DataTable();
DataColumn dtCol; dtCol = new DataColumn("ID", typeof(string));
dtnew.Columns.Add(dtCol); dtCol = new DataColumn("FIT", typeof(string));
dtnew.Columns.Add(dtCol); dtCol = new DataColumn("INS", typeof(string));
dtnew.Columns.Add(dtCol); dtCol = new DataColumn("RC", typeof(string));
dtnew.Columns.Add(dtCol); dtCol = new DataColumn("NAT", typeof(string));
dtnew.Columns.Add(dtCol); dtCol = new DataColumn("AUTH", typeof(string));
dtnew.Columns.Add(dtCol);
DataRow dr = dtnew.NewRow();
dr.BeginEdit();
dr[0] = ""; dr[1] = ""; dr[2] = ""; dr[3] = ""; dr[4] = ""; dr[5] = ""; dtnew.Rows.InsertAt(dr, 0); dtnew.AcceptChanges();
DataRow dr1 = dtnew.NewRow();
dr1.BeginEdit();
dr1[0] = ""; dr1[1] = ""; dr1[2] = ""; dr1[3] = ""; dr1[4] = ""; dr1[5] = ""; dtnew.Rows.InsertAt(dr1, 1); dtnew.AcceptChanges();
DataRow dr2 = dtnew.NewRow();
dr2.BeginEdit();
dr2[0] = ""; dr2[1] = ""; dr2[2] = ""; dr2[3] = ""; dr2[4] = ""; dr2[5] = ""; dtnew.Rows.InsertAt(dr2, 2); dtnew.AcceptChanges();
DataRow dr3 = dtnew.NewRow();
dr3.BeginEdit();
dr3[0] = ""; dr3[1] = ""; dr3[2] = ""; dr3[3] = ""; dr3[4] = ""; dr3[5] = ""; dtnew.Rows.InsertAt(dr3, 2); dtnew.AcceptChanges();
DataRow dr4 = dtnew.NewRow();
dr4.BeginEdit();
dr4[0] = ""; dr4[1] = ""; dr4[2] = ""; dr4[3] = ""; dr4[4] = ""; dr4[5] = ""; dtnew.Rows.InsertAt(dr4, 2); dtnew.AcceptChanges();
for (int k = 0; k < Dt.Rows.Count; k++)
{
DataTable DtID = objDash.SelectLorryDetDateIDWise(date, Convert.ToString(Dt.Rows[k][0].ToString()), ApplicationFunction.ConnectionString());
for (int j = 0; j < DtID.Rows.Count; j++)
{
if (Convert.ToInt32(DtID.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[k]["Lorry_Idno"]) && Convert.ToString(DtID.Rows[j]["Type"]) == "FIT")
{
Fit += 1;
dtnew.Rows[k]["FIT"] = "1";
}
if (Convert.ToInt32(DtID.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[k]["Lorry_Idno"]) && Convert.ToString(DtID.Rows[j]["Type"]) == "INS")
{
Ins += 1;
dtnew.Rows[k]["INS"] = "1";
}
if (Convert.ToInt32(DtID.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[k]["Lorry_Idno"]) && Convert.ToString(DtID.Rows[j]["Type"]) == "RC")
{
RC += 1;
dtnew.Rows[k]["RC"] = "1";
}
if (Convert.ToInt32(DtID.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[k]["Lorry_Idno"]) && Convert.ToString(DtID.Rows[j]["Type"]) == "NAT")
{
Nat += 1; dtnew.Rows[k]["NAT"] = "1";
}
if (Convert.ToInt32(DtID.Rows[j]["ID"]) == Convert.ToInt32(DTemp.Rows[k]["Lorry_Idno"]) && Convert.ToString(DtID.Rows[j]["Type"]) == "AUTH")
{
Auth += 1; dtnew.Rows[k]["AUTH"] = "1";
}
}
for (int l = 0; l <= k; l++)
{
if (Convert.ToString(dtnew.Rows[l]["FIT"]) == "")
{
DTemp.Rows[l]["Fitness_Date"] = "";
}
if (dtnew.Rows[l]["INS"] == "")
{
DTemp.Rows[l]["Ins_Valid_Date"] = "";
}
if (dtnew.Rows[l]["RC"] == "")
{
DTemp.Rows[l]["RC_Date"] = "";
}
if (dtnew.Rows[l]["NAT"] == "")
{
DTemp.Rows[l]["Nat_Permit_Date"] = "";
}
if (dtnew.Rows[l]["AUTH"] == "")
{
DTemp.Rows[l]["Auth_Permit_Date"] = "";
}
}
Fit = 0; Ins = 0; RC = 0; Nat = 0; Auth = 0;
}
}
if (DTemp != null && DTemp.Rows.Count > 0)
{
grdMain.DataSource = DTemp;
grdMain.DataBind();
}
}
}
}
private void BindGrid()
{
LorryMasterDAL objLorrMast = new LorryMasterDAL();
var lstGridData = objLorrMast.SelectForSearch(Convert.ToString(txtOwnrNme.Text.Trim()), Convert.ToInt32(ddlPartyName.SelectedValue), Convert.ToString(txtlryno.Text.Trim()),
Convert.ToString(txtpanno.Text.Trim()));
objLorrMast = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("PrtyName", typeof(string));
dt.Columns.Add("Owner", typeof(string));
dt.Columns.Add("LorryType", typeof(string));
dt.Columns.Add("LorryNo", typeof(string));
dt.Columns.Add("DriverName", typeof(string));
dt.Columns.Add("LorryMake", typeof(string));
dt.Columns.Add("Pan", typeof(string));
dt.Columns.Add("EngineNo", typeof(string));
dt.Columns.Add("ChasisNo", typeof(string));
dt.Columns.Add("Status", typeof(string));
dt.Columns.Add("LowRate", typeof(string));
dt.Columns.Add("MobileNo", typeof(string));
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["PrtyName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "prty_Name"));
dr["Owner"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "OwnerName"));
dr["LorryType"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "LorryType"));
dr["LorryNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "LorryNo"));
dr["DriverName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DriverName"));
dr["LorryMake"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "LorryMake"));
dr["Pan"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "PanNo"));
dr["EngineNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "EngineNo"));
dr["ChasisNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "ChasisNo"));
dr["LowRate"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "LowRate"));
dr["MobileNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "MobileNo"));
dr["Status"] = (Convert.ToBoolean(DataBinder.Eval(lstGridData[i], "Status")) == false)?"InActive":"Active";
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
//
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T Record (s): 0";
imgBtnExcel.Visible = false;
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("LorryMaster.aspx?LorryIdno=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
LorryMasterDAL objLorrMast = new LorryMasterDAL();
Int32 intValue = objLorrMast.Delete(Convert.ToInt32(e.CommandArgument));
objLorrMast = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
ddlPartyName.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);
}
else if (e.CommandName == "cmdstatus")
{
int intLorryIdno = 0;
bool bStatus = false;
string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' });
if (strStatus.Length > 1)
{
intLorryIdno = Convert.ToInt32(strStatus[0]);
if (Convert.ToBoolean(strStatus[1]) == true)
{
bStatus = false;
}
else
{
bStatus = true;
}
LorryMasterDAL objLorryMast = new LorryMasterDAL();
int value = objLorryMast.UpdateStatus(intLorryIdno, bStatus, empIdno);
objLorryMast = null;
if (value > 0)
{
this.BindGrid();
strMsg = "Status updated successfully.";
ddlPartyName.Focus();
}
else
{
strMsg = "Status not updated.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
ddlPartyName.Focus();
}
