private void InitPurshaseOrderValues(string selectedCustomerAccount, string iputProductNumber, Resources context)
{
//Purchase Order Header
PurchaseOrderHeader purchaseOrder = new PurchaseOrderHeader();
DataServiceCollection <PurchaseOrderHeader> purchaseOrderCollection = new DataServiceCollection <PurchaseOrderHeader>(context);
purchaseOrderCollection.Add(purchaseOrder);
purchaseOrder.CurrencyCode = "USD";
purchaseOrder.PurchaseOrderNumber = ImputOrderNumber;
purchaseOrder.InvoiceVendorAccountNumber = selectedCustomerAccount;
purchaseOrder.OrderVendorAccountNumber = selectedCustomerAccount;
purchaseOrder.LanguageId = "en-us";
purchaseOrder.dataAreaId = "USMF";
//Purchase Order Line
PurchaseOrderLine purchaseOrderLine = new PurchaseOrderLine();
DataServiceCollection <PurchaseOrderLine> purchaseOrderLineCollection = new DataServiceCollection <PurchaseOrderLine>(context);
purchaseOrderLineCollection.Add(purchaseOrderLine);
purchaseOrderLine.PurchaseOrderNumber = ImputOrderNumber;
purchaseOrderLine.ItemNumber = iputProductNumber;
purchaseOrderLine.OrderedPurchaseQuantity = ImputOrderQuantity;
purchaseOrderLine.dataAreaId = "USMF";
}
///<summary>
/// Returns a Typed PurchaseOrderDetail Entity with mock values.
///</summary>
static public PurchaseOrderDetail CreateMockInstance_Generated(TransactionManager tm)
{
PurchaseOrderDetail mock = new PurchaseOrderDetail();
mock.DueDate = TestUtility.Instance.RandomDateTime();
mock.OrderQty = TestUtility.Instance.RandomShort();
mock.UnitPrice = TestUtility.Instance.RandomShort();
mock.ReceivedQty = (decimal)TestUtility.Instance.RandomShort();
mock.RejectedQty = (decimal)TestUtility.Instance.RandomShort();
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
Product mockProductByProductId = ProductTest.CreateMockInstance(tm);
DataRepository.ProductProvider.Insert(tm, mockProductByProductId);
mock.ProductId = mockProductByProductId.ProductId;
//OneToOneRelationship
PurchaseOrderHeader mockPurchaseOrderHeaderByPurchaseOrderId = PurchaseOrderHeaderTest.CreateMockInstance(tm);
DataRepository.PurchaseOrderHeaderProvider.Insert(tm, mockPurchaseOrderHeaderByPurchaseOrderId);
mock.PurchaseOrderId = mockPurchaseOrderHeaderByPurchaseOrderId.PurchaseOrderId;
// create a temporary collection and add the item to it
TList <PurchaseOrderDetail> tempMockCollection = new TList <PurchaseOrderDetail>();
tempMockCollection.Add(mock);
tempMockCollection.Remove(mock);
return((PurchaseOrderDetail)mock);
}
public Error AttachNoteToPurchaseOrder(PurchaseOrderHeader poh, UserModel sender,
string subject, string message,
List <string> attachments,
FileCopyType copyType)
{
var error = new Error();
var note = new NoteModel {
CompanyId = poh.CompanyId,
NoteType = NoteType.Purchase,
ParentId = poh.Id,
CreatedById = sender.Id,
Subject = subject,
Message = message
};
InsertOrUpdateNote(note, sender, "");
error.Id = note.Id;
foreach (var attachment in attachments)
{
AttachMediaItemToNote(note, sender, attachment, attachment.FileName(), copyType);
}
return(error);
}
private FileTransferConfigurationModel getFileTransferConfigurationModel(PurchaseOrderHeader poh,
FileRecipient fileRecipient)
{
FileTransferConfigurationModel template = null;
switch (fileRecipient)
{
case FileRecipient.Warehouse:
LocationModel warehouse = null;
if (poh.LocationId != null)
{
warehouse = LookupService.FindLocationModel(poh.LocationId.Value, false);
}
if (warehouse != null)
{
template = DataTransferService.FindFileTransferConfigurationForWarehouseModel(warehouse, FileTransferDataType.WarehousePurchase);
}
break;
case FileRecipient.FreightForwarder:
FreightForwarderModel freightForwarder = null;
if (poh.FreightForwarderId != null)
{
freightForwarder = LookupService.FindFreightForwarderModel(poh.FreightForwarderId.Value, false);
}
if (freightForwarder != null)
{
template = DataTransferService.FindFileTransferConfigurationForFreightForwarder(freightForwarder, FileTransferDataType.FreightForwarderPurchase);
}
break;
}
return(template);
}
public static PurchaseOrderHeader OrderToHeader(OrderData od)
{
PurchaseOrderHeader poh = new PurchaseOrderHeader();
poh.RevisionNumber = 4;
poh.Status = od.Status;
if (uow.SalesPerson.GetAll().Where(x => x.TerritoryID == od.TerritoryID) == null)
{
poh.EmployeeID = uow.SalesPerson.GetAll().OrderBy(y => y.SalesLastYear).First().BusinessEntityID;
}
else
{
poh.EmployeeID = uow.SalesPerson.GetAll().Where(x => x.TerritoryID == od.TerritoryID).OrderBy(y => y.SalesLastYear).First().BusinessEntityID;
}
poh.VendorID = 1580;
poh.ShipMethodID = 3;
poh.OrderDate = DateTime.Now;
poh.SubTotal = od.SubTotal;
poh.TaxAmt = od.SubTotal * (8 / 100);
poh.Freight = 100;
poh.TotalDue = poh.SubTotal + poh.TaxAmt + poh.Freight;
poh.ModifiedDate = DateTime.Now;
poh.CustomerID = od.CustomerID;
return(poh);
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
PurchaseOrderHeader mock = CreateMockInstance(tm);
bool result = DataRepository.PurchaseOrderHeaderProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
PurchaseOrderHeaderQuery query = new PurchaseOrderHeaderQuery();
query.AppendEquals(PurchaseOrderHeaderColumn.PurchaseOrderId, mock.PurchaseOrderId.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.RevisionNumber, mock.RevisionNumber.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.Status, mock.Status.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.EmployeeId, mock.EmployeeId.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.VendorId, mock.VendorId.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.ShipMethodId, mock.ShipMethodId.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.OrderDate, mock.OrderDate.ToString());
if (mock.ShipDate != null)
{
query.AppendEquals(PurchaseOrderHeaderColumn.ShipDate, mock.ShipDate.ToString());
}
query.AppendEquals(PurchaseOrderHeaderColumn.SubTotal, mock.SubTotal.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.TaxAmt, mock.TaxAmt.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.Freight, mock.Freight.ToString());
query.AppendEquals(PurchaseOrderHeaderColumn.ModifiedDate, mock.ModifiedDate.ToString());
TList <PurchaseOrderHeader> results = DataRepository.PurchaseOrderHeaderProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public static void AcknowledgePurchaseOrder(PurchaseOrderHeader header, Collection <PurchaseOrderItemSchedule> schedules)
{
try
{
EpTransaction tran = DataManager.BeginTransaction();
try
{
PurchaseOrderHeaderDAO.Update(tran, header);
foreach (PurchaseOrderItemSchedule schedule in schedules)
{
PurchaseOrderItemScheduleDAO.Update(tran, schedule);
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw (ex);
}
finally
{
tran.Dispose();
}
}
catch (Exception ex)
{
Utility.ExceptionLog(ex);
throw (ex);
}
}
public ActionResult SaveOrder(Models.ViewModels.Purchases.PurchaseHeaderViewModel model)
{
PurchaseOrderHeader order = null;
if (model.Id.HasValue == false || model.Id == 0)
{
order = new PurchaseOrderHeader();
}
else
{
order = _purchasingService.GetPurchaseOrderById(model.Id.Value);
}
order.VendorId = model.VendorId.Value;
order.Date = model.Date;
order.Description = string.Empty;
foreach (var line in model.PurchaseLine.PurchaseLineItems)
{
var item = _inventoryService.GetItemById(line.ItemId);
order.PurchaseOrderLines.Add(new PurchaseOrderLine()
{
Amount = line.Price,
ItemId = item.Id,
Quantity = line.Quantity,
MeasurementId = item.PurchaseMeasurementId.Value,
Cost = item.Cost.Value,
});
}
_purchasingService.AddPurchaseOrder(order, true);
return(RedirectToAction("PurchaseOrders"));
}
/// <summary>
/// Deep load all PurchaseOrderHeader children.
/// </summary>
private void Step_03_DeepLoad_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
int count = -1;
mock = CreateMockInstance(tm);
mockCollection = DataRepository.PurchaseOrderHeaderProvider.GetPaged(tm, 0, 10, out count);
DataRepository.PurchaseOrderHeaderProvider.DeepLoading += new EntityProviderBaseCore <PurchaseOrderHeader, PurchaseOrderHeaderKey> .DeepLoadingEventHandler(
delegate(object sender, DeepSessionEventArgs e)
{
if (e.DeepSession.Count > 3)
{
e.Cancel = true;
}
}
);
if (mockCollection.Count > 0)
{
DataRepository.PurchaseOrderHeaderProvider.DeepLoad(tm, mockCollection[0]);
System.Console.WriteLine("PurchaseOrderHeader instance correctly deep loaded at 1 level.");
mockCollection.Add(mock);
// DataRepository.PurchaseOrderHeaderProvider.DeepSave(tm, mockCollection);
}
//normally one would commit here
//tm.Commit();
//IDisposable will Rollback Transaction since it's left uncommitted
}
}
public OrderData(PurchaseOrderHeader poh)
{
UOWCatalog uow = new UOWCatalog();
this.Status = poh.Status;
this.EmployeeID = poh.EmployeeID;
this.SubTotal = poh.SubTotal;
this.ModifiedDate = poh.ModifiedDate;
this.CustomerID = poh.CustomerID;
this.OrderProducts = new List <CartLine>();
foreach (var pod in poh.PurchaseOrderDetail)
{
ProductData pd = new ProductData(uow.Product.Get(pod.ProductID));
CartLine cl = new CartLine();
cl.Product = pd;
cl.Quantity = pod.OrderQty;
this.OrderProducts.Add(cl);
}
if (poh.Customer == null)
{
this.TerritoryID = null;
}
else
{
this.TerritoryID = poh.Customer.TerritoryID;
}
}
public DataTable SelectAll(PurchaseOrderHeader objPurchaseOrderHeader)
{
DataSet ds = new DataSet();
SqlDataAdapter da;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "PurchaseOrderHeader_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
}
catch (Exception ex)
{
////ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(ds.Tables[0]);
}
public bool UpdatePurchaseOrderHeader(PurchaseOrderHeader purchaseOrderHeader)
{
IDBManager dbm = new DBManager();
try
{
dbm.CreateParameters(13);
dbm.AddParameters(0, "@PurchaseOrderID", purchaseOrderHeader.PurchaseOrderID);
dbm.AddParameters(1, "@RevisionNumber", purchaseOrderHeader.RevisionNumber);
dbm.AddParameters(2, "@Status", purchaseOrderHeader.Status);
dbm.AddParameters(3, "@EmployeeID", purchaseOrderHeader.EmployeeID);
dbm.AddParameters(4, "@VendorID", purchaseOrderHeader.VendorID);
dbm.AddParameters(5, "@ShipMethodID", purchaseOrderHeader.ShipMethodID);
dbm.AddParameters(6, "@OrderDate", purchaseOrderHeader.OrderDate);
dbm.AddParameters(7, "@ShipDate", purchaseOrderHeader.ShipDate);
dbm.AddParameters(8, "@SubTotal", purchaseOrderHeader.SubTotal);
dbm.AddParameters(9, "@TaxAmt", purchaseOrderHeader.TaxAmt);
dbm.AddParameters(10, "@Freight", purchaseOrderHeader.Freight);
dbm.AddParameters(11, "@TotalDue", purchaseOrderHeader.TotalDue);
dbm.AddParameters(12, "@ModifiedDate", DateTime.Now);
dbm.ExecuteNonQuery(CommandType.StoredProcedure, "UpdatePurchaseOrderHeader");
}
catch (Exception ex)
{
log.Write(ex.Message, "UpdatePurchaseOrderHeader");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(true);
}
public bool PurchaseOrderHeaderUpdate(PurchaseOrderHeader purchaseorderheader)
{
return(Execute <bool>(dal =>
{
PurchaseOrderHeader purchaseorderheaderUpdate = dal.PurchaseOrderHeader.Where(x => x.PurchaseOrderID == purchaseorderheader.PurchaseOrderID).FirstOrDefault();
if (purchaseorderheaderUpdate != null)
{
purchaseorderheaderUpdate.PurchaseOrderID = purchaseorderheader.PurchaseOrderID;
purchaseorderheaderUpdate.RevisionNumber = purchaseorderheader.RevisionNumber;
purchaseorderheaderUpdate.Status = purchaseorderheader.Status;
purchaseorderheaderUpdate.EmployeeID = purchaseorderheader.EmployeeID;
purchaseorderheaderUpdate.VendorID = purchaseorderheader.VendorID;
purchaseorderheaderUpdate.ShipMethodID = purchaseorderheader.ShipMethodID;
purchaseorderheaderUpdate.OrderDate = purchaseorderheader.OrderDate;
purchaseorderheaderUpdate.ShipDate = purchaseorderheader.ShipDate;
purchaseorderheaderUpdate.SubTotal = purchaseorderheader.SubTotal;
purchaseorderheaderUpdate.TaxAmt = purchaseorderheader.TaxAmt;
purchaseorderheaderUpdate.Freight = purchaseorderheader.Freight;
purchaseorderheaderUpdate.TotalDue = purchaseorderheader.TotalDue;
purchaseorderheaderUpdate.ModifiedDate = purchaseorderheader.ModifiedDate;
dal.SubmitChanges();
return true;
}
return false;
}));
}
///<summary>
/// Update the Typed PurchaseOrderHeader Entity with modified mock values.
///</summary>
static public void UpdateMockInstance(TransactionManager tm, PurchaseOrderHeader mock)
{
PurchaseOrderHeaderTest.UpdateMockInstance_Generated(tm, mock);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
}
public void AddPurchaseOrder(PurchaseOrderHeader purchaseOrder, bool toSave)
{
purchaseOrder.No = GetNextNumber(SequenceNumberTypes.PurchaseOrder).ToString();
if (toSave)
{
_purchaseOrderRepo.Insert(purchaseOrder);
}
}
/// <summary>
/// Test methods exposed by the EntityHelper class.
/// </summary>
private void Step_20_TestEntityHelper_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
PurchaseOrderHeader entity = mock.Copy() as PurchaseOrderHeader;
entity = (PurchaseOrderHeader)mock.Clone();
Assert.IsTrue(PurchaseOrderHeader.ValueEquals(entity, mock), "Clone is not working");
}
}
///<summary>
/// Returns a Typed PurchaseOrderHeader Entity with mock values.
///</summary>
static public PurchaseOrderHeader CreateMockInstance(TransactionManager tm)
{
// get the default mock instance
PurchaseOrderHeader mock = PurchaseOrderHeaderTest.CreateMockInstance_Generated(tm);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
// return the modified object
return(mock);
}
//[ValidateAntiForgeryToken]
public ActionResult PriorityUpdate(int Id, string Priority)
{
if (ModelState.IsValid)
{
List<LogTypeViewModel> LogList = new List<LogTypeViewModel>();
PurchaseOrderHeader Head = db.PurchaseOrderHeader.Find(Id);
PurchaseOrderHeader ExRec = Mapper.Map<PurchaseOrderHeader>(Head);
int t = (int)Enum.Parse(typeof(SaleOrderPriority), Priority);
Head.Priority = t;
Head.ModifiedBy = User.Identity.Name;
Head.ModifiedDate = DateTime.Now;
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = Head,
});
Head.ObjectState = Model.ObjectState.Modified;
db.PurchaseOrderHeader.Add(Head);
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return Json(new { Success = false });
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Head.DocTypeId,
DocId = Head.PurchaseOrderHeaderId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = Head.DocNo,
DocDate = Head.DocDate,
DocStatus = Head.Status,
xEModifications = Modifications,
}));
return Json(new { Success = true });
}
return Json(new { Success = false });
}
public Int64 Update(PurchaseOrderHeader objorders)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "PurchaseOrderHeader_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@oid";
param.Value = objorders.oid;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@uid", objorders.uid);
cmd.Parameters.AddWithValue("@invoicetype", objorders.invoicetype);
cmd.Parameters.AddWithValue("@invoiceno", objorders.invoiceno);
cmd.Parameters.AddWithValue("@orderdate", objorders.orderdate);
cmd.Parameters.AddWithValue("@accountYear", objorders.accountYear);
cmd.Parameters.AddWithValue("@subtotal", objorders.subtotal);
cmd.Parameters.AddWithValue("@discandScheme", objorders.discandScheme);
cmd.Parameters.AddWithValue("@frieghtamount", objorders.frieghtamount);
cmd.Parameters.AddWithValue("@taxableamount", objorders.taxableamount);
cmd.Parameters.AddWithValue("@CGSTamt", objorders.CGSTamt);
cmd.Parameters.AddWithValue("@SGSTamt", objorders.SGSTamt);
cmd.Parameters.AddWithValue("@IGSTamt", objorders.IGSTamt);
cmd.Parameters.AddWithValue("@totalAmt", objorders.totalAmt);
cmd.Parameters.AddWithValue("@transportamt", objorders.transportamt);
cmd.Parameters.AddWithValue("@packingamt", objorders.packingamt);
cmd.Parameters.AddWithValue("@otheramt", objorders.otheramt);
cmd.Parameters.AddWithValue("@grandtotal", objorders.grandtotal);
cmd.Parameters.AddWithValue("@pendingAmt", objorders.pendingAmt);
cmd.Parameters.AddWithValue("@stockdate", objorders.stockdate);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
// PUT api/awbuildversion/5
public void Put(PurchaseOrderHeader value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
adventureWorks_BC.PurchaseOrderHeaderDelete(value);
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
adventureWorks_BC.PurchaseOrderHeaderUpdate(value);
}
}
/// <summary>
/// Check the foreign key dal methods.
/// </summary>
private void Step_10_FK_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
PurchaseOrderHeader entity = CreateMockInstance(tm);
bool result = DataRepository.PurchaseOrderHeaderProvider.Insert(tm, entity);
Assert.IsTrue(result, "Could Not Test FK, Insert Failed");
TList <PurchaseOrderHeader> t1 = DataRepository.PurchaseOrderHeaderProvider.GetByShipMethodId(tm, entity.ShipMethodId, 0, 10);
}
}
/// <summary>
/// Saves the order detail.
/// </summary>
/// <param name="header">The header.</param>
private void SaveOrderDetail(PurchaseOrderHeader header)
{
foreach (DataGridViewRow rows in this.dgvDetailsList.Rows)
{
bool result = true;
//// 判断detailid 和 productid 是否为空，不为空才执行 保存/删除 操作
if (DAL.Common.Utility.IsGUID(rows.Cells[0].Value.ToString()) && DAL.Common.Utility.IsGUID(rows.Cells[8].Value.ToString()))
{
System.Guid detailId = Purchasing.PurchasingUtils.Convert.ToGuid(rows.Cells[0].Value.ToString());
PurchaseOrderDetails objDetail = PurchaseOrderDetails.Load(detailId);
DAL.Workplace workplace = DAL.Workplace.Load(header.WorkplaceId);
if (objDetail == null)
{
objDetail = new PurchaseOrderDetails();
objDetail.OrderHeaderId = header.OrderHeaderId;
this.orderHeaderId = header.OrderHeaderId;
objDetail.LineNumber = Purchasing.PurchasingUtils.Convert.ToInt32(rows.Cells[1].Value.ToString().Length == 0 ? "1" : rows.Cells[1].Value.ToString());
}
objDetail.ProductId = Purchasing.PurchasingUtils.Convert.ToGuid(rows.Cells[8].Value.ToString().Trim());
for (int i = 9; i <= 18; i++)
{
if (workplace.WorkplaceCode == this.dgvDetailsList.Columns[i].HeaderText && rows.Cells[i].Value.ToString() != "0")
{
objDetail.OrderedQty = Purchasing.PurchasingUtils.Convert.ToDecimal(rows.Cells[i].Value.ToString().Length == 0 ? "0" : rows.Cells[i].Value.ToString());
result = true;
break;
}
else
{
result = false;
}
}
objDetail.UnitCost = Purchasing.PurchasingUtils.Convert.ToDecimal(rows.Cells[7].Value.ToString().Length == 0 ? "0" : rows.Cells[7].Value.ToString());
objDetail.TotalQtyReceived = objDetail.OrderedQty * objDetail.UnitCost;
if (result)
{
if (rows.Cells[2].Value != null && rows.Cells[2].Value.ToString().Trim().ToUpper() == "REMOVED" && detailId != System.Guid.Empty)
{
objDetail.Delete();
}
else
{
objDetail.Save();
}
}
}
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
messageLabel.Text = String.Empty;
messageLabel.CssClass = "control-label";
try
{
PurchaseOrderHeader purchaseOrderHeader = new PurchaseOrderHeader();
int purchaseOrderID = int.Parse(purchaseOrderHeaderDropDownList.SelectedValue);
purchaseOrderHeader = Company.getPurchaseOrderHeader(purchaseOrderID);
purchaseOrderHeader.RevisionNumber = byte.Parse(revisionNumberTextBox.Text);
purchaseOrderHeader.Status = byte.Parse(statusTextBox.Text);
purchaseOrderHeader.EmployeeID = int.Parse(employeeDropDownList.SelectedValue);
//purchaseOrderHeader.OrderDate = orderDateCalendar.SelectedDate;
purchaseOrderHeader.setOrderAndShipDates(orderDateTextBox.Text, shipDateTextBox.Text);
DateTime ordDate = DateTime.Now.Date;
DateTime.TryParse(orderDateTextBox.Text, out ordDate);
purchaseOrderHeader.OrderDate = ordDate;
purchaseOrderHeader.ShipMethodID = int.Parse(shipperDropDownList.SelectedValue);
purchaseOrderHeader.SubTotal = decimal.Parse(subtotalLabel.Text);
purchaseOrderHeader.TaxAmt = decimal.Parse(taxLabel.Text);
purchaseOrderHeader.Freight = decimal.Parse(freightTextBox.Text);
DateTime shipDate = DateTime.Now.Date;
DateTime.TryParse(shipDateTextBox.Text, out shipDate);
purchaseOrderHeader.ShipDate = shipDate;
//if (shipppingDateCalendar.SelectedDates.Count > 0)
//{
// purchaseOrderHeader.ShipDate = shipppingDateCalendar.SelectedDate;
//}
int countChanges = Company.saveChanges();
if (countChanges > 0)
{
messageLabel.Text = "Update Sucessful!";
messageLabel.CssClass = "control-label text-success";
}
}
catch (Exception ex)
{
messageLabel.Text = ex.Message;
messageLabel.CssClass = "control-label text-danger";
}
}
public ActionResult Edit([Bind(Include = "PurchaseOrderID,RevisionNumber,Status,EmployeeID,VendorID,ShipMethodID,OrderDate,ShipDate,SubTotal,TaxAmt,Freight,TotalDue,ModifiedDate,isDeleted")] PurchaseOrderHeader purchaseOrderHeader)
{
if (ModelState.IsValid)
{
db.Entry(purchaseOrderHeader).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "BusinessEntityID", "NationalIDNumber", purchaseOrderHeader.EmployeeID);
ViewBag.ShipMethodID = new SelectList(db.ShipMethods, "ShipMethodID", "Name", purchaseOrderHeader.ShipMethodID);
ViewBag.VendorID = new SelectList(db.Vendors, "BusinessEntityID", "AccountNumber", purchaseOrderHeader.VendorID);
return(View(purchaseOrderHeader));
}
/// <summary>
/// Serialize the mock PurchaseOrderHeader entity into a temporary file.
/// </summary>
private void Step_06_SerializeEntity_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_PurchaseOrderHeader.xml");
EntityHelper.SerializeXml(mock, fileName);
Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock not found");
System.Console.WriteLine("mock correctly serialized to a temporary file.");
}
}
protected void fillPurchaseOrderControls(PurchaseOrderHeader purchaseOrderHeader)
{
this.revisionNumberTextBox.Text = purchaseOrderHeader.RevisionNumber.ToString();
this.statusTextBox.Text = purchaseOrderHeader.Status.ToString();
this.employeeDropDownList.SelectedValue = purchaseOrderHeader.EmployeeID.ToString();
//this.orderDateCalendar.SelectedDate = purchaseOrderHeader.OrderDate;
//this.orderDateCalendar.VisibleDate = purchaseOrderHeader.OrderDate;
orderDateTextBox.Text = purchaseOrderHeader.OrderDate.ToShortDateString();
//this.shipppingDateCalendar.SelectedDates.Clear();
//this.shipppingDateCalendar.VisibleDate = DateTime.Now;
//if (purchaseOrderHeader.ShipDate != null)
//{
// shipppingDateCalendar.SelectedDate = (DateTime)purchaseOrderHeader.ShipDate;
// shipppingDateCalendar.VisibleDate = (DateTime)purchaseOrderHeader.ShipDate;
//}
shipDateTextBox.Text = string.Empty;
if (purchaseOrderHeader.ShipDate != null)
{
shipDateTextBox.Text = ((DateTime)purchaseOrderHeader.ShipDate).ToShortDateString();
//shipppingDateCalendar.VisibleDate = (DateTime)purchaseOrderHeader.ShipDate;
}
// this.shipppingDateCalendar.SelectedDate = purchaseOrderHeader.OrderDate;
// this.shipppingDateCalendar.VisibleDate = purchaseOrderHeader.OrderDate;
this.shipperDropDownList.SelectedValue = purchaseOrderHeader.ShipMethodID.ToString();
// this.detailsLabel.Text = purchaseOrderHeader.PurchaseOrderDetails.ToString();
this.subtotalLabel.Text = purchaseOrderHeader.SubTotal.ToString("n2");
this.taxLabel.Text = purchaseOrderHeader.TaxAmt.ToString("n2");
this.freightTextBox.Text = purchaseOrderHeader.Freight.ToString("n2");
this.totalLabel.Text = (purchaseOrderHeader.SubTotal + purchaseOrderHeader.Freight + purchaseOrderHeader.TaxAmt).ToString("n2");
this.employeeImage.ImageUrl = PortalSettings.HomeDirectory
+ "empImages/emp"
+ purchaseOrderHeader.EmployeeID.ToString("000")
+ ".png";
// Enable Add OrderDetail Control (Plus (+) Sign)
Control headerTemplate = this.orderDetailsGridView.Controls[0].Controls[0];
HyperLink insertOrderDetailHyperLink = (HyperLink)headerTemplate.FindControl("insertOrderDetailHyperLink");
insertOrderDetailHyperLink.NavigateUrl =
"javascript:dnnModal.show('/Ex1E-Purchase-Order?popUp=true&poDetailID=-1&poID="
+ purchaseOrderHeader.PurchaseOrderID.ToString()
+ "&returnPath=/Ex1E-Purchase-Order',false,600,900,true)";
}
public bool PurchaseOrderHeaderDelete(PurchaseOrderHeader purchaseorderheader)
{
return(Execute <bool>(dal =>
{
PurchaseOrderHeader purchaseorderheaderDelete = dal.PurchaseOrderHeader.Where(x => x.PurchaseOrderID == purchaseorderheader.PurchaseOrderID).FirstOrDefault();
if (purchaseorderheaderDelete != null)
{
dal.PurchaseOrderHeader.DeleteOnSubmit(purchaseorderheaderDelete);
dal.SubmitChanges();
return true;
}
return false;
}));
}
public void MapEFToBOList()
{
var mapper = new DALPurchaseOrderHeaderMapper();
PurchaseOrderHeader entity = new PurchaseOrderHeader();
entity.SetProperties(1, 1m, DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1, 1m, 1m, 1m, 1);
List <BOPurchaseOrderHeader> response = mapper.MapEFToBO(new List <PurchaseOrderHeader>()
{
entity
});
response.Count.Should().Be(1);
}
// GET: PurchaseOrderHeaders/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseOrderHeader purchaseOrderHeader = db.PurchaseOrderHeaders.Find(id);
if (purchaseOrderHeader == null)
{
return(HttpNotFound());
}
return(View(purchaseOrderHeader));
}
public PurchaseOrderHeader SelectById(Int64 id)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
PurchaseOrderHeader objPurchaseOrderHeader = new PurchaseOrderHeader();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "PurchaseOrderHeader_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@PurchaseOrderId", id);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
//PurchaseOrderId, VendorId, isdeleted, OrderDate
objPurchaseOrderHeader.PurchaseOrderId = Convert.ToInt64(ds.Tables[0].Rows[0]["PurchaseOrderId"]);
objPurchaseOrderHeader.PONo = Convert.ToString(ds.Tables[0].Rows[0]["PONo"]);
objPurchaseOrderHeader.VendorId = Convert.ToInt64(ds.Tables[0].Rows[0]["VendorId"]);
objPurchaseOrderHeader.isdeleted = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isdeleted"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isdeleted"]);
objPurchaseOrderHeader.OrderDate = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["OrderDate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["OrderDate"]);
objPurchaseOrderHeader.orderstatus = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["orderstatus"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["orderstatus"]);
}
}
}
}
}
catch (Exception ex)
{
////ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objPurchaseOrderHeader);
}
public ActionResult SavePurchaseOrder(Models.ViewModels.Purchases.AddPurchaseOrder model)
{
var items = _inventoryService.GetAllItems();
var accounts = _financialService.GetAccounts();
var measurements = _inventoryService.GetMeasurements();
var taxes = _financialService.GetTaxes();
var itemCategories = _inventoryService.GetItemCategories();
var vendors = _purchasingService.GetVendors();
model.Items = Models.ModelViewHelper.Items(items);
model.Vendors = Models.ModelViewHelper.Vendors(vendors);
model.UnitOfMeasurements = Models.ModelViewHelper.Measurements(measurements);
try
{
var po = new PurchaseOrderHeader()
{
CreatedBy = User.Identity.Name,
CreatedOn = DateTime.Now,
ModifiedBy = User.Identity.Name,
ModifiedOn = DateTime.Now,
VendorId = model.VendorId,
Date = model.Date,
//No = _settingService.GetNextNumber(Core.Module.Common.Data.SequenceNumberTypes.PurchaseOrder).ToString(),
//DocumentTypeId = (int)DocumentTypes.PurchaseOrder
};
foreach (var item in model.PurchaseOrderLines)
{
var persistedItem = _inventoryService.GetItemById(item.ItemId);
po.PurchaseOrderLines.Add(new PurchaseOrderLine()
{
Amount = item.TotalLineCost,
ItemId = item.ItemId,
Quantity = item.Quantity,
MeasurementId = item.UnitOfMeasurementId,
Cost = persistedItem.Cost.Value,
CreatedBy = User.Identity.Name,
CreatedOn = DateTime.Now,
ModifiedBy = User.Identity.Name,
ModifiedOn = DateTime.Now,
});
}
_purchasingService.AddPurchaseOrder(po, true);
return(RedirectToAction("PurchaseOrders"));
}
catch
{
return(View(model));
}
}
new protected void Page_Load(object sender, EventArgs e)
{
try
{
plMessage.Visible = false;
lblMessage.Text = string.Empty;
if (!IsPostBack)
{
PurchaseOrderHeader poHeader = (PurchaseOrderHeader)Session["Ack_POHeader"];
m_Header = poHeader;
m_Items = new Collection<PurchaseOrderItem>();
m_Schedules = new Collection<PurchaseOrderItemSchedule>();
Supplier supplier = SupplierController.GetSupplier(poHeader.SupplierID);
lblSupplierName.Text=supplier.SupplierName ;
lblSupplierAddress.Text = supplier.SupplierAddress;
lblPostalCode.Text ="Singapore " + supplier.PostalCode ;
lblCountry.Text =supplier.Country;
lblShipmentAddress.Text = poHeader.ShipmentAddress;
lblOrderNumber.Text=poHeader.OrderNumber ;
if (poHeader.OrderDate.HasValue)
lblOrderDate.Text = GetShortDate(GetDateTimeFormStoredValue(poHeader.OrderDate.Value));
else
lblOrderDate.Text = "";
lblSupplierId.Text=poHeader.SupplierID;
lblPaymentTerm.Text=poHeader.PaymentTerms;
lblRemarks.Text=poHeader.Remarks;
lblBuyer.Text = poHeader.BuyerName;
lblPhone.Text="";
lblCurrency.Text = poHeader.CurrencyCode;
hlHeaderText.NavigateUrl = "javascript:ShowHeaderText('" + poHeader.OrderNumber + "')";
ShowItems();
}
}
catch (Exception ex)
{
ExceptionLog(ex);
plMessage.Visible = true;
string sMessage = ex.Message;
displayCustomMessage(sMessage, lblMessage, SystemMessageType.Error);
}
}
/// <summary>
/// Create a new PurchaseOrderHeader object.
/// </summary>
/// <param name="purchaseOrderID">Initial value of PurchaseOrderID.</param>
/// <param name="revisionNumber">Initial value of RevisionNumber.</param>
/// <param name="status">Initial value of Status.</param>
/// <param name="orderDate">Initial value of OrderDate.</param>
/// <param name="subTotal">Initial value of SubTotal.</param>
/// <param name="taxAmt">Initial value of TaxAmt.</param>
/// <param name="freight">Initial value of Freight.</param>
/// <param name="totalDue">Initial value of TotalDue.</param>
/// <param name="modifiedDate">Initial value of ModifiedDate.</param>
public static PurchaseOrderHeader CreatePurchaseOrderHeader(int purchaseOrderID, byte revisionNumber, byte status, global::System.DateTime orderDate, decimal subTotal, decimal taxAmt, decimal freight, decimal totalDue, global::System.DateTime modifiedDate)
{
PurchaseOrderHeader purchaseOrderHeader = new PurchaseOrderHeader();
purchaseOrderHeader.PurchaseOrderID = purchaseOrderID;
purchaseOrderHeader.RevisionNumber = revisionNumber;
purchaseOrderHeader.Status = status;
purchaseOrderHeader.OrderDate = orderDate;
purchaseOrderHeader.SubTotal = subTotal;
purchaseOrderHeader.TaxAmt = taxAmt;
purchaseOrderHeader.Freight = freight;
purchaseOrderHeader.TotalDue = totalDue;
purchaseOrderHeader.ModifiedDate = modifiedDate;
return purchaseOrderHeader;
}
public void AddPurchaseTest()
{
//delete Purchasing.PurchaseOrderDetail from Purchasing.PurchaseOrderDetail a left join Purchasing.PurchaseOrderHeader b on (a.PurchaseOrderID = b.PurchaseOrderID) where b.VendorID=1500
//delete Purchasing.PurchaseOrderheader from Purchasing.PurchaseOrderHeader where VendorID=1500
//delete Purchasing.PurchaseOrderDetail from Purchasing.PurchaseOrderDetail a left join Purchasing.PurchaseOrderHeader b on (a.PurchaseOrderID = b.PurchaseOrderID) where b.VendorID=1502
//delete Purchasing.PurchaseOrderheader from Purchasing.PurchaseOrderHeader where VendorID=1502
//IUnitOfWork unit = new UnitOfWork();
IPurchaseRepository repo = new PurchaseRepository();
var header = new PurchaseOrderHeader();
header.EmployeeID = 1;
header.RevisionNumber=10;
header.Status=1;
header.VendorID=1699;
header.ShipMethodID = 1;
header.OrderDate=DateTime.Now.Date;
header.ShipDate=DateTime.Now.Date;
header.SubTotal=555;
header.TaxAmt=10;
header.Freight=4;
header.ModifiedDate = DateTime.Now.Date;
header.PurchaseOrderDetails.Add(new PurchaseOrderDetail()
{
DueDate = DateTime.Now.Date
,
OrderQty = 15
,
ProductID = 998
,
UnitPrice = 100
,
LineTotal = 100
,
ReceivedQty = 15
,
RejectedQty = 0
,
StockedQty = 0
,
ModifiedDate = DateTime.Now.Date
});
header.PurchaseOrderDetails.Add(new PurchaseOrderDetail()
{
DueDate = DateTime.Now.Date
,
OrderQty = 25
,
ProductID = 999
,
UnitPrice = 600
,
LineTotal = 700
,
ReceivedQty = 25
,
RejectedQty = 0
,
StockedQty = 0
,
ModifiedDate = DateTime.Now.Date
});
repo.Add(header);
header = repo.Single(x => x.ModifiedDate.Day == DateTime.Now.Day &&
x.ModifiedDate.Month == DateTime.Now.Month &&
x.ModifiedDate.Year == DateTime.Now.Year && x.VendorID == 1699);
Assert.IsNotNull(header);
Assert.IsTrue(header.PurchaseOrderDetails.Count() >= 2);
}
/// <summary>
/// There are no comments for PurchaseOrderHeader in the schema.
/// </summary>
public void AddToPurchaseOrderHeader(PurchaseOrderHeader purchaseOrderHeader)
{
base.AddObject("PurchaseOrderHeader", purchaseOrderHeader);
}
// POST api/awbuildversion
public void Post(PurchaseOrderHeader value)
{
adventureWorks_BC.PurchaseOrderHeaderAdd(value);
}
