//Item Grid Bind #region [Item Category Grid Bind] private void BindItemGrid() { try { EWA_PurchaseOrder objEWA = new EWA_PurchaseOrder(); BL_PurchaseOrder objBL = new BL_PurchaseOrder(); objEWA.SupplierId = ddlSupplier.SelectedValue; objEWA.OrgId = orgId; DataSet ds = objBL.BindItemGrid_BL(objEWA); if (ds.Tables[0].Rows.Count == 0 || ds == null) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GrdItem.DataSource = ds; GrdItem.DataBind(); int columncount = GrdItem.Rows[0].Cells.Count; GrdItem.Rows[0].Cells.Clear(); GrdItem.Rows[0].Cells.Add(new TableCell()); GrdItem.Rows[0].Cells[0].ColumnSpan = columncount; GrdItem.Rows[0].Cells[0].Text = "No Records Found"; } else { GrdItem.DataSource = ds; GrdItem.DataBind(); ItemName1.Text = ds.Tables[0].Rows[0]["ItemName"].ToString(); Category1.Text = ds.Tables[0].Rows[0]["CategoryName"].ToString(); Suppliername1.Text = ddlSupplier.SelectedItem.ToString(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Item Grid Bind #region [Item Category Grid Bind] private void BindItemGrid() { try { //DataSet ds = objBL.BindItemGrid_BL(); //if (ds.Tables[0].Rows.Count == 0 || ds == null) //{ // ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); // GrdItem.DataSource = ds; // GrdItem.DataBind(); // int columncount = GrdItem.Rows[0].Cells.Count; // GrdItem.Rows[0].Cells.Clear(); // GrdItem.Rows[0].Cells.Add(new TableCell()); // GrdItem.Rows[0].Cells[0].ColumnSpan = columncount; // GrdItem.Rows[0].Cells[0].Text = "No Records Found"; //} //else //{ GrdItem.DataSource = db.Displaygrid("SELECT tblItem.ItemId,tblItem.ItemName, tblItem.ItemCode, tblItem.CategoryId,tblCategory.CategoryName, tblItem.UnitId,tblUnit.UnitName, tblItem.Stock FROM tblItem INNER JOIN tblCategory ON tblItem.CategoryId = tblCategory.CategoryId INNER JOIN tblUnit ON tblItem.UnitId = tblUnit.UnitId WHERE tblItem.OrgId='" + Convert.ToInt32(Session["OrgId"]) + "' "); GrdItem.DataBind(); //} } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Empty Item Grid #region [Empty Item Grid] private void EmptyItemGrid() { try { DataTable dt = new DataTable(); dt.Columns.Add("ItemId"); dt.Columns.Add("ItemName"); dt.Columns.Add("CategoryName"); dt.Columns.Add("UnitName"); dt.Columns.Add("Qty"); dt.Columns.Add("Rate"); dt.Rows.Add(); dt.Rows.Add(); GrdItem.DataSource = dt; GrdItem.DataBind(); // GrdSelectedItems.DataSource = dt; //GrdSelectedItems.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); //throw; } }
public FrmEntry(string Action, ref GrdItem grd) { InitializeComponent(); btnAction.Text = Action; wrkGrd = grd; string[] strArr = new string[] { "Quimica", "Fisica", "Economia", "Calculo", "Historia" }; cmbDeptos.Items.AddRange(strArr); }
public void clear() { txtPODate.Text = string.Empty; ddlSupplier.ClearSelection(); GrdItem.DataSource = null; GrdItem.DataBind(); ddlDeliveryMode.ClearSelection(); ddlPaymentMode.ClearSelection(); txtRemark.Text = string.Empty; btnSave.Enabled = false; ViewState["POItem"] = null; }
//Grid Index Changed #region GrdIndexChanged protected void GrdItem_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { GrdItem.PageIndex = e.NewPageIndex; GrdItem.DataSource = objBL.BindItemGrid_BL(); GrdItem.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//SupplierCategory Link #region SupplierSupplierLinkButtonClick protected void lnkBtnSupplierName_Click(object sender, EventArgs e) { try { lock (this) { BL_Supplier objBL = new BL_Supplier(); EWA_Supplier objEWA = new EWA_Supplier(); LinkButton lnkBtnId = (LinkButton)sender; GridViewRow grdrow = lnkBtnId.NamingContainer as GridViewRow; // lnkBtnId = (LinkButton)grdrow.Cells[0].FindControl("SupplierId"); ViewState["SupplierId"] = GrdSupplier.DataKeys[grdrow.RowIndex].Value.ToString(); objEWA.SupplierId = Convert.ToInt32(ViewState["SupplierId"]); objEWA.OrgId = orgId; DataSet ds = objBL.BindSupplierData_BL(objEWA); txtSupplierName.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["SupplierName"].ToString(); //ddlCategory.SelectedValue = GrdSupplier.DataKeys[grdrow.RowIndex].Values["CategoryId"].ToString(); txtMobileNo.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["MobileNo"].ToString(); txtPhoneNo.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["PhoneNo"].ToString(); txtFaxNo.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["FaxNo"].ToString(); txtEmailId.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["EmailId"].ToString(); txtWebsite.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["Website"].ToString(); txtAddress.Text = GrdSupplier.DataKeys[grdrow.RowIndex].Values["Address"].ToString(); if (ds.Tables[1].Rows.Count >= 0) { ViewState["SuppItem"] = ds; GrdItem.DataSource = ds.Tables[2]; GrdItem.DataBind(); } else { BindItemGrid(); } callUpdate(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void CmsDgvGrd_Click(object sender, ToolStripItemClickedEventArgs e) { try { switch (e.ClickedItem.Text) { case "Add New Row": try { // Instantiates new trade class and pass it on GrdItem newGrd = new GrdItem(); using (FrmEntry FrmEntry = new FrmEntry("Save", ref newGrd)) { FrmEntry.StartPosition = FormStartPosition.Manual; FrmEntry.Location = ClickPoint; // Show order pad FrmEntry.ShowDialog(); // Get order pad action performed if (FrmEntry.DialogResult == DialogResult.OK) { int selectedLine = dgvGrd.SelectedRows[0].Index; grdItems.Insert(selectedLine, newGrd); // Force refresh dgvGrd.DataSource = null; dgvGrd.DataSource = grdItems; // For some reason grid looses format after refresh FormatacaoColunas(); // Select the just added row dgvGrd.Rows[selectedLine].Selected = true; } }; } catch (Exception) { throw; } break; case "Edit Selected Row": if (dgvGrd.SelectedRows.Count > 0) { GrdItem editGrd = grdItems[dgvGrd.SelectedRows[0].Index]; using (FrmEntry FrmEntry = new FrmEntry("Update", ref editGrd)) { FrmEntry.StartPosition = FormStartPosition.Manual; FrmEntry.Location = ClickPoint; // Show order pad FrmEntry.ShowDialog(); // Get order pad action performed if (FrmEntry.DialogResult == DialogResult.OK) { grdItems[dgvGrd.SelectedRows[0].Index] = editGrd; dgvGrd.Refresh(); } } } else { //SendMsg(" Please, right click the row you want to edit"); } break; case "Delete Selected Row": if (dgvGrd.SelectedRows.Count > 0) { GrdItem deleteGrd = grdItems[dgvGrd.SelectedRows[0].Index]; using (FrmEntry FrmEntry = new FrmEntry("Delete", ref deleteGrd)) { FrmEntry.StartPosition = FormStartPosition.Manual; FrmEntry.Location = ClickPoint; // Show order pad FrmEntry.ShowDialog(); // Get order pad action performed if (FrmEntry.DialogResult == DialogResult.OK) { grdItems.RemoveAt(dgvGrd.SelectedRows[0].Index); // Force refresh dgvGrd.DataSource = null; dgvGrd.DataSource = grdItems; // For some reason grid looses format after refresh FormatacaoColunas(); } } } else { //SendMsg(" Please, right click the row you want to DELETE"); } break; case "Sort Rows Ascending": grdItems.Sort((x, y) => x.Nome.CompareTo(y.Nome)); dgvGrd.Refresh(); break; case "Sort Rows Descending": grdItems.Sort((x, y) => y.Nome.CompareTo(x.Nome)); dgvGrd.Refresh(); break; default: //SendMsg(e.ClickedItem.Text); break; } } catch { //SendMsg("Context menu : " + ex.Message); } }