protected void ddlBillNo_SelectedIndexChanged(object sender, EventArgs e) { try { if (ddlBillNo.SelectedValue != "0") { string orderType = ddlOrderType.SelectedValue; panelDetail.Visible = true; divPersonName.Visible = true; divmobile.Visible = true; //For Sale Order if (orderType == "1") { int saleOrderID = Convert.ToInt32(ddlBillNo.SelectedValue); var saleOrderCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == saleOrderID); if (saleOrderCollection.Count() > 0) { Database.SalesOrder saleOrder = saleOrderCollection.FirstOrDefault(); Database.Customer customer = context.Customers.Where(x => x.IsActive == true && x.CustomerID == saleOrder.CustomerID).SingleOrDefault(); txtMobile.Text = customer.CustomerMobile; txtPersonOrgName.Text = customer.CustomerName; txtRemainingAmt.Text = Convert.ToString(saleOrder.RemainingAmount); divSeller.Visible = false; } } //For Purchase Order if (orderType == "2") { int purchaseOrderID = Convert.ToInt32(ddlBillNo.SelectedValue); var purchaseOrderCollection = context.InventoryOrders.Where(x => x.IsActive == true && x.InventoryOrderID == purchaseOrderID); if (purchaseOrderCollection.Count() > 0) { Database.InventoryOrder invOrder = purchaseOrderCollection.FirstOrDefault(); Database.Seller seller = context.Sellers.Where(x => x.IsActive == true && x.SellerID == invOrder.SellerID).SingleOrDefault(); txtMobile.Text = seller.SellerMobile; txtPersonOrgName.Text = seller.SellerName; txtRemainingAmt.Text = Convert.ToString(invOrder.BalanceAmount); divcustomer.Visible = false; } } } } catch (Exception ex) { Helper.LogError(ex); lblMessage.Text = "Something went Wrong kindly check log"; lblMessage.ForeColor = Color.Red; } }
public void FillForm() { try { string PurchaseOrderIDObj = Request.QueryString[Constants.queryPurchaseOrderID]; if (!string.IsNullOrEmpty(PurchaseOrderIDObj)) { int PurchaseOrderID = Convert.ToInt32(PurchaseOrderIDObj); if (PurchaseOrderID > 0) { var PurchaseOrderCollection = context.InventoryOrders.Where(x => x.InventoryOrderID == PurchaseOrderID); if (PurchaseOrderCollection.Count() > 0) { //Fill Other Form Data Database.InventoryOrder purchaseOrder = PurchaseOrderCollection.FirstOrDefault(); txtAmountPaidDate.Text = purchaseOrder.AmountPaidDate.GetValueOrDefault().ToString(Constants.DateFormatDatePicker); txtBalance.Text = Convert.ToString(purchaseOrder.BalanceAmount); txtBillDate.Text = purchaseOrder.BillDate.GetValueOrDefault().ToString(Constants.DateFormatDatePicker); txtDetails.Text = purchaseOrder.Remarks; txtOwnBillNo.Text = purchaseOrder.OwnBillNo; txtPaidAmount.Text = Convert.ToString(purchaseOrder.AmountPaid); txtPurchaseBillNO.Text = purchaseOrder.PurchaseBillNo; txtPurchaseDate.Text = purchaseOrder.PurchaseDate.GetValueOrDefault().ToString(Constants.DateFormatDatePicker); txtTotalOrderAmount.Text = Convert.ToString(purchaseOrder.TotalOrderAmount); ddlCustomerType.SelectedValue = Convert.ToString(purchaseOrder.CustomerTypeID); txtSellerID.Text = Convert.ToString(purchaseOrder.SellerID); Database.Seller seller = context.Sellers.Where(x => x.SellerID == purchaseOrder.SellerID).FirstOrDefault(); txtAutoSeller.Text = seller.SellerName; chkOrderComplete.Checked = Convert.ToBoolean(purchaseOrder.IsCompleted); //Fill Repeater Data var invOrderCollection = context.InventoryOrderDetails.Where(x => x.InventoryOrderID == purchaseOrder.InventoryOrderID).ToList(); if (invOrderCollection.Count() > 0) { var purchaseOrders = from invOrder in invOrderCollection join inv in context.InventoryTypes on invOrder.InventoryTypeID equals inv.InventoryTypeId select new rptrClass { ItemID = invOrder.InventoryTypeID, ItemName = inv.InventoryTypeName, PurchaseRate = invOrder.PurchaseRate, Quantity = invOrder.Quantity, SellingRate = invOrder.SaleRate, TotalAmount = invOrder.TotalItemsCost, VAT = invOrder.VatNo, ItemCode = inv.InventoryCode, OrderDetailID = invOrder.InventoryOrderDetailID }; rptrData.DataSource = purchaseOrders.ToList(); rptrData.DataBind(); } } else { lblMessage.Text = "PurchaseOrder Not Found"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "PurchaseOrder ID Not Valid"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "PurchaseOrder ID Not in right format"; lblMessage.ForeColor = Color.Red; } } catch { throw; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (ddlOrderType.SelectedValue != "0" && ddlBillNo.SelectedValue != "0") { if (ddlOrderType.SelectedValue == "1") { int saleOrderID = Convert.ToInt32(ddlBillNo.SelectedValue); Database.SalesOrder saleOrder = context.SalesOrders.Where(x => x.SaleOrderID == saleOrderID).SingleOrDefault(); if (saleOrder.BillNo == ddlBillNo.SelectedItem.Text) { saleOrder.ModifiedBy = currentUserName; saleOrder.ModifiedDate = DateTime.Now.Date; int amountPaid = txtCustomerPay.Text == "" ? 0 : Convert.ToInt32(txtCustomerPay.Text); saleOrder.PaidAmount = (saleOrder.PaidAmount == null ? 0 : saleOrder.PaidAmount) + amountPaid; decimal?totalCost = saleOrder.TotalCost == null ? 0 : saleOrder.TotalCost; saleOrder.RemainingAmount = totalCost - saleOrder.PaidAmount; context.SaveChanges(); lblMessage.Text = "Payment Updated For Sale Order for " + saleOrder.BillNo; lblMessage.ForeColor = Color.Green; CreatePrintDiv(saleOrder.BillNo, txtPayeeName.Text, amountPaid); } else { lblMessage.Text = "Not Found Bill No " + saleOrder.BillNo; lblMessage.ForeColor = Color.Red; } } if (ddlOrderType.SelectedValue == "2") { int purchaseOrderID = Convert.ToInt32(ddlBillNo.SelectedValue); Database.InventoryOrder purchaseOrder = context.InventoryOrders.Where(x => x.IsActive == true && x.InventoryOrderID == purchaseOrderID).SingleOrDefault(); if (purchaseOrder.PurchaseBillNo == ddlBillNo.SelectedItem.Text) { purchaseOrder.ModifiedBy = currentUserName; purchaseOrder.ModifiedDate = DateTime.Now.Date; int amountPaid = txtPayToSeller.Text == "" ? 0 : Convert.ToInt32(txtPayToSeller.Text); purchaseOrder.AmountPaid = (purchaseOrder.AmountPaid == null ? 0 : purchaseOrder.AmountPaid) + amountPaid; decimal?totalCost = purchaseOrder.TotalOrderAmount == null ? 0 : purchaseOrder.TotalOrderAmount; purchaseOrder.BalanceAmount = totalCost - purchaseOrder.AmountPaid; purchaseOrder.AmountPaidDate = DateTime.Now.Date; context.SaveChanges(); lblMessage.Text = "Payment Updated For Sale Order for " + purchaseOrder.PurchaseBillNo; lblMessage.ForeColor = Color.Green; CreatePrintDiv(purchaseOrder.PurchaseBillNo, txtPayeeName.Text, amountPaid); } else { lblMessage.Text = "Not Found Bill No " + purchaseOrder.PurchaseBillNo; lblMessage.ForeColor = Color.Red; } } } } catch (Exception ex) { Helper.LogError(ex); lblMessage.Text = "Something went Wrong kindly check log"; lblMessage.ForeColor = Color.Red; } }