public bool Update(QuotationItem entity)
{
int productUnitId = GetProductUnitId((int)entity.Unit.Id.Value, entity.Product.Code.Value);
if (productUnitId > 0)
{
string sqlUpdate = "Update QuotationItem " +
" SET Price = @Price," +
" UpdatedAt = @UpdatedAt" +
" WHERE QuotationId = @QuotationId and ProductUnitId = @ProductUnitId";
using (var connection = Connection)
{
var rows = connection.Execute(sqlUpdate,
new
{
QuotationId = (int)entity.Quotation.Id.Value,
ProductUnitId = productUnitId,
Price = entity.Price.Value,
UpdatedAt = DateTime.Now
});
return(rows > 0);
}
}
return(false);
}
private void DeleteItem_E(object obj)
{
try
{
if (SelectedItemId != null)
{
//db.SaveChanges();
QuotationItem item = db.QuotationItems.Find((int)SelectedItemId);
currentContext.Post(t =>
{
if (item != null)
{
db.QuotationItems.Remove(item);
selectedQuotation.Items.Remove(item);
db.SaveChanges();
}
signal.Set();
}, null);
signal.WaitOne();
selectedQuotation.Items = selectedQuotation.Items;
}
}
catch { }
}
public Task <object> Handle(UpdateQuotationItemCommand command, CancellationToken cancellationToken)
{
if (!command.IsValid())
{
NotifyValidationErrors(command);
}
else
{
QuotationItem quotationItem = new QuotationItem
(
null,
new Entities.Quotation(new Identity((uint)command.QuotationId), null, null, null),
new Entities.Product(null, null, new Code(command.ProductCode), null, null, null, null, null),
new Entities.Unit(new Identity((uint)command.UnitId), null),
new Price(command.Price)
);
QuotationItemModel quotationItemModel = _QuotationItemRepository.GetByProperties(quotationItem);
bool result = false;
if (quotationItemModel == null)
{
result = false;
}
else
{
result = _QuotationItemRepository.Update(quotationItem);
}
if (!result)
{
_bus.RaiseEvent(new DomainNotification("Quotation", "Server error", NotificationCode.Error));
}
return(Task.FromResult(result as object));
}
return(Task.FromResult(false as object));
}
public Quotation GetQuotationVersionDetails(string custId, string version)
{
QuotationDataAccess obj = new QuotationDataAccess();
var result = obj.GetQuotationVersionDetails(custId, version);
Quotation quotation = new Quotation();
List <QuotationItem> quotationItems = new List <QuotationItem>();
foreach (DataRow dr in result.Rows)
{
//quotationItems = new List<QuotationItem>();
QuotationItem quotationItem = new QuotationItem();
quotationItem.Name = dr["QuotationId"].ToString();
quotationItem.IsItem = Convert.ToBoolean(dr["IsItem"].ToString());
quotationItem.ItemId = Convert.ToInt32(dr["ItemId"]);
quotationItem.Margin = float.Parse(dr["ItemMargin"].ToString());
quotationItem.Name = dr["Name"].ToString();
quotationItem.Quantity = dr["Quantity"].ToString();
quotationItem.Description = dr["Description"].ToString();
quotationItem.UnitRate = float.Parse(dr["UnitRate"].ToString());
quotationItem.Total = float.Parse(dr["Rate"].ToString());
quotationItem.Unit = dr["Unit"].ToString();
quotationItems.Add(quotationItem);
}
quotation.GrossMargin = float.Parse(result.Rows[0]["GrossMargin"].ToString());
quotation.Total = float.Parse(result.Rows[0]["Total"].ToString());
quotation.Version = Convert.ToInt32(result.Rows[0]["VersionNumber"].ToString());
quotation.Items = quotationItems;
return(quotation);
}
public QuotationItemModel Add(QuotationItem entity)
{
int productUnitId = GetProductUnitId((int)entity.Unit.Id.Value, entity.Product.Code.Value);
if (productUnitId > 0)
{
string sqlInsert = "INSERT INTO QuotationItem (QuotationId,ProductUnitId,Price,CreatedAt,UpdatedAt)"
+ " Values (@QuotationId,@ProductUnitId,@Price,@CreatedAt,@UpdatedAt);"
+ " SELECT * From QuotationItem Where Id = CAST(SCOPE_IDENTITY() as int)";
using (var connection = Connection)
{
var result = connection.QuerySingleOrDefault <QuotationItemModel>(sqlInsert,
new
{
QuotationId = (int)entity.Quotation.Id.Value,
ProductUnitId = productUnitId,
Price = entity.Price.Value,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
});
return(result);
}
}
return(null);
}
public bool Delete(string quotationNo, DbTransaction parentTransaction)
{
var quotationdetailItem = new QuotationItem {
QuotationNo = quotationNo
};
return(Delete(quotationdetailItem, parentTransaction));
}
public ActionResult DeleteConfirmed(int id)
{
QuotationItem quotationitem = db.QuotationItems.Find(id);
db.QuotationItems.Remove(quotationitem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddNewQuotationItemRow()
{
ViewBag.Parts = db.Parts.ToList();
QuotationItem quotationItem = new QuotationItem()
{
Part = new Part(), Quantity = 1
};
return(PartialView("EditorTemplates/QuotationItem", quotationItem));
}
public Object SaveQuotationItem(QuotationItem quotationItem, string quotationNumber)
{
if (quotationItem != null)
{
var qID = _context.Quotation.Where(x => x.QuotationNumber == quotationNumber).Select(y => y.QuotationId).FirstOrDefault();
quotationItem.QuotationId = qID;
_context.QuotationItem.Add(quotationItem);
_context.SaveChanges();
}
return(quotationItem);
}
private void ItemsDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
grid = (sender as DataGrid);
QuotationItem item = grid.SelectedItem as QuotationItem;
vm.SelectedItemId = item.Id;
}
catch { }
}
public ActionResult Edit([Bind(Include = "ID,PartID,QuotationID,Quantity,Taxable,Total")] QuotationItem quotationitem)
{
if (ModelState.IsValid)
{
db.Entry(quotationitem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.QuotationID = new SelectList(db.Quotations, "ID", "Status", quotationitem.QuotationID);
ViewBag.PartID = new SelectList(db.Parts, "PartID", "Name", quotationitem.PartID);
return(View(quotationitem));
}
//Ajax POST /Quotation/SelectProduct
public PartialViewResult SelectProduct(int PartID, int?index)
{
Part Part = db.Parts.Find(PartID);
QuotationItem QuotationItem = new QuotationItem()
{
Part = Part, PartID = Part.PartID, Quantity = 1
};
ViewBag.Parts = db.Parts.ToList();
return(PartialView("EditorTemplates/QuotationItem", QuotationItem));
}
public List <QuotationItem> GetQuotationItem(string QuotationCode, SqlConnection connection)
{
List <QuotationItem> objQuotationItemList_VW = new List <QuotationItem>();
string vComTxt1 = @"SELECT [QuotationDetCode]
,[QuotationCode]
,[RequisitionDetCode]
,[RequisitionCode]
,a.[ProductCode]
,B.productId
,B.productName
,[ProductType]
,dbo.fxn_FileName(ProductType) productcategory
,[Quantity]
,[QunatityMOUCode]
,dbo.fxn_FileName(QunatityMOUCode) as Mou
,[VATRate]
,[Rate]
,[TotalVAT]
FROM [dbo].[LSP_PMS_QuotationItem] A join pm_product B on A.productcode = B.productCode
WHERE A.[QuotationCode]= '" + QuotationCode + "'";
SqlCommand objDbCommand1 = new SqlCommand(vComTxt1, connection);
SqlDataReader dr;
dr = objDbCommand1.ExecuteReader();
while (dr.Read())
{
QuotationItem obj = new QuotationItem();
obj.QuotationDetCode_PK = dr["QuotationDetCode"].ToString();
obj.QuotationCode = dr["QuotationCode"].ToString();
obj.RequisitionDetCode = dr["RequisitionDetCode"].ToString();
obj.RequisitionCode = dr["RequisitionCode"].ToString();
obj.ProductCode = dr["ProductCode"].ToString();
obj.ProductID_VW = dr["productId"].ToString();
obj.ProductName_VW = dr["productName"].ToString();
obj.QunatityMOUCode = Convert.ToInt16(dr["QunatityMOUCode"].ToString());
obj.QunatityMOU_VW = dr["Mou"].ToString();
obj.Quantity = Convert.ToDecimal(dr["Quantity"].ToString());
obj.ProductType = Convert.ToInt16(dr["ProductType"].ToString());
obj.ProductCatagory_NM = dr["productcategory"].ToString();
obj.VATRate = Convert.ToDecimal(dr["VATRate"].ToString());
obj.Rate = Convert.ToDecimal(dr["Rate"].ToString());
obj.TotalVAT = Convert.ToDecimal(dr["TotalVAT"].ToString());
obj.QuotationItemSpecificationList_VW = GetItemSpecifications(QuotationCode, connection, dr);
objQuotationItemList_VW.Add(obj);
}
dr.Close();
return(objQuotationItemList_VW);
}
// GET: /QuotationItem/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QuotationItem quotationitem = db.QuotationItems.Find(id);
if (quotationitem == null)
{
return(HttpNotFound());
}
return(View(quotationitem));
}
// GET: /QuotationItem/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QuotationItem quotationitem = db.QuotationItems.Find(id);
if (quotationitem == null)
{
return(HttpNotFound());
}
ViewBag.QuotationID = new SelectList(db.Quotations, "ID", "Status", quotationitem.QuotationID);
ViewBag.PartID = new SelectList(db.Parts, "PartID", "Name", quotationitem.PartID);
return(View(quotationitem));
}
public QuotationItemModel GetByProperties(QuotationItem entity)
{
string sql = "SELECT * FROM QuotationItem q" +
" JOIN ProductUnit pu ON q.ProductUnitId = pu.Id" +
" JOIN Product p On pu.ProductId = p.Id" +
" Where pu.UnitId =@UnitId and p.Code = @ProductCode and q.QuotationId = @QuotationId;";
using (var connection = Connection)
{
var model = connection.QueryFirstOrDefault <QuotationItemModel>(sql,
new
{
UnitId = (int)entity.Unit.Id.Value,
ProductCode = entity.Product.Code.Value,
QuotationId = (int)entity.Quotation.Id.Value
});
return(model);
}
}
public ActionResult AddQuotation(string quotationNo, Int16 itemID)
{
QuotationItem quotationItem = null;
if (quotationNo == string.Empty || quotationNo == null || quotationNo == "STANDARD")
{
quotationItem = new QuotationItem();
}
else
{
quotationItem = new POSAccount.BusinessFactory.QuotationBO().GetQuotation(new Contract.Quotation {
QuotationNo = quotationNo
})
.QuotationItems.Where(dt => dt.ItemID == itemID).FirstOrDefault();
if (quotationItem == null)
{
quotationItem = new QuotationItem();
}
}
quotationItem.ChargeCodeList = Utility.GetChargeCodeItemList();
return(PartialView("AddQuotationItem", quotationItem));
//return PartialView("AddQuotationItem");
}
private async void ItemsDataGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
var grid = (sender as DataGrid);
QuotationItem item = e.Row.Item as QuotationItem;
tb = e.EditingElement as TextBox;
try
{
if (e.Column.Header.ToString() == "QTY")
{
double tbValue = Convert.ToDouble(tb.Text);
if (!string.IsNullOrEmpty(item.UnitCost))
{
item.TotalCost = tbValue * Convert.ToDouble(item.UnitCost);
}
}
else if (e.Column.Header.ToString() == "UnitCost")
{
double tbValue = Convert.ToDouble(tb.Text);
if (!string.IsNullOrEmpty(item.QTY))
{
item.TotalCost = tbValue * Convert.ToDouble(item.QTY);
}
}
}
catch
{
item.TotalCost = 0;
MessageBox.Show("Please Use appopriate Values int the grid boxes", "Invalid Value", MessageBoxButton.OK, MessageBoxImage.Warning);
tb.Text = "";
}
await GetTotalValues();
vm.db.SaveChanges();
}
public bool DeleteItem(QuotationItem item, DbTransaction parentTransaction)
{
return(Delete(item, parentTransaction));
}
public QuotationItem GetQuotationItem(QuotationItem item)
{
return((QuotationItem)quotationitemDAL.GetItem <QuotationItem>(item));
}
public bool DeleteQuotationItem(QuotationItem item)
{
return(quotationitemDAL.Delete(item));
}
public void Create(QuotationItem QuotationItem)
{
_QuotationItemRepository.Add(QuotationItem);
_unitOfWork.Commit();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (selSuppllier.SupplierId == null && String.IsNullOrEmpty(cboCandidateSupplier.SelectedValue))
{
Page.ShowError("Selecione um fornecedor!");
return;
}
if (datDeliveryDate.DateTime < DateTime.Now.Date)
{
Page.ShowError("A data de entrega deve ser maior que hoje!");
return;
}
if (grdProductsQuotation.Rows.Count == 0)
{
return;
}
int supplierId = selSuppllier.SupplierId ?? Convert.ToInt32(cboCandidateSupplier.SelectedValue);
var ucTotalAmount = grdProductsQuotation.FooterRow.FindControl <CurrencyField>("ucTotalAmount");
//
// Load Quotation
//
Quotation quotation = Page.Manager.GetQuotation(Page.PurchaseOrder.PurchaseOrderId, supplierId) ??
new Quotation
{
CompanyId = Page.Company.CompanyId,
PurchaseOrderId = Page.PurchaseOrder.PurchaseOrderId,
SupplierId = supplierId,
TotalPrice = ucTotalAmount.CurrencyValue.Value,
DeliveryDate = datDeliveryDate.DateTime.Value
};
var quotationItems = new List <QuotationItem>();
foreach (GridViewRow row in grdProductsQuotation.Rows)
{
var ucCurrFieldPrice = (CurrencyField)row.FindControl("ucCurrFieldPrice");
int purchaseOrderItemId = Convert.ToInt32(grdProductsQuotation.DataKeys[row.RowIndex]["PurchaseOrderItemId"]);
QuotationItem originalQuotationItem = Page.Manager.GetQuotationItem(Page.Company.CompanyId,
supplierId,
purchaseOrderItemId,
Page.PurchaseOrder.PurchaseOrderId);
var quotationItem = originalQuotationItem.Duplicate();
quotationItem.CompanyId = Page.Company.CompanyId;
quotationItem.Price = ucCurrFieldPrice.CurrencyValue.Value;
quotationItem.SupplierId = supplierId;
quotationItem.PurchaseOrderItemId = purchaseOrderItemId;
quotationItem.PurchaseOrderId = Page.PurchaseOrder.PurchaseOrderId;
quotationItems.Add(quotationItem);
}
//
//caso a ordem de compra não estiver cadastrada
//
if (Page.PurchaseOrder.PurchaseOrderId == 0)
{
quotation.PurchaseOrderId = Page.SavePurchaseOrder().PurchaseOrderId;
}
Page.Manager.SaveQuotation(quotation, quotationItems, Page.Employee);
Page.ViewState["_productList"] = Page.Manager.GetPurchaseOrderQuotedItems(
Page.Company.CompanyId,
Page.PurchaseOrder.PurchaseOrderId,
PurchaseOrderDecision.LowUnitPrice);
if (Page.PurchaseOrder.PurchaseOrderStatusId == PurchaseOrderStatus.Reproved ||
Page.PurchaseOrder.PurchaseOrderStatusId == PurchaseOrderStatus.WaitingforApproval)
{
Page.ShowAlert("O processo não pode ser concluído e foi direcionado ao setor de compras para analise!");
}
foreach (QuotationItem item in quotationItems)
{
PurchaseOrderItem pItem = Page.Manager.GetPurchaseOrderItem(item.PurchaseOrderItemId);
if (Page.PurchaseOrder.Quotations.Count() < 3 && pItem.ProductPackage.RequiresQuotationInPurchasing)
{
Page.ShowAlert("Para este processo ser aprovado, necessita de 3 cotações ou mais!");
}
}
}
public void Delete(QuotationItem QuotationItem)
{
_QuotationItemRepository.Delete(QuotationItem);
_unitOfWork.Commit();
}
public void Update(QuotationItem QuotationItem)
{
_QuotationItemRepository.Update(QuotationItem);
_unitOfWork.Commit();
}
public bool SaveQuotationItem(QuotationItem newItem)
{
return(quotationitemDAL.Save(newItem));
}
public void Add(QuotationItem entity, int userId)
{
}
