protected void btnSubmit_Click(object sender, EventArgs e) { try { if (Validation()) { Entity.Purchase.PurchaseRequisition purchase = new Entity.Purchase.PurchaseRequisition(); Business.Purchase.PurchaseRequisition objPurchase = new Business.Purchase.PurchaseRequisition(); Entity.Purchase.PurchaseDetails purchaseDetails = new Entity.Purchase.PurchaseDetails(); purchase.PurchaseRequisitionNo = (!string.IsNullOrEmpty(txtPurchaseRequisitionNo.Text.Trim())) ? txtPurchaseRequisitionNo.Text.Trim() : string.Empty; purchase.RequisitionDate = Convert.ToDateTime(txtPurchaseRequisitionDate.Text.Trim()); purchase.PurchaseDepartment = txtPurchaseDepartment.Text.Trim(); purchase.VendorId = Convert.ToInt32(ddlVendor.SelectedValue); purchase.WhenNeeded = Convert.ToDateTime(txtPurchaseRequisitionDate.Text.Trim()); purchase.PurposeOfRequisition = txtPurposeOfRequisition.Text.Trim(); purchase.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name); Int64 purchaseRequisitionId = objPurchase.PurchaseRequisition_Save(purchase); foreach (DataRow drItem in _ItemsList.Rows) { purchase.PurchaseRequisitionDetailsCollection.Add( new Entity.Purchase.PurchaseRequisitionDetails() { PurchaseRequisitionId = purchaseRequisitionId, ItemId = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[0]), ItemType = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[1]), Quantity = (drItem["Quantity"] != null && !string.IsNullOrEmpty(drItem["Quantity"].ToString())) ? Convert.ToDecimal(drItem["Quantity"].ToString()) : 0, UOM = 1, Description = (drItem["Description"] != null && !string.IsNullOrEmpty(drItem["Description"].ToString())) ? drItem["Description"].ToString() : string.Empty, ApprovalStatus = (int)ApprovalStatus.None }); } int purchaseDetailsResponse = objPurchase.Purchase_RequisitionDetails_Save(purchase); if (purchaseDetailsResponse > 0) { ClearMasterControls(); ClearItemControls(); LoadItemList(); Message.IsSuccess = true; Message.Text = "Purchase requisition saved"; } else { Message.IsSuccess = false; Message.Text = "Purchase requisition not saved"; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (Validation()) { Entity.Purchase.Purchase purchase = new Entity.Purchase.Purchase(); Business.Purchase.Purchase objPurchase = new Business.Purchase.Purchase(); Entity.Purchase.PurchaseDetails purchaseDetails = new Entity.Purchase.PurchaseDetails(); Entity.Inventory.Inventory inventory = new Entity.Inventory.Inventory(); Business.Inventory.Inventory objInventory = new Business.Inventory.Inventory(); purchase.PurchaseOrderNo = (!string.IsNullOrEmpty(txtPurchaseOrderNo.Text.Trim())) ? txtPurchaseOrderNo.Text.Trim() : string.Empty; purchase.PurchaseDate = Convert.ToDateTime(txtPurchaseDate.Text.Trim()); purchase.VendorId = Convert.ToInt32(ddlVendor.SelectedValue); purchase.InvoiceNo = (!string.IsNullOrEmpty(txtInvoiceNo.Text.Trim())) ? txtInvoiceNo.Text.Trim() : string.Empty; purchase.InvoiceDate = (!string.IsNullOrEmpty(txtInvoiceDate.Text.Trim())) ? Convert.ToDateTime(txtInvoiceDate.Text.Trim()) : DateTime.MinValue; purchase.BillAmount = (!string.IsNullOrEmpty(txtBillAmount.Text.Trim())) ? Convert.ToDecimal(txtBillAmount.Text.Trim()) : 0; purchase.PaymentAmount = (!string.IsNullOrEmpty(txtPaymentAmount.Text.Trim())) ? Convert.ToDecimal(txtPaymentAmount.Text.Trim()) : 0; int purchaseId = objPurchase.Purchase_Save(purchase); foreach (DataRow drItem in _ItemsList.Rows) { purchase.PurchaseDetailsCollection.Add( new Entity.Purchase.PurchaseDetails() { PurchaseId = purchaseId, ItemId = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[0]), ItemType = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[1]), ItemQty = (!string.IsNullOrEmpty(drItem["Quantity"].ToString())) ? Convert.ToDecimal(drItem["Quantity"].ToString()) : 0, ItemRate = (!string.IsNullOrEmpty(drItem["Rate"].ToString())) ? Convert.ToDecimal(drItem["Rate"].ToString()) : 0, Discount = (!string.IsNullOrEmpty(drItem["Discount"].ToString())) ? Convert.ToDecimal(drItem["Discount"].ToString()) : 0, GST = (!string.IsNullOrEmpty(drItem["GST"].ToString())) ? Convert.ToDecimal(drItem["GST"].ToString()) : 0, HsnCode = drItem["HsnCode"].ToString() }); } int purchaseDetailsResponse = objPurchase.PurchaseDetails_Save(purchase); if (purchaseDetailsResponse > 0) { using (DataTable dtInventory = new DataTable()) { dtInventory.Columns.Add("AssetId"); dtInventory.Columns.Add("ItemId"); dtInventory.Columns.Add("ItemType"); dtInventory.Columns.Add("AssetLocationId"); dtInventory.Columns.Add("CustomerId"); dtInventory.Columns.Add("SaleChallanId"); dtInventory.Columns.Add("EmployeeId"); dtInventory.Columns.Add("StoreId"); foreach (DataRow drItem in _ItemsList.Rows) { for (int qty = 1; qty <= Convert.ToInt32(drItem["Quantity"]); qty++) { DataRow drInventoryItem = dtInventory.NewRow(); drInventoryItem["AssetId"] = Guid.NewGuid().ToString().ToUpper(); drInventoryItem["ItemId"] = drItem["ItemIdType"].ToString().Split('|')[0]; drInventoryItem["ItemType"] = drItem["ItemIdType"].ToString().Split('|')[1]; drInventoryItem["AssetLocationId"] = (int)AssetLocation.Store; //Stock In drInventoryItem["CustomerId"] = ""; drInventoryItem["SaleChallanId"] = ""; drInventoryItem["EmployeeId"] = Convert.ToInt32(HttpContext.Current.User.Identity.Name); drInventoryItem["StoreId"] = Convert.ToInt32(ddlStore.SelectedValue); dtInventory.Rows.Add(drInventoryItem); dtInventory.AcceptChanges(); } } inventory.InventoryDetails = dtInventory; int inventoryResponse = objInventory.Inventory_Save(inventory); if (inventoryResponse > 0) { GlobalCache.RemoveAll(); ClearMasterControls(); ClearItemControls(); LoadItemList(); Message.IsSuccess = true; Message.Text = "Purchase Order saved"; } else { Message.IsSuccess = false; Message.Text = "Inventory not saved"; } } } else { Message.IsSuccess = false; Message.Text = "Purchase Order not saved"; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }