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