public double LoadPreviousMrp(PurchaseItems purchaseItems)
{
double previousMrp = 0;
//Connection
//string connectionString = @"Server=DESKTOP-0LIAG2C\SQLEXPRESS; Database=BusinessManagementSystem; Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(connectionString);
//Command
string commandString = @"SELECT PreviousMRP FROM PurchaseItems WHERE CategoryId = " + purchaseItems.CategoryId + " And ProductId = " + purchaseItems.ProductId + " ";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
//Execute
if (sqlConnection.State == ConnectionState.Closed)
{
sqlConnection.Open();
}
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
previousMrp = double.Parse((sqlDataReader["PreviousMRP"]).ToString());
}
//Close
sqlConnection.Close();
return(previousMrp);
}
protected void Page_PreRender(object sender, EventArgs e)
{
if (Purchasable == null)
{
PurchaseSummary.Visible = false;
GeneralErrorMessage.Visible = true;
WebForm.EnableDisableNextButton(false);
return;
}
PurchaseSummary.Visible = true;
GeneralErrorMessage.Visible = false;
Shipping.Visible = Purchasable.RequiresShipping;
PurchaseDiscounts.DataSource = Purchasable.Discounts;
PurchaseDiscounts.DataBind();
PurchaseItems.DataSource = Purchasable.Items;
PurchaseItems.DataBind();
QuoteId.Value = Purchasable.Quote.Id.ToString();
if (Purchasable.RequiresShipping && Purchasable.ShipToAddress != null)
{
ShippingCity.Text = Purchasable.ShipToAddress.City;
ShippingCountry.Text = Purchasable.ShipToAddress.Country;
ShippingName.Text = Purchasable.ShipToAddress.Name;
ShippingPostalCode.Text = Purchasable.ShipToAddress.PostalCode;
ShippingStateProvince.Text = Purchasable.ShipToAddress.StateOrProvince;
ShippingAddressLine1.Text = Purchasable.ShipToAddress.Line1;
ShippingAddressLine2.Text = Purchasable.ShipToAddress.Line2;
}
}
public ActionResult Create([Bind(Include = "Id,Code,Name,Quantity,UnitPrice,UnitId,PurchaseBillId,StoreId,PurchaseBillDate")] PurchaseItemsViewModel viewModel)
{
if (ModelState.IsValid)
{
StoreItems storeItems = new StoreItems();
PurchaseItems purchaseItems = Mapper.Map <PurchaseItems>(viewModel);
Guid purchaseItemid = Guid.NewGuid();
purchaseItems.Id = purchaseItemid;
storeItems.Id = Guid.NewGuid();
storeItems.Code = viewModel.Code;
storeItems.Name = viewModel.Name;
storeItems.PurchaseBillId = viewModel.PurchaseBillId;
storeItems.Quantity = viewModel.Quantity;
storeItems.UnitPrice = viewModel.UnitPrice;
storeItems.ExtendedPrice = viewModel.ExtendedPrice;
storeItems.StoreId = viewModel.StoreId;
storeItems.Unit = viewModel.Unit;
storeItems.UnitId = viewModel.UnitId;
storeItems.BalanceQuantity = viewModel.Quantity;
storeItems.ItemAddedDate = viewModel.PurchaseBillDate;
storeItems.PurchaseItemsId = purchaseItemid;
storeItems.Type = "Inward";
_dbContext.StoreItems.Add(storeItems);
_dbContext.PurchaseItems.Add(purchaseItems);
_dbContext.SaveChanges();
return(Json(new { success = true }));
}
ViewBag.PurchaseBillId = new SelectList(_dbContext.PurchaseBills, "Id", "BillInvoice", viewModel.PurchaseBillId);
ViewBag.UnitId = new SelectList(_dbContext.Units, "Id", "Name", viewModel.UnitId);
ViewBag.StoreId = new SelectList(_dbContext.Store, "Id", "Name");
return(View(viewModel));
}
public void AddPurchase(PurchaseItem PurchaseItem)
{
if (LastPurchaseM.AddPurchase(PurchaseItem))
{
PurchaseItems.Remove(PurchaseItem);
}
}
// Need method to print in right format so for brevity will ovveride tostring
public override string ToString()
{
var builder = new StringBuilder();
// group by description, use annon object for brevity
var items = PurchaseItems
.GroupBy(item => item.Description)
.Select(group => new
{
Count = group.Count(),
Description = group.Key,
Price = group.Sum(i => i.GetPrice())
});
// need to consider how quantity works
foreach (var purchaseItem in items)
{
// hard code pound as no other currencies, not ideal
builder.AppendLine($"{purchaseItem.Count} {purchaseItem.Description}: £{purchaseItem.Price}");
}
// Add footer
builder.AppendLine($"Sales Taxes: £{SalesTaxes}");
builder.AppendLine($"Total: £{Total}");
return(builder.ToString());
}
public ActionResult Edit([Bind(Include = "Id,Code,Name,Quantity,UnitPrice,UnitId,WareHouseId,PurchaseBillId,StoreId,PurchaseBillDate")] PurchaseItemsViewModel viewModel)
{
if (ModelState.IsValid)
{
PurchaseItems purchaseItems = Mapper.Map <PurchaseItems>(viewModel);
// StoreItems storeItems = _dbContext.StoreItems.Where(si => si.PurchaseBillId == purchaseItems.PurchaseBillId && si.StoreId == purchaseItems.StoreId).FirstOrDefault();
StoreItems storeItems = _dbContext.StoreItems.Where(si => si.PurchaseItemsId == viewModel.Id).FirstOrDefault();
storeItems.Code = viewModel.Code;
storeItems.Name = viewModel.Name;
storeItems.Quantity = viewModel.Quantity;
storeItems.UnitPrice = viewModel.UnitPrice;
storeItems.ExtendedPrice = viewModel.ExtendedPrice;
storeItems.BalanceQuantity = viewModel.Quantity;
storeItems.ItemAddedDate = viewModel.PurchaseBillDate;
_dbContext.Entry(purchaseItems).State = EntityState.Modified;
_dbContext.Entry(storeItems).State = EntityState.Modified;
_dbContext.SaveChanges();
return(Json(new { success = true }));
}
ViewBag.PurchaseBillId = new SelectList(_dbContext.PurchaseBills, "Id", "BillInvoice", viewModel.PurchaseBillId);
ViewBag.UnitId = new SelectList(_dbContext.Units, "Id", "Name", viewModel.UnitId);
ViewBag.WareHouseId = new SelectList(_dbContext.WareHouses, "Id", "Name");
return(View(viewModel));
}
private void OnAdd()
{
//var aBook = new Book
// {
// Isbn = 1111111111111,
// Details = new BookInfo {Publisher = new Publisher(), Author = new Author()},
// PurchaseItem = new PurchaseItems()
// };
//_ctx.Books.Add(aBook);
var aAut = new Author {
FirstName = "<Enter First Name>", LastName = "<Enter Last Name>"
};
var aPub = new Publisher {
Name = "<Enter Publisher>"
};
var aBookInfo = new BookInfo {
Title = "<Enter Title>", Author = aAut, Publisher = aPub, Isbn = 1
};
var aPur = new Purchase {
Date = DateTime.Now, Id = Guid.NewGuid()
};
var aPi = new PurchaseItems {
Id = aPur.Id, Purchase = aPur
};
//var abi = _ctx.BookInfoes.Find(aBookInfo.Isbn);
//if (abi == null) _ctx.BookInfoes.Add(aBookInfo);
//abi = _ctx.BookInfoes.Find(aBookInfo.Isbn);
var aBook = new Book {
Id = Guid.NewGuid(), Details = aBookInfo, Earning = 0, PurchaseItem = aPi
};
_ctx.Books.Add(aBook);
_books.MoveCurrentTo(aBook);
}
public bool SubmitPurchaseItemsInfo(PurchaseItems purchaseItem)
{
bool isSupplierSubmit = false;
//Connection
//string connectionString = @"Server=DESKTOP-0LIAG2C\SQLEXPRESS; Database=BusinessManagementSystem; Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(connectionString);
//Command
//INSERT INTO Category (Code, Name) Values ('1234', 'arafat')
string commandString = @"INSERT INTO PurchaseItems (CategoryId, ProductId, PurchaseId, AvailableQuantity, ManufacturedDate, ExpireDate, Quantity, UnitPrice, TotalPrice, PreviousUnitPrice, PreviousMRP, MRP, Remarks) Values (" + purchaseItem.CategoryId + ", " + purchaseItem.ProductId + ", " + purchaseItem.PurchaseId + ", " + purchaseItem.AvailableQuantity + ", '" + purchaseItem.ManufacturedDate + "', '" + purchaseItem.ExpireDate + "', " + purchaseItem.Quantity + ", " + purchaseItem.UnitPrice + ", " + purchaseItem.TotalPrice + ", " + purchaseItem.PreviousUnitPrice + ", " + purchaseItem.PreviousMRP + ", " + purchaseItem.MRP + ", '" + purchaseItem.Remarks + "')";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
//Open
sqlConnection.Open();
//Insert
int isExecuted = sqlCommand.ExecuteNonQuery();
if (isExecuted > 0)
{
isSupplierSubmit = true;
}
//Close
sqlConnection.Close();
return(isSupplierSubmit);
}
/// <summary>
/// 生产出入库
/// </summary>
/// <returns></returns>
public virtual StockEntity CreateStocks()
{
if (PurchaseItems == null || PurchaseItems.Count(it => it.Product != null && it.Product.Id != 0) == 0)
{
return(null);
}
var info = new StockEntity {
Purchase = this, StockItems = new List <StockItemEntity>(), SaveType = SaveType.Add
};
foreach (var purchaseItem in PurchaseItems.Where(it => it.Product != null && it.Product.Id != 0))
{
var stockItem = new StockItemEntity
{
Count = purchaseItem.Count,
Stock = info,
Product = purchaseItem.Product,
Storehouse = Storehouse,
Name = purchaseItem.Name,
SaveType = SaveType.Add
};
info.StockItems.Add(stockItem);
}
return(info);
}
public int AvailableQuantity(PurchaseItems purchaseItems)
{
int avail = 0;
//Connection
//string connectionString = @"Server=DESKTOP-0LIAG2C\SQLEXPRESS; Database=BusinessManagementSystem; Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(connectionString);
//Command
string commandString = @"Select AvailableQuantity From PurchaseItems WHERE CategoryId = " + purchaseItems.CategoryId + " And ProductId = " + purchaseItems.ProductId + " ";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
//Open
sqlConnection.Open();
//With DataReader
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
avail = Convert.ToInt32(sqlDataReader["AvailableQuantity"]);
}
//Close
sqlConnection.Close();
return(avail);
}
private void PreviousMrpLoad()
{
PurchaseItems purchaseItems = new PurchaseItems();
purchaseItems.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue);
purchaseItems.ProductId = Convert.ToInt32(productsComboBox.SelectedValue);
previousMRPTextBox.Text = null;
previousMRPTextBox.Text = _PurchaseManager.LoadPreviousMrp(purchaseItems) + "";
}
private int GetPurchaseQuantity()
{
PurchaseItems purchase_ = new PurchaseItems();
purchase_.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue);
purchase_.ProductId = Convert.ToInt32(productsComboBox.SelectedValue);
purchaseQuantity = _PurchaseManager.LoadPurchaseQuantity(purchase_);
return(purchaseQuantity);
}
private async void SavePurchaseItem()
{
IRestDataMapper mapper = containerExtension.Resolve <IRestDataMapper>();
CurrentPurchaseItem.recordState = ConstValues.RCS_FINE;
CurrentPurchaseItem.purchaseType = GetPurchaseType();
decimal rq = (CurrentPurchaseItem.reorderLevel * SelectedUom.baseRatioToPurchase * SelectedUom.purchaseQuantifyValue);
PurchaseItem pi = PurchaseItems.Where(i => i.item.id == SelectedItem.id).FirstOrDefault();
if (pi != null)
{
SelectedStore.reorderLevel += rq;
CurrentPurchaseItem.reorderLevel = rq;
CurrentPurchaseItem = CurrentPurchaseItem.Merge(pi);
_ = await PurchaseRestService.UpdatePurchaseItemAsync(mapper, CurrentPurchaseItem);
_ = await ItemRestService.UpdateStoreInforAsync(mapper, SelectedStore);
PurchaseItem np = CurrentPurchaseItem.CloneObject();
PurchaseItems.Remove(pi);
PurchaseItems.Add(np);
SelectedStore = null;
SelectedUom = null;
SelectedItem = null;
SelectedItmCt = null;
CurrentPurchaseItem = null;
}
else
{
CurrentPurchaseItem.reorderLevel = rq;
SelectedStore.reorderLevel = rq;
CurrentPurchaseItem = await PurchaseRestService.CreatePurchaseItemAsync(mapper, CurrentPurchaseItem);
if (CurrentPurchaseItem.id > 0)
{
_ = await ItemRestService.UpdateStoreInforAsync(mapper, SelectedStore);
PurchaseItems.Add(CurrentPurchaseItem.CloneObject());
SelectedStore = null;
SelectedUom = null;
SelectedItem = null;
SelectedItmCt = null;
CurrentPurchaseItem = null;
}
else
{
_ = ShowMessageDialg("Saving Purchase Item", "Can't Savae Purchase Item, found Some problems.", MsgDialogType.error);
}
}
CurrenPurchase.CalaculatePurchase(PurchaseItems);
_ = await PurchaseRestService.UpdatePurchaseAsync(mapper, CurrenPurchase);
}
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseItems purchaseItems = _dbContext.PurchaseItems.Find(id);
if (purchaseItems == null)
{
return(HttpNotFound());
}
return(View(purchaseItems));
}
public async Task <IActionResult> NewOrder([FromBody] PurchaseItems items)
{
if (!items.Items.Any(x => x.Count > 0))
{
return(BadRequest("Number of elements less than zero"));
}
{
foreach (var item in items.Items)
{
var medicament = _medicamentsService.GetBy(x => x.Id == item.Id);
medicament.ItemsAvailable += item.Count;
_medicamentsService.Update(medicament);
}
return(Ok());
}
}
public ActionResult MyPurchases()
{
string customer_id = Request.Cookies["customer_id"].Value;
List <PurchaseItems> allitems = new List <PurchaseItems>();
using (SqlConnection conn = new SqlConnection("Server=.; Database=ShoppingCartT4; Integrated Security=true; MultipleActiveResultSets=True"))
{
conn.Open();
string sql = @"select purchase_time, i.pro_id, pro_name, pro_desc, pro_image, count(i.pro_id) as count from Purchaseitem i join Product p on i.pro_id = p.pro_id where customer_id ='" + customer_id + "' group by i.pro_id, purchase_time, pro_name, pro_desc, pro_image";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
PurchaseItems singleitem = new PurchaseItems();
singleitem.purchase_time = (DateTime)reader["purchase_time"];
singleitem.pro_id = (int)reader["pro_id"];
singleitem.pro_desc = (string)reader["pro_desc"];
singleitem.pro_image = (string)reader["pro_image"];
singleitem.pro_name = (string)reader["pro_name"];
singleitem.count = (int)reader["count"];
List <string> arr = new List <string>();
using (SqlConnection conn1 = new SqlConnection("Server=.; Database=ShoppingCartT4; Integrated Security=true; MultipleActiveResultSets=True"))
{
conn1.Open();
string sql1 = @"select activation_code from Purchaseitem where purchase_time='" + singleitem.purchase_time.ToString("yyyy-MM-dd") + "' and pro_id = '" + singleitem.pro_id + "' and customer_id='" + customer_id + "'";
SqlCommand cmd1 = new SqlCommand(sql1, conn);
SqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
arr.Add((string)reader1["activation_code"]);
}
}
singleitem.activation_code = arr;
allitems.Add(singleitem);
}
}
ViewBag.purchases = allitems;
ViewBag.Count = int.Parse(Request.Cookies["Count"].Value);
ViewBag.firstname = Request.Cookies["firstname"].Value;
return(View());
}
private void showDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
PurchaseItems purchaseItems = new PurchaseItems();
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.showDataGridView.Rows[e.RowIndex];
categoryComboBox.Text = row.Cells[1].Value.ToString();
productsComboBox.Text = row.Cells[2].Value.ToString();
manufactureDateTimePicker.Text = row.Cells[3].Value.ToString();
expireDateTimePicker.Text = row.Cells[4].Value.ToString();
quantityTextBox.Text = row.Cells[5].Value.ToString();
unitPriceTextBox.Text = row.Cells[6].Value.ToString();
remarksTextBox.Text = row.Cells[7].Value.ToString();
addButton.Text = " Update ";
}
showDataGridView.DataSource = _PurchaseManager.Display();
}
private void GetTotalAvailableQuantity()
{
//availableQuantityTextBox.Text = null;
int quantity = GetPurchaseQuantity();
PurchaseItems purchase_ = new PurchaseItems();
purchase_.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue);
purchase_.ProductId = Convert.ToInt32(productsComboBox.SelectedValue);
int avail = _PurchaseManager.AvailableQuantity(purchase_);
int totalQuantity = avail + quantity;
//availableQuantity = availableQuantity + totalQuantity;
availableQuantityTextBox.Text = totalQuantity.ToString();
}
public ActionResult DeleteConfirmed(Guid id)
{
PurchaseItems purchaseItems = _dbContext.PurchaseItems.Find(id);
StoreItems storeItems = _dbContext.StoreItems.Where(si => si.PurchaseItemsId == id).FirstOrDefault();
try
{
_dbContext.PurchaseItems.Remove(purchaseItems);
_dbContext.StoreItems.Remove(storeItems);
_dbContext.SaveChanges();
return(Json(new { success = true }));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
}
return(RedirectToAction("Index"));
}
private async void EndPurchase()
{
IRestDataMapper mapper = containerExtension.Resolve <IRestDataMapper>();
CurrenPurchase.recordState = ConstValues.RCS_FINE;
_ = await PurchaseRestService.UpdatePurchaseAsync(mapper, CurrenPurchase);
if (CurrenPurchase.creditAmount > 0.00m)
{
CurrenPurchase.invoiceType = ConstValues.INVT_CREDIT;
CreditInvoice = CreditInvoice.CreateNewCreditInvoice(branch, loggedUser.LoggedUser, CurrenPurchase);
SelectedSupplier.supplierCreditAccount.totalCredit += CurrenPurchase.creditAmount;
_ = await SupplierCreditRestService.updateSupplierCreditAccountAsync(mapper, SelectedSupplier.supplierCreditAccount);
_ = await SupplierCreditRestService.CreateSupplierCreditInvoiceAsync(mapper, CreditInvoice);
}
if (CurrenPurchase.payAmount > 0.00m)
{
CurrenCashBook = CurrenCashBook.CreateNewCashBook(branch, loggedUser.LoggedUser, CurrenPurchase);
CurrenCashBook.branchAccount = SelectedBac;
_ = await FinancialRestService.CreateCashBookAsync(mapper, CurrenCashBook);
}
if (CurrenPurchase.chqAmount > 0.00m)
{
CurrenChqueBook = CurrenChqueBook.CreateNewChequeBook(branch, loggedUser.LoggedUser, CurrenPurchase);
CurrenChqueBook.branchAccount = SelectedBac;
_ = await FinancialRestService.CreateChequeBookAsync(mapper, CurrenChqueBook);
}
SelectedStore = null;
SelectedUom = null;
SelectedItem = null;
SelectedItmCt = null;
CurrentPurchaseItem = null;
CurrenPurchase = null;
SelectedSupCt = null;
SelectedSupplier = null;
CreditInvoice = null;
CurrenCashBook = null;
CurrenChqueBook = null;
PurchaseItems.Clear();
Initialize();
}
public ActionResult Edit(Guid?id, DateTime puchaseBillDate)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseItems purchaseItems = _dbContext.PurchaseItems.Find(id);
if (purchaseItems == null)
{
return(HttpNotFound());
}
PurchaseItemsViewModel viewModel = Mapper.Map <PurchaseItemsViewModel>(purchaseItems);
ViewBag.PurchaseBillId = new SelectList(_dbContext.PurchaseBills, "Id", "BillInvoice", purchaseItems.PurchaseBillId);
ViewBag.UnitId = new SelectList(_dbContext.Units, "Id", "Name", purchaseItems.UnitId);
ViewBag.StoreId = new SelectList(_dbContext.Store, "Id", "Name", purchaseItems.StoreId);
viewModel.PurchaseBillDate = puchaseBillDate;
return(PartialView("_Edit", viewModel));
}
private IEnumerable <IPurchasableItemOptions> GetPostedOptions()
{
var options = new List <IPurchasableItemOptions>();
foreach (var item in PurchaseItems.Items)
{
var itemValues = new OrderedDictionary();
PurchaseItems.ExtractItemValues(itemValues, item, true);
var quoteProductIdValue = itemValues["QuoteProduct.Id"];
if (quoteProductIdValue == null)
{
continue;
}
Guid quoteProductId;
if (!Guid.TryParse(quoteProductIdValue.ToString(), out quoteProductId))
{
continue;
}
var isSelectedValue = itemValues["IsSelected"];
if (!(isSelectedValue is bool))
{
continue;
}
var quoteProductReference = new EntityReference("quotedetail", quoteProductId);
var isSelected = (bool)isSelectedValue;
options.Add(new PurchasableItemOptions(quoteProductReference, isSelected));
}
return(options);
}
public IActionResult Buy([FromBody] PurchaseItems items)
{
if (!items.Items.Any(x => x.Count > 0))
{
return(BadRequest("Number of elements less than zero"));
}
{
var medicamentSales = new List <MedicamentSale>();
double totalPrice = 0;
foreach (var item in items.Items)
{
var medicament = _medicamentsService.GetBy(x => x.Id == item.Id);
var medicamentSale = new MedicamentSale
{
Medicament = medicament,
Count = item.Count
};
totalPrice += medicament.Price * item.Count;
medicamentSales.Add(medicamentSale);
medicament.ItemsAvailable = medicament.ItemsAvailable - item.Count;
_medicamentsService.Update(medicament);
}
var sale = new Sale
{
MedicamentSales = medicamentSales,
TotalPrice = totalPrice,
DateTime = DateTime.Now
};
_saleService.Create(sale);
return(this.Ok());
}
}
private void OnAdd()
{
//var aBook = new Book
// {
// Isbn = 1111111111111,
// Details = new BookInfo {Publisher = new Publisher(), Author = new Author()},
// PurchaseItem = new PurchaseItems()
// };
//_ctx.Books.Add(aBook);
var aAut = new Author { FirstName = "<Enter First Name>", LastName = "<Enter Last Name>" };
var aPub = new Publisher { Name="<Enter Publisher>"};
var aBookInfo = new BookInfo { Title = "<Enter Title>", Author = aAut, Publisher = aPub, Isbn = 1};
var aPur = new Purchase { Date = DateTime.Now, Id=Guid.NewGuid()};
var aPi = new PurchaseItems { Id = aPur.Id, Purchase = aPur };
//var abi = _ctx.BookInfoes.Find(aBookInfo.Isbn);
//if (abi == null) _ctx.BookInfoes.Add(aBookInfo);
//abi = _ctx.BookInfoes.Find(aBookInfo.Isbn);
var aBook = new Book { Id = Guid.NewGuid(), Details = aBookInfo, Earning = 0, PurchaseItem = aPi };
_ctx.Books.Add(aBook);
_books.MoveCurrentTo(aBook);
}
private void addButton_Click(object sender, EventArgs e)
{
//Set Category as Mandatory
if (String.IsNullOrEmpty(categoryComboBox.Text))
{
MessageBox.Show("Category should not be empty!");
return;
}
//Set Products as Mandatory
if (String.IsNullOrEmpty(productsComboBox.Text))
{
MessageBox.Show("Products should not be empty!");
return;
}
//Set Manufactured Date as Mandatory
if (String.IsNullOrEmpty(manufactureDateTimePicker.Text))
{
MessageBox.Show("Manufactured Date should not be empty!");
return;
}
//Set Expired Date as Mandatory
if (String.IsNullOrEmpty(expireDateTimePicker.Text))
{
MessageBox.Show("Expired Date should not be empty!");
return;
}
//Set Quantity as Mandatory
if (String.IsNullOrEmpty(quantityTextBox.Text))
{
MessageBox.Show("Quantity should not be empty!");
return;
}
//Set Unit Price as Mandatory
if (String.IsNullOrEmpty(unitPriceTextBox.Text))
{
MessageBox.Show("Unit Price should not be empty!");
return;
}
//Set MRP as Mandatory
if (String.IsNullOrEmpty(mrpTextBox.Text))
{
MessageBox.Show("MRP should not be empty!");
return;
}
if (categoryComboBox.Text == "-Select-")
{
MessageBox.Show("Select a category");
return;
}
if (productsComboBox.Text == "-Select-")
{
MessageBox.Show("Select a product");
return;
}
Purchase purchase = new Purchase();
PurchaseItems purchaseItem = new PurchaseItems();
purchaseItem.CategoryId = Convert.ToInt32(categoryComboBox.SelectedValue);
purchaseItem.ProductId = Convert.ToInt32(productsComboBox.SelectedValue);
purchaseItem.AvailableQuantity = Convert.ToInt32(availableQuantityTextBox.Text);
purchaseItem.ManufacturedDate = (manufactureDateTimePicker.Text);
purchaseItem.ExpireDate = (expireDateTimePicker.Text);
purchaseItem.Quantity = Convert.ToInt32(quantityTextBox.Text);
purchaseItem.UnitPrice = float.Parse(unitPriceTextBox.Text);
purchaseItem.TotalPrice = float.Parse(totalPriceTextBox.Text);
purchaseItem.PreviousUnitPrice = float.Parse(previousUnitPriceTextBox.Text);
purchaseItem.PreviousMRP = float.Parse(previousMRPTextBox.Text);
purchaseItem.MRP = float.Parse(mrpTextBox.Text);
purchaseItem.Remarks = remarksTextBox.Text;
//Check UNIQUE
if (_PurchaseManager.IsInvoiceNoExists(purchase))
{
MessageBox.Show(billInvoiceNoTextBox.Text + " Already Exists!");
return;
}
//Check UNIQUE
if (_PurchaseManager.IsCodeExists(purchase))
{
MessageBox.Show(codeTextBox.Text + " Already Exists!");
return;
}
if (purchaseItems == null)
{
purchaseItems = new List <PurchaseItems>();
}
purchaseItems.Add(purchaseItem);
MessageBox.Show(" Saved");
showDataGridView.DataSource = null;
showDataGridView.DataSource = purchaseItems;
}
protected void ApplyDiscount_OnClick(object sender, EventArgs e)
{
if (Purchasable == null)
{
return;
}
var discountCode = DiscountCode.Value;
var discountCodeValidationResult = DiscountCodeValidationResult.ValidateDiscountCode(ServiceContext, Purchasable.Quote.Id, discountCode);
if (!discountCodeValidationResult.IsValid)
{
DiscountErrorAlreadyApplied.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.AlreadyApplied ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.AlreadyApplied);
DiscountErrorCodeNotSpecified.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.CodeNotSpecified ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.CodeNotSpecified);
DiscountErrorDoesNotExist.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.DoesNotExist ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.DoesNotExist);
DiscountErrorInvalidDiscount.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.InvalidDiscountConfiguration ||
discountCodeValidationResult.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.QuoteNotFound ||
discountCodeValidationResult.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.UpdateFailed ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.InvalidDiscountConfiguration);
DiscountErrorMaximumRedemptions.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.MaximumRedemptions ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.MaximumRedemptions);
DiscountErrorMinimumAmountNotMet.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.MinimumAmountNotMet ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.MinimumAmountNotMet);
DiscountErrorUnknown.Visible = discountCodeValidationResult.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.Unknown || (discountCodeValidationResult.ErrorCode == 0 && !discountCodeValidationResult.DiscountErrors.Any());
DiscountErrorZeroAmount.Visible = discountCodeValidationResult.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.ZeroAmount ||
discountCodeValidationResult.DiscountErrors.Any(
o => o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.ZeroAmount);
DiscountErrorNotApplicable.Visible = discountCodeValidationResult.ErrorCode ==
DiscountCodeValidationResult.DiscountErrorCode.NotApplicable ||
discountCodeValidationResult.DiscountErrors.Any(
o =>
o.ErrorCode == DiscountCodeValidationResult.DiscountErrorCode.NotApplicable);
return;
}
DiscountErrorAlreadyApplied.Visible = false;
DiscountErrorCodeNotSpecified.Visible = false;
DiscountErrorDoesNotExist.Visible = false;
DiscountErrorInvalidDiscount.Visible = false;
DiscountErrorMaximumRedemptions.Visible = false;
DiscountErrorMinimumAmountNotMet.Visible = false;
DiscountErrorUnknown.Visible = false;
DiscountErrorZeroAmount.Visible = false;
try
{
// Add new discount code to existing discount codes and update quote, plugins will process the code.
var updateContext = new OrganizationServiceContext(new OrganizationService("Xrm"));
var quoteUpdate = new Entity("quote")
{
Id = Purchasable.Quote.Id
};
var updateDiscountCodes = string.IsNullOrWhiteSpace(discountCodeValidationResult.ExistingDiscountCodes) ? discountCode : string.Format("{0},{1}", discountCodeValidationResult.ExistingDiscountCodes, discountCode);
quoteUpdate["adx_discountcodes"] = updateDiscountCodes;
updateContext.Attach(quoteUpdate);
updateContext.UpdateObject(quoteUpdate);
updateContext.SaveChanges();
}
catch (Exception ex)
{
ADXTrace.Instance.TraceError(TraceCategory.Application, ex.ToString());
}
Target = GetTargetEntityReference();
if (Target == null)
{
return;
}
var options = IsPostBack
? GetPostedOptions()
: Enumerable.Empty <IPurchasableItemOptions>();
Guid quoteId;
if (IsPostBack && Guid.TryParse(QuoteId.Value, out quoteId))
{
WebForm.CurrentSessionHistory.QuoteId = quoteId;
}
var dataAdapter = CreatePurchaseDataAdapter(Target, CurrentStepEntityPrimaryKeyLogicalName);
var quoteProducts = ServiceContext.CreateQuery("quotedetail").Where(q => q.GetAttributeValue <EntityReference>("quoteid") == Purchasable.Quote).ToArray();
foreach (var quoteProduct in quoteProducts)
{
ServiceContext.TryRemoveFromCache(quoteProduct);
}
Purchasable = dataAdapter.Select(options);
PurchaseDiscounts.DataSource = Purchasable.Discounts;
PurchaseDiscounts.DataBind();
PurchaseItems.DataSource = Purchasable.Items;
PurchaseItems.DataBind();
DiscountCode.Value = string.Empty;
}
public bool SubmitPurchaseItemsInfo(PurchaseItems purchaseItem)
{
return(_PurchaseRepo.SubmitPurchaseItemsInfo(purchaseItem));
}
public double LoadPreviousMrp(PurchaseItems purchaseItems)
{
return(_PurchaseRepo.LoadPreviousMrp(purchaseItems));
}
public double LoadPreviousUnitPrice(PurchaseItems purchaseItems)
{
return(_PurchaseRepo.LoadPreviousUnitPrice(purchaseItems));
}
//public DataTable LoadSalesQuantity(PurchaseItems purchaseItems)
//{
// return _PurchaseRepo.LoadSalesQuantity(purchaseItems);
//}
public int AvailableQuantity(PurchaseItems purchaseItems)
{
return(_PurchaseRepo.AvailableQuantity(purchaseItems));
}
public int LoadPurchaseQuantity(PurchaseItems purchaseItems)
{
return(_PurchaseRepo.LoadPurchaseQuantity(purchaseItems));
}
