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