private void BindGrid() { string strItemName = txtTyreName.Text.Trim(); TyreMastDAL objTyreMast = new TyreMastDAL(); var lstGridData = objTyreMast.SelectForSearch(strItemName); objTyreMast = null; if (lstGridData != null && lstGridData.Count > 0) { grdMain.DataSource = lstGridData; grdMain.DataBind(); 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(); lblTotalRecord.Text = "T. Record(s): " + lstGridData.Count; imgBtnExcel.Visible = true; lblcontant.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): 0 "; imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }
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")); LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete"); int Tyreiddno = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "TyreType_Idno")); TyreMastDAL obj = new TyreMastDAL(); var TyreExist = obj.CheckTyreExistInOtherMaster(Convert.ToInt32(Tyreiddno)); if (TyreExist != null && TyreExist.Count > 0) { lnkbtnDelete.Visible = false; } else { lnkbtnDelete.Visible = true; } imgBtnStatus.Visible = true; if (status == false) { imgBtnStatus.ImageUrl = "~/Images/inactive.png"; } else { imgBtnStatus.ImageUrl = "~/Images/active.png"; } } }
private void Populate(Int32 TyreIdno) { TyreMastDAL objTyreMast = new TyreMastDAL(); var objitmMast = objTyreMast.SelectById(TyreIdno); objTyreMast = null; if (objitmMast != null) { txtItemName.Text = Convert.ToString(objitmMast.TyreType_Name); chkStatus.Checked = Convert.ToBoolean(objitmMast.TyreType_Status); hidItemidno.Value = Convert.ToString(objitmMast.TyreType_Idno); txtItemName.Focus(); } }
public void Countall() { TyreMastDAL objTyreMast = new TyreMastDAL(); Int64 count = objTyreMast.Countall(); if (count > 0) { lblTotalRecord.Text = "T. Record (s):" + count; } else { lblTotalRecord.Text = "T. Record (s): 0 "; } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { Int64 intTyreIdno = 0; string strMsg = string.Empty; TyreMastDAL objTyreMast = new TyreMastDAL(); if (string.IsNullOrEmpty(hidItemidno.Value) == true) { intTyreIdno = objTyreMast.Insert(txtItemName.Text.Trim(), Convert.ToBoolean(chkStatus.Checked)); } else { intTyreIdno = objTyreMast.Update(txtItemName.Text.Trim(), Convert.ToBoolean(chkStatus.Checked), Convert.ToInt64(hidItemidno.Value)); } if (intTyreIdno > 0) { this.ClearControls(); lnkbtnNew.Visible = false; if (string.IsNullOrEmpty(hidItemidno.Value) == false) { ShowMessage("Record updated successfully."); } else { ShowMessage("Record saved successfully."); } } else if (intTyreIdno < 0) { ShowMessageErr("Record already exists!"); } else { if (string.IsNullOrEmpty(hidItemidno.Value) == false) { ShowMessageErr("Record not updated!"); } else { ShowMessageErr("Record not saved!"); } } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { string strMsg = string.Empty; if (e.CommandName == "cmdEdit") { Response.Redirect("TyreMaster.aspx?TyreIdno=" + e.CommandArgument, true); } else if (e.CommandName == "cmdstatus") { int intitemIdno = 0; bool bStatus = false; string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strStatus.Length > 1) { intitemIdno = Convert.ToInt32(strStatus[0]); if (Convert.ToBoolean(strStatus[1]) == true) { bStatus = false; } else { bStatus = true; } TyreMastDAL objItemMast = new TyreMastDAL(); int value = objItemMast.UpdateStatus(intitemIdno, bStatus); objItemMast = null; if (value > 0) { this.BindGrid(); ShowMessage("Status updated successfully."); txtTyreName.Focus(); } else { ShowMessageErr("Status not updated."); } } } else if (e.CommandName == "cmddelete") { TyreMastDAL objItemMast = new TyreMastDAL(); long intValue = objItemMast.Delete(Convert.ToInt32(e.CommandArgument)); objItemMast = null; if (intValue > 0) { this.BindGrid(); ShowMessage("Record deleted successfully."); } else { if (intValue == -1) { ShowMessageErr("Record can not be deleted. It is in use!"); } else { ShowMessageErr("Record not deleted!"); } } } }