protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using(CatalogManager cm = new CatalogManager())
{
this.StationeriesGridView.DataSource = cm.GetAllStationeries();
this.StationeriesGridView.DataBind();
}
Stationery stationery = new Stationery();
StationeryPrice stationeryPrice = new StationeryPrice();
}
}
public Stationery CreateStationery(Stationery stationery)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
context.Stationeries.AddObject(stationery);
context.SaveChanges();
ts.Complete();
return stationery;
}
}
catch (Exception)
{
throw;
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
CatalogManager Manager = new CatalogManager();
Stationery stationery = new Stationery();
StationeryPrice[] stationeryPrice = new StationeryPrice[3];
stationery.ItemCode = NameTextBox.Text;
stationery.Description = DescriptionTextBox.Text;
stationery.UnitOfMeasure = UOMTextBox.Text;
stationery.CategoryID = Convert.ToInt32(CategoryDDL.SelectedValue);
stationery.LocationID = Convert.ToInt32(LocationDDL.SelectedValue);
stationery.ReorderLevel = Convert.ToInt32(ReorderLevelTextBox.Text);
stationery.ReorderQuantity = Convert.ToInt32(ReorderQtyTextBox.Text);
stationery.CreatedBy = Utilities.Membership.GetCurrentLoggedInUser().UserID;
stationery.ModifiedBy = Utilities.Membership.GetCurrentLoggedInUser().UserID;
stationery.DateCreated = DateTime.Now;
stationery.DateModified = DateTime.Now;
stationery.IsApproved = false;
stationeryPrice[0] = new StationeryPrice();
stationeryPrice[0].SupplierID = Convert.ToInt32(Supplier1DDL.SelectedValue);
stationeryPrice[0].Price = Convert.ToInt32(Price1TextBox.Text);
stationeryPrice[1] = new StationeryPrice();
stationeryPrice[1].SupplierID = Convert.ToInt32(Supplier2DDL.SelectedValue);
stationeryPrice[1].Price = Convert.ToInt32(Price2TextBox.Text);
stationeryPrice[2] = new StationeryPrice();
stationeryPrice[2].SupplierID = Convert.ToInt32(Supplier3DDL.SelectedValue);
stationeryPrice[2].Price = Convert.ToInt32(Price3TextBox.Text);
try
{
Stationery temp = Manager.CreateStationery(stationery);
foreach (StationeryPrice st in stationeryPrice)
{
st.StationeryID = temp.StationeryID;
Manager.CreateStationeryPrice(st);
}
}
catch (Exception)
{
ErrorLabel.Text = "Create Stationery Failed";
}
}
public Stationery UpdateStationery(Stationery stationery)
{
try
{
Stationery tempStationery = (from s in context.Stationeries
where s.StationeryID == stationery.StationeryID
select s).FirstOrDefault<Stationery>();
tempStationery.CategoryID = stationery.CategoryID;
tempStationery.LocationID = stationery.LocationID;
tempStationery.ItemCode = stationery.ItemCode;
tempStationery.Description = stationery.Description;
tempStationery.ReorderLevel = stationery.ReorderLevel;
tempStationery.ReorderQuantity = stationery.ReorderQuantity;
tempStationery.DateModified = stationery.DateModified;
tempStationery.ModifiedByUser = stationery.ModifiedByUser;
tempStationery.UnitOfMeasure = stationery.UnitOfMeasure;
tempStationery.IsApproved = stationery.IsApproved;
tempStationery.QuantityInHand = stationery.QuantityInHand;
using (TransactionScope ts = new TransactionScope())
{
context.SaveChanges();
ts.Complete();
return tempStationery;
}
}
catch (Exception)
{
throw;
}
}
public void DeleteStationery(Stationery stationery)
{
try
{
Stationery persistedStationery = (from s in context.Stationeries
where s.StationeryID == stationery.StationeryID
select s).First<Stationery>();
List<StationeryPrice> spList = GetAllStationeryPrices().Where(x => x.StationeryID == persistedStationery.StationeryID).ToList<StationeryPrice>();
using (TransactionScope ts = new TransactionScope())
{
foreach (StationeryPrice temp in spList)
{
context.StationeryPrices.DeleteObject(temp);
}
context.Stationeries.DeleteObject(persistedStationery);
context.SaveChanges();
ts.Complete();
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Deprecated Method for adding a new object to the Stationeries EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToStationeries(Stationery stationery)
{
base.AddObject("Stationeries", stationery);
}
/// <summary>
/// Create a new Stationery object.
/// </summary>
/// <param name="stationeryID">Initial value of the StationeryID property.</param>
/// <param name="categoryID">Initial value of the CategoryID property.</param>
/// <param name="locationID">Initial value of the LocationID property.</param>
/// <param name="itemCode">Initial value of the ItemCode property.</param>
/// <param name="description">Initial value of the Description property.</param>
/// <param name="reorderLevel">Initial value of the ReorderLevel property.</param>
/// <param name="reorderQuantity">Initial value of the ReorderQuantity property.</param>
/// <param name="quantityInHand">Initial value of the QuantityInHand property.</param>
/// <param name="dateCreated">Initial value of the DateCreated property.</param>
/// <param name="dateModified">Initial value of the DateModified property.</param>
/// <param name="createdBy">Initial value of the CreatedBy property.</param>
/// <param name="modifiedBy">Initial value of the ModifiedBy property.</param>
/// <param name="isApproved">Initial value of the IsApproved property.</param>
/// <param name="unitOfMeasure">Initial value of the UnitOfMeasure property.</param>
public static Stationery CreateStationery(global::System.Int32 stationeryID, global::System.Int32 categoryID, global::System.Int32 locationID, global::System.String itemCode, global::System.String description, global::System.Int32 reorderLevel, global::System.Int32 reorderQuantity, global::System.Int32 quantityInHand, global::System.DateTime dateCreated, global::System.DateTime dateModified, global::System.Int32 createdBy, global::System.Int32 modifiedBy, global::System.Boolean isApproved, global::System.String unitOfMeasure)
{
Stationery stationery = new Stationery();
stationery.StationeryID = stationeryID;
stationery.CategoryID = categoryID;
stationery.LocationID = locationID;
stationery.ItemCode = itemCode;
stationery.Description = description;
stationery.ReorderLevel = reorderLevel;
stationery.ReorderQuantity = reorderQuantity;
stationery.QuantityInHand = quantityInHand;
stationery.DateCreated = dateCreated;
stationery.DateModified = dateModified;
stationery.CreatedBy = createdBy;
stationery.ModifiedBy = modifiedBy;
stationery.IsApproved = isApproved;
stationery.UnitOfMeasure = unitOfMeasure;
return stationery;
}
public Stationery UpdateStationery(Stationery stationery)
{
try
{
if (stationery != null)
{
stationery.DateModified = DateTime.Now;
catalogDAO.UpdateStationery(stationery);
}
}
catch (Exception)
{
throw new Exceptions.UserException("Catalog stationery updating failed.");
}
return stationery;
}
public void DeleteStationery(Stationery stationery)
{
try
{
if (stationery != null)
{
catalogDAO.DeleteStationery(stationery);
}
}
catch (Exception)
{
//throw new Exceptions.UserException("Catalog stationery deletion failed.");
}
}
public Stationery CreateStationery(Stationery stationery)
{
try
{
if (stationery != null)
{
stationery.DateCreated = DateTime.Now;
catalogDAO.CreateStationery(stationery);
}
}
catch (Exception)
{
throw new Exceptions.UserException("Catalog stationery creation failed.");
}
return stationery;
}