private void UpsertStock(StockSummaryModel item) { if (item.lstStock.Count > 0) { foreach (var stock in item.lstStock) { if (string.IsNullOrWhiteSpace(connectionString)) { throw new Exception(); } connection = new SqlConnection(connectionString); connection.Open(); if (connection == null) { throw new Exception(); } SqlCommand command = new SqlCommand("tblSockUpsert", connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.Add(new SqlParameter("@stockid", stock.iStockId)); command.Parameters.Add(new SqlParameter("@userDetailsId", stock.objUserDetails.iUserDetailsId)); command.Parameters.Add(new SqlParameter("@fruitId", item.objFruit.iFruitId)); command.Parameters.Add(new SqlParameter("@status", stock.bStatus)); command.Parameters.Add(new SqlParameter("@DeliveryDate", stock.dDeliveryDate)); command.Parameters.Add(new SqlParameter("@note", stock.sNote)); command.Parameters.Add(new SqlParameter("@quantity", stock.deQuantityAdded)); command.Parameters.Add(new SqlParameter("@purchasePrice", stock.dePurchasePrice)); command.ExecuteNonQuery(); } } }
private void AssignValue() { stock = new StockSummaryModel() { objFruit = new clsFruitModel() { iFruitId = 0, sFruitName = txtFruit.Text.Trim(), eMeasurement = clsCommon.GetMeasurementType(Convert.ToInt32(drpMeasureUnit.SelectedValue.ToString())), sDescription = txtDescription.Text.Trim(), bStatus = true, deQuantity = string.IsNullOrWhiteSpace(txtQuantiy.Text.Trim()) ? 0 : Convert.ToDecimal(txtQuantiy.Text.Trim()), deUnitPrice = string.IsNullOrWhiteSpace(txtUnitPrice.Text.Trim()) ? 0 : Convert.ToDecimal(txtUnitPrice.Text.Trim()), }, lstStock = new List <clsStockModel>() { new clsStockModel() { iStockId = 0, objUserDetails = new clsUserDetailsModel() { iUserDetailsId = Convert.ToInt32(drpSuppliers.SelectedValue.ToString()) }, bStatus = true, sNote = txtNote.Text.Trim(), deQuantityAdded = string.IsNullOrWhiteSpace(txtQuantiy.Text.Trim()) ? 0 : Convert.ToDecimal(txtQuantiy.Text.Trim()), dDeliveryDate = GetValidDate(txtDate.Text.Trim()), dePurchasePrice = string.IsNullOrWhiteSpace(txtPurchasePrice.Text.Trim()) ? 0 : Convert.ToDecimal(txtPurchasePrice.Text.Trim()) } } }; }
public void UpsertInventory(StockSummaryModel item) { DataSet fruit = new DataSet(); fruit = UpsertFruit(item.objFruit); item.objFruit.iFruitId = Convert.ToInt32(fruit.Tables[0].Rows[0][0]); UpsertStock(item); }
protected void btnProcess_Click(object sender, EventArgs e) { try { StockSummaryModel stock = new StockSummaryModel(); clsOrderModel selectedOrder = new clsOrderModel(); stock.objFruit = new clsFruitModel(); stock.lstStock = new List <clsStockModel>(); pnlError.Visible = false; pnlSuccess.Visible = false; selectedOrder = LoadOrdersByOrderId(Convert.ToInt32(drpOrders.SelectedValue)); if (selectedOrder == null || selectedOrder.iOrderId == 0) { throw new Exception(); } stock.objFruit = selectedOrder.objFruit; if ((selectedOrder.objFruit.deQuantity - selectedOrder.deQuantity) <= 0) { throw new Exception("Ordered quantity greater than available"); } stock.objFruit.deQuantity = selectedOrder.objFruit.deQuantity - selectedOrder.deQuantity; businessLayer.UpsertInventory(stock); businessLayer.UpdateOrderStatus(Convert.ToInt32(drpOrders.SelectedValue), OrderType.Processing); LoadOrders(); selectedOrder = LoadOrdersByOrderId(Convert.ToInt32(drpOrders.SelectedValue)); if (selectedOrder != null || selectedOrder.iOrderId != 0) { AssignValue(selectedOrder); } pnlError.Visible = false; pnlSuccess.Visible = true; } catch (Exception ex) { lblErrorDetails.Text = ex.Message; pnlError.Visible = true; pnlSuccess.Visible = false; } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { clsFruitModel fruitResult = new clsFruitModel() { bStatus = true, deQuantity = string.IsNullOrWhiteSpace(txtQuatity.Text.Trim()) ? 0 : Convert.ToDecimal(txtQuatity.Text.Trim()), deUnitPrice = string.IsNullOrWhiteSpace(txtUnitPrice.Text.Trim()) ? 0 : Convert.ToDecimal(txtUnitPrice.Text.Trim()), eMeasurement = clsCommon.GetMeasurementType(Convert.ToInt32(drpMeasureUnit.SelectedValue)), iFruitId = Convert.ToInt32(drpFruit.SelectedValue), sDescription = txtDescription.Text.Trim(), sFruitName = txtname.Text.Trim() }; StockSummaryModel result = new StockSummaryModel() { objFruit = fruitResult, lstStock = new List <clsStockModel>() }; businessLayer.UpsertInventory(result); pnlError.Visible = false; pnlSuccess.Visible = true; drpFruit.Items.Clear(); List <clsFruitModel> fruits = new List <clsFruitModel>(); fruits = master.RetrieveFruits(); foreach (var item in fruits) { ListItem list = new ListItem(item.sFruitName, item.iFruitId.ToString(), true); drpFruit.Items.Add(list); } drpFruit.SelectedIndex = 0; LoadFruitByFruitId(Convert.ToInt32(drpFruit.SelectedValue)); } catch (FormatException ex) { pnlError.Visible = true; pnlSuccess.Visible = false; switch (Convert.ToInt32(ex.Message)) { case (int)ErrorStatus.InventoryInvalidModel: pnlError.Visible = true; lblErrorDetails.Text = "Invalid fruit details"; break; case (int)ErrorStatus.InventoryInvalidFruitName: pnlError.Visible = true; lblErrorDetails.Text = "Invalid fruit name"; break; case (int)ErrorStatus.InventoryInvalidQuantity: pnlError.Visible = true; lblErrorDetails.Text = "Invalid quantity"; break; case (int)ErrorStatus.InventoryInvalidUnitPrice: pnlError.Visible = true; lblErrorDetails.Text = "Invalid unit price"; break; case (int)ErrorStatus.InventorySupplierDetails: pnlError.Visible = false; lblErrorDetails.Text = "invalid supplier details"; break; case (int)ErrorStatus.InventoryInvalidDeliveryDate: pnlError.Visible = false; lblErrorDetails.Text = "Invalid delivery date"; break; default: break; } } catch (Exception ex) { Response.Redirect(string.Format("~/Error.aspx?stat={0}", (int)ErrorStatus.InventoryConfigurationFail)); } }