//CRUD for PurchaseOrder
public PurchaseOrder CreatePurchaseOrder(PurchaseOrder po)
{
bool isValid = false;
PurchaseOrder purchaseOrder = new PurchaseOrder();
try
{
if (ValidatePurchaseOrder(po, PurchaseOrderMethod.Create))
{
foreach (PurchaseOrderItem item in po.PurchaseOrderItems)
{
isValid = ValidatePurchaseOrderItem(item, PurchaseOrderMethod.Create);
if (!isValid)
break;
}
if (isValid)
{
purchaseOrder = purchaseOrderDAO.CreatePurchaseOrder(po);
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
return purchaseOrder;
}
// create Purchase Order and together with Purchase Order Items
protected void btnSubmit_Click(object sender, EventArgs e)
{
//justify how many suppliers involed
List<Supplier> suppliers = SupplierInvolved();
using (PurchaseOrderManager pom = new PurchaseOrderManager())
{
foreach (Supplier s in suppliers)
{
PurchaseOrder purchaseOrder = new PurchaseOrder();
purchaseOrder.PONumber = pom.CreatePONumber();
purchaseOrder.DateOfOrder = DateTime.Now;
purchaseOrder.AttentionTo = Convert.ToInt32(ddlAttentionTo.SelectedValue);
purchaseOrder.CreatedBy = Membership.GetCurrentLoggedInUser().UserID;
purchaseOrder.IsDelivered = false;
DateTimeFormatInfo dtfi = new DateTimeFormatInfo();
dtfi.ShortDatePattern = "MM/dd/yyyy";
dtfi.DateSeparator = "/";
purchaseOrder.DateToSupply = Convert.ToDateTime(txtDateToSupply.Text, dtfi);
purchaseOrder.SupplierID = s.SupplierID;
foreach (GridViewRow r in gvPOItems.Rows)
{
if (Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue.ToString()) == s.SupplierID)
{
PurchaseOrderItem item = new PurchaseOrderItem();
item.PurchaseOrder = purchaseOrder;
item.StationeryID = (int)gvPOItems.DataKeys[r.RowIndex].Value;
//item.QuantityToOrder = 5;
item.QuantityToOrder = Convert.ToInt32(((TextBox)r.FindControl("txtRecommend")).Text.ToString());
using (CatalogManager cm = new CatalogManager())
{
StationeryPriceSearchDTO criteria = new StationeryPriceSearchDTO();
criteria.SupplierID = Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue.ToString());
criteria.StationeryID = (int)item.StationeryID;
item.Price = cm.FindStationeryPricesByCriteria(criteria)[0].Price;
// record supplier ID for the PO
purchaseOrder.SupplierID = criteria.SupplierID;
}
purchaseOrder.PurchaseOrderItems.Add(item); // only this way works
}
}
pom.CreatePurchaseOrder(purchaseOrder);
}
}
}
public void DeletePurchaseOrder(PurchaseOrder purchaseOrder)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
this.context.PurchaseOrders.Attach(purchaseOrder);
this.context.PurchaseOrders.DeleteObject(purchaseOrder);
this.context.SaveChanges();
ts.Complete();
}
}
catch (Exception)
{
throw;
}
}
public PurchaseOrder CreatePurchaseOrder(PurchaseOrder purchaseOrder)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
this.context.PurchaseOrders.AddObject(purchaseOrder);
this.context.SaveChanges();
ts.Complete();
return purchaseOrder;
}
}
catch (Exception)
{
throw;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
List<Supplier> suppliers = SupplierInvolved();
using (PurchaseOrderManager pom = new PurchaseOrderManager())
{
foreach (Supplier s in suppliers)
{
PurchaseOrder purchaseOrder = new PurchaseOrder();
purchaseOrder.PONumber = pom.CreatePONumber();
purchaseOrder.DateOfOrder = DateTime.Now;
purchaseOrder.AttentionTo = Convert.ToInt32(ddlAttentionTo.SelectedValue);
purchaseOrder.CreatedBy = Membership.GetCurrentLoggedInUser().UserID;
purchaseOrder.IsDelivered = false;
DateTimeFormatInfo dtfi = new DateTimeFormatInfo();
dtfi.ShortDatePattern = "MM/dd/yyyy";
dtfi.DateSeparator = "/";
purchaseOrder.DateToSupply = Convert.ToDateTime(txtDateToSupply.Text, dtfi);
purchaseOrder.SupplierID = s.SupplierID;
foreach (GridViewRow r in gvPOItems.Rows)
{
if (Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue.ToString()) == s.SupplierID)
{
PurchaseOrderItem item = new PurchaseOrderItem();
item.PurchaseOrder = purchaseOrder;
item.SpecialStationeryID = (int)gvPOItems.DataKeys[r.RowIndex].Value;
item.QuantityToOrder = Convert.ToInt32(((TextBox)r.FindControl("txtOrderQuantity")).Text.ToString());
item.Price = 5.0m;
purchaseOrder.SupplierID = Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue);
purchaseOrder.PurchaseOrderItems.Add(item); // only this way works
}
}
pom.CreatePurchaseOrder(purchaseOrder);
}
}
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
PurchaseOrderDAO poDAO = new PurchaseOrderDAO();
PurchaseOrder po = new PurchaseOrder();
DateTime t1 = new DateTime(2010, 12, 12);
DateTime t2 = new DateTime(2010, 12, 20);
po.SupplierID = 2;
po.PONumber = "90000";
po.DateOfOrder = t1;
po.DateToSupply = t2;
po.AttentionTo = 2;
po.CreatedBy = 2;
po.DateReceived = t2;
po.IsDelivered = false;
PurchaseOrderItem poitem1 = new PurchaseOrderItem();
po.PurchaseOrderItems.Add(poitem1);
PurchaseOrder savedPO = poDAO.CreatePurchaseOrder(po);
//savedPO.PurchaseOrderID
List<PurchaseOrderItem> poitems = savedPO.PurchaseOrderItems.ToList<PurchaseOrderItem>();
//poitems[0].PurchaseOrderItemID
}
public PurchaseOrder UpdatePurchaseOrder(PurchaseOrder purchaseOrder)
{
try
{
PurchaseOrder purchaseOrderTemp = (from p in context.PurchaseOrders
where p.PurchaseOrderID == purchaseOrder.PurchaseOrderID
select p).FirstOrDefault();
if (purchaseOrderTemp != null)
{
purchaseOrderTemp.PONumber = purchaseOrder.PONumber;
purchaseOrderTemp.ReceivedBy = purchaseOrder.ReceivedBy;
purchaseOrderTemp.AttentionTo = purchaseOrder.AttentionTo;
purchaseOrderTemp.CreatedBy = purchaseOrder.CreatedBy;
purchaseOrderTemp.DateOfOrder = purchaseOrder.DateOfOrder;
purchaseOrderTemp.DateReceived = purchaseOrder.DateReceived;
purchaseOrderTemp.DONumber = purchaseOrder.DONumber;
purchaseOrderTemp.SupplierID = purchaseOrder.SupplierID;
purchaseOrderTemp.IsDelivered = purchaseOrder.IsDelivered;
purchaseOrderTemp.PurchaseOrderID = purchaseOrder.PurchaseOrderID;
// add more properties here
}
using (TransactionScope ts = new TransactionScope())
{
this.context.SaveChanges();
ts.Complete();
return purchaseOrder;
}
}
catch (Exception)
{
throw;
}
}
// validate puchase order
private bool ValidatePurchaseOrder(PurchaseOrder purchaseOrder, PurchaseOrderMethod purchaseOrderMethod)
{
string errMsg = "";
try
{
if (purchaseOrder != null)
{
if (purchaseOrderMethod == PurchaseOrderMethod.Create)
{
errMsg = "Create Purchase Order failed. Please try again later";
if ((purchaseOrder.AttentionTo != 0 || purchaseOrder.AttentionToUser != null) &&
(purchaseOrder.CreatedBy != 0 || purchaseOrder.CreatedByUser != null) &&
(purchaseOrder.SupplierID != 0 || purchaseOrder.Supplier != null) &&
(purchaseOrder.PurchaseOrderItems != null) &&
(purchaseOrder.DateToSupply != null && DateTime.Compare(purchaseOrder.DateToSupply, DateTime.Now) >= 0) &&
(purchaseOrder.DateOfOrder != null && purchaseOrder.DateOfOrder.Date.ToShortDateString() == DateTime.Now.Date.ToShortDateString()))
{
return true;
}
}
if (purchaseOrderMethod == PurchaseOrderMethod.Update)
{
errMsg = "Update Purchase Order failed. Please try again later";
if ((purchaseOrder.AttentionTo != 0 || purchaseOrder.AttentionToUser != null) &&
(purchaseOrder.CreatedBy != 0 || purchaseOrder.CreatedByUser != null) &&
(purchaseOrder.SupplierID != 0 || purchaseOrder.Supplier != null) &&
(purchaseOrder.PurchaseOrderItems != null) &&
(purchaseOrder.DateToSupply != null) &&
(purchaseOrder.DateOfOrder != null))
{
return true;
}
}
}
return false;
}
catch (Exception)
{
throw new PurchaseOrderException(errMsg);
}
}
public void DeletePurchaseOrder(PurchaseOrder po)
{
purchaseOrderDAO.DeletePurchaseOrder(po);
}
/// <summary>
/// Deprecated Method for adding a new object to the PurchaseOrders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPurchaseOrders(PurchaseOrder purchaseOrder)
{
base.AddObject("PurchaseOrders", purchaseOrder);
}
/// <summary>
/// Create a new PurchaseOrder object.
/// </summary>
/// <param name="purchaseOrderID">Initial value of the PurchaseOrderID property.</param>
/// <param name="pONumber">Initial value of the PONumber property.</param>
/// <param name="dateOfOrder">Initial value of the DateOfOrder property.</param>
/// <param name="attentionTo">Initial value of the AttentionTo property.</param>
/// <param name="createdBy">Initial value of the CreatedBy property.</param>
/// <param name="supplierID">Initial value of the SupplierID property.</param>
/// <param name="isDelivered">Initial value of the IsDelivered property.</param>
/// <param name="dateToSupply">Initial value of the DateToSupply property.</param>
public static PurchaseOrder CreatePurchaseOrder(global::System.Int32 purchaseOrderID, global::System.String pONumber, global::System.DateTime dateOfOrder, global::System.Int32 attentionTo, global::System.Int32 createdBy, global::System.Int32 supplierID, global::System.Boolean isDelivered, global::System.DateTime dateToSupply)
{
PurchaseOrder purchaseOrder = new PurchaseOrder();
purchaseOrder.PurchaseOrderID = purchaseOrderID;
purchaseOrder.PONumber = pONumber;
purchaseOrder.DateOfOrder = dateOfOrder;
purchaseOrder.AttentionTo = attentionTo;
purchaseOrder.CreatedBy = createdBy;
purchaseOrder.SupplierID = supplierID;
purchaseOrder.IsDelivered = isDelivered;
purchaseOrder.DateToSupply = dateToSupply;
return purchaseOrder;
}
