private void LoadAllItem()
{
using (DataTable dtItem = new DataTable())
{
dtItem.Columns.Add("ItemIdType");
dtItem.Columns.Add("ItemName");
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
foreach (DataRow drItem in objSpareMaster.GetAll(new Entity.Inventory.SpareMaster()
{
}).Rows)
{
DataRow drNewItem = dtItem.NewRow();
drNewItem["ItemIdType"] = drItem["SpareId"].ToString();
drNewItem["ItemName"] = drItem["SpareName"].ToString() + ((drItem["IsTonner"].ToString() == "0") ? " (S)" : " (T)");
dtItem.Rows.Add(drNewItem);
dtItem.AcceptChanges();
}
ddlItem.DataSource = dtItem;
ddlItem.DataValueField = "ItemIdType";
ddlItem.DataTextField = "ItemName";
ddlItem.DataBind();
ddlItem.InsertSelect();
}
}
private void PopulateSpare()
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
spareMaster = objSpareMaster.GetById(SpareId);
txtSpareName.Text = spareMaster.SpareName;
txtYield.Text = Convert.ToString(spareMaster.Yield);
txtDescription.Text = spareMaster.Description;
chkIsTonner.Checked = spareMaster.isTonner;
}
private void LoadSpare()
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
DataTable dt = objSpareMaster.GetAll(spareMaster);
if (dt != null)
{
gvSpare.DataSource = dt;
gvSpare.DataBind();
}
}
private void LoadAllItem()
{
using (DataTable dtItem = new DataTable())
{
dtItem.Columns.Add("ItemIdType");
dtItem.Columns.Add("ItemName");
Business.Inventory.ProductMaster objProductMaster = new Business.Inventory.ProductMaster();
foreach (DataRow drItem in objProductMaster.GetAll(new Entity.Inventory.ProductMaster()
{
CompanyMasterId = 1
}).Rows)
{
DataRow drNewItem = dtItem.NewRow();
drNewItem["ItemIdType"] = drItem["ProductMasterId"].ToString() + "|" + (int)ItemType.Product;
drNewItem["ItemName"] = drItem["ProductName"].ToString() + " (P)";
dtItem.Rows.Add(drNewItem);
dtItem.AcceptChanges();
}
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
foreach (DataRow drItem in objSpareMaster.GetAll(new Entity.Inventory.SpareMaster()
{
}).Rows)
{
DataRow drNewItem = dtItem.NewRow();
drNewItem["ItemIdType"] = drItem["SpareId"].ToString() + "|" + (int)ItemType.Spare;
drNewItem["ItemName"] = drItem["SpareName"].ToString() + " (S)";
dtItem.Rows.Add(drNewItem);
dtItem.AcceptChanges();
}
ddlItem.DataSource = dtItem;
ddlItem.DataValueField = "ItemIdType";
ddlItem.DataTextField = "ItemName";
ddlItem.DataBind();
ddlItem.InsertSelect();
}
}
protected void gvSpare_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Ed")
{
SpareId = int.Parse(e.CommandArgument.ToString());
PopulateSpare();
}
else if (e.CommandName == "Del")
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
int i = objSpareMaster.Delete(int.Parse(e.CommandArgument.ToString()));
if (i > 0)
{
ClearControls();
LoadSpare();
Message.IsSuccess = true;
Message.Text = "Spare deleted successfully...";
}
else
{
Message.IsSuccess = false;
Message.Text = "Spare can not delete!!!";
}
Message.Show = true;
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Business.Inventory.SpareMaster objSpareMaster = new Business.Inventory.SpareMaster();
Entity.Inventory.SpareMaster spareMaster = new Entity.Inventory.SpareMaster();
spareMaster.SpareId = SpareId;
spareMaster.SpareName = txtSpareName.Text;
spareMaster.Yield = int.Parse(txtYield.Text);
spareMaster.Description = txtDescription.Text;
spareMaster.isTonner = chkIsTonner.Checked;
int i = objSpareMaster.Save(spareMaster);
if (i > 0)
{
ClearControls();
LoadSpare();
Message.IsSuccess = true;
Message.Text = "Spare saved successfully...";
}
else
{
Message.IsSuccess = false;
Message.Text = "Spare can not save!!!";
}
Message.Show = true;
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
