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; } }
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; } }
public void UpdateSaleOrder() { try { if (rptrData.Items.Count != 0 || chkIsMakingRequired.Checked) { string saleOrderIDObj = hdnSaleOrderID.Value; if (!string.IsNullOrEmpty(saleOrderIDObj)) { int saleID = Convert.ToInt32(saleOrderIDObj); var saleCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == saleID); if (saleCollection.Count() > 0) { using (TransactionScope scope = new TransactionScope()) { Database.SalesOrder saleOrder = saleCollection.FirstOrDefault(); saleOrder.BillNo = txtBillNo.Text; saleOrder.ClassName = txtClass.Text; saleOrder.ModifiedBy = currentUserName; saleOrder.ModifiedDate = DateTime.Now; saleOrder.CustomerID = Convert.ToInt32(txtCustomerID.Text); saleOrder.CustomerTypeID = Convert.ToInt32(ddlCustomerType.SelectedValue); saleOrder.IsActive = true; saleOrder.IsCompleted = chkIsComplete.Checked; saleOrder.IsMakingRequired = chkIsMakingRequired.Checked; saleOrder.PaidAmount = txtPaidAmount.Text == "" ? 0 : Convert.ToDecimal(txtPaidAmount.Text); //Profit is set at the end of all items //saleOrder.Profit= saleOrder.Remarks = txtRemarks.Text; saleOrder.SaleOrderDate = Convert.ToDateTime(txtSellingDate.Text); saleOrder.TotalCost = txtTotalOrderAmount.Text == "" ? 0 : Convert.ToDecimal(txtTotalOrderAmount.Text); //Below due to total cost above set saleOrder.RemainingAmount = saleOrder.TotalCost - saleOrder.PaidAmount; context.SaveChanges(); if (chkIsMakingRequired.Checked) { string devWorkIDObj = hdnDevWorkID.Value; if (!string.IsNullOrEmpty(devWorkIDObj)) { int devWorkID = Convert.ToInt32(devWorkIDObj); var devWorkCollection = context.DevelopmentWorks.Where(x => x.IsActive == true && x.DevelopmentWorkID == devWorkID); if (devWorkCollection.Count() > 0) { //Developement work detail DevelopmentWork dwork = devWorkCollection.FirstOrDefault(); dwork.BillNo = saleOrder.BillNo; dwork.BottomMeasurement = txtBottomMeasurement.Text; if (txtConfirmDate.Text != "") { dwork.ConfirmDate = Convert.ToDateTime(txtConfirmDate.Text); } dwork.ModifiedBy = currentUserName; dwork.ModifiedDate = DateTime.Now.Date; if (txtDeliveryDate.Text != "") { dwork.DeliveryDate = Convert.ToDateTime(txtDeliveryDate.Text); } if (fileuploadDesign.FileName != "") { string fileNamePath = ConfigurationManager.AppSettings[Constants.ConfigDesignPhotoPath] + "\\" + fileuploadDesign.FileName; fileuploadDesign.SaveAs(fileNamePath); dwork.DesignPhotoUrl = ConfigurationManager.AppSettings[Constants.ConfigDesignPhotoURL] + "\\" + fileuploadDesign.FileName; } dwork.InventoryTypeID = Convert.ToInt32(txtMakingInventoryType.Text); dwork.IsActive = true; dwork.MakingCost = txtMakingCost.Text == "" ? 0 : Convert.ToDecimal(txtMakingCost.Text); dwork.SaleOrderID = saleOrder.SaleOrderID; dwork.TopMeasurement = txtTopMeasurement.Text; dwork.WorkTypeID = Convert.ToInt32(ddlWorkType.SelectedValue); context.SaveChanges(); } } } decimal?profit = 0; List <rptrClass> printLst = new List <rptrClass>(); if (rptrData.Items.Count > 0) { foreach (RepeaterItem rptrItem in rptrData.Items) { if (rptrItem.Visible) { int saleOrderDetailID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnSaleOrderDetailID")).Value); var saleOrderDetailCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderDetailID == saleOrderDetailID); if (saleOrderDetailCollection.Count() > 0) { Database.SaleOrderDetail saleOrderDetail = saleOrderDetailCollection.FirstOrDefault(); var oldQuantity = saleOrderDetail.Quantity; saleOrderDetail.ModifiedBy = currentUserName; saleOrderDetail.ModifiedDate = DateTime.Now; saleOrderDetail.InventoryTypeID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnItemID")).Value); saleOrderDetail.IsActive = true; saleOrderDetail.Quantity = Convert.ToInt32(((Label)rptrItem.FindControl("lblQuantity")).Text); saleOrderDetail.SaleOrderID = saleOrder.SaleOrderID; saleOrderDetail.SellingRate = Convert.ToDecimal(((Label)rptrItem.FindControl("lblSellingRate")).Text); saleOrderDetail.TotalAmount = Convert.ToDecimal(((Label)rptrItem.FindControl("lblTotalAmount")).Text); saleOrderDetail.VAT = ((Label)rptrItem.FindControl("lblVat")).Text; context.SaveChanges(); Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == saleOrderDetail.InventoryTypeID).SingleOrDefault(); if (currentInventory != null) { var invCount = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount; currentInventory.InventoryCount = invCount + (oldQuantity - saleOrderDetail.Quantity); context.SaveChanges(); decimal?pRate = currentInventory.PurchaseRate == null ? 0 : currentInventory.PurchaseRate; decimal?sRate = saleOrderDetail.SellingRate == null ? 0 : saleOrderDetail.SellingRate; profit = profit + (sRate - pRate); } rptrClass obj = new rptrClass(); obj.ItemName = ((Label)rptrItem.FindControl("lblItemName")).Text; obj.Quantity = Convert.ToString(saleOrderDetail.Quantity); obj.SellingRate = Convert.ToString(saleOrderDetail.SellingRate); obj.TotalAmount = Convert.ToString(saleOrderDetail.TotalAmount); obj.VAT = saleOrderDetail.VAT; printLst.Add(obj); } } else { int saleOrderDetailID = Convert.ToInt32(((HiddenField)rptrItem.FindControl("hdnSaleOrderDetailID")).Value); var saleOrderCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderDetailID == saleOrderDetailID); if (saleOrderCollection.Count() > 0) { Database.SaleOrderDetail saleOrderDetail = saleOrderCollection.FirstOrDefault(); var oldQuantity = saleOrderDetail.Quantity; saleOrderDetail.ModifiedBy = currentUserName; saleOrderDetail.ModifiedDate = DateTime.Now; saleOrderDetail.IsActive = false; context.SaveChanges(); Database.InventoryType currentInventory = context.InventoryTypes.Where(x => x.IsActive == true && x.InventoryTypeId == saleOrderDetail.InventoryTypeID).SingleOrDefault(); if (currentInventory != null) { var invCount = currentInventory.InventoryCount == null ? 0 : currentInventory.InventoryCount; currentInventory.InventoryCount = invCount + oldQuantity; context.SaveChanges(); } } } } } saleOrder.Profit = profit; context.SaveChanges(); lblMessage.Text = "Record updated sucessfully of BILL NO " + saleOrder.BillNo; lblMessage.ForeColor = Color.Green; CreatePrintDiv(saleOrder.BillNo, txtAutoCustomerName.Text, saleOrder.TotalCost, printLst); txtSellingDate.Text = DateTime.Now.ToString(Constants.DateFormatDatePicker); scope.Complete(); } } else { lblMessage.Text = "Sale Order ID Not Found "; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Sale Order ID Not in proper format "; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Sale Order is not proper "; lblMessage.ForeColor = Color.Red; } } catch { throw; } }
public void FillForm() { try { string SaleOrderIDObj = Request.QueryString[Constants.querySaleOrderID]; if (!string.IsNullOrEmpty(SaleOrderIDObj)) { int SaleOrderID = Convert.ToInt32(SaleOrderIDObj); if (SaleOrderID > 0) { var SaleCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID); if (SaleCollection.Count() > 0) { Database.SalesOrder saleOrder = SaleCollection.FirstOrDefault(); txtBalance.Text = Convert.ToString(saleOrder.RemainingAmount); txtBillNo.Text = saleOrder.BillNo; txtClass.Text = saleOrder.ClassName; txtCustomerID.Text = Convert.ToString(saleOrder.CustomerID); txtPaidAmount.Text = Convert.ToString(saleOrder.PaidAmount); txtRemarks.Text = saleOrder.Remarks; txtSellingDate.Text = saleOrder.SaleOrderDate == null ? "" : saleOrder.SaleOrderDate.Value.ToString(Constants.DateFormatDatePicker); txtTotalOrderAmount.Text = Convert.ToString(saleOrder.TotalCost); ddlCustomerType.SelectedValue = Convert.ToString(saleOrder.CustomerTypeID); chkIsComplete.Checked = saleOrder.IsCompleted == null ? false : Convert.ToBoolean(saleOrder.IsCompleted); chkIsMakingRequired.Checked = saleOrder.IsMakingRequired == null ? false : Convert.ToBoolean(saleOrder.IsMakingRequired); int?customerID = saleOrder.CustomerID; if (customerID != null) { var customerCollection = context.Customers.Where(x => x.CustomerID == customerID); if (customerCollection.Count() > 0) { Database.Customer customer = customerCollection.FirstOrDefault(); txtAutoCustomerName.Text = customer.CustomerName; } } if (saleOrder.IsMakingRequired == true) { var devWorkCollection = context.DevelopmentWorks.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID); if (devWorkCollection.Count() > 0) { Database.DevelopmentWork devWork = devWorkCollection.FirstOrDefault(); txtAutoMakingInventoryType.Text = Convert.ToString(devWork.InventoryTypeID); txtBottomMeasurement.Text = devWork.BottomMeasurement; txtConfirmDate.Text = devWork.ConfirmDate == null ? "" : devWork.ConfirmDate.Value.ToString(Constants.DateFormatDatePicker); txtDeliveryDate.Text = devWork.DeliveryDate == null ? "" : devWork.DeliveryDate.Value.ToString(Constants.DateFormatDatePicker); txtMakingCost.Text = Convert.ToString(devWork.MakingCost); txtMakingInventoryType.Text = Convert.ToString(devWork.InventoryTypeID); txtTopMeasurement.Text = devWork.TopMeasurement; ddlWorkType.SelectedValue = Convert.ToString(devWork.WorkTypeID); int?invTypeID = devWork.InventoryTypeID; if (invTypeID != null) { var invCollection = context.InventoryTypes.Where(x => x.InventoryTypeId == invTypeID); if (invCollection.Count() > 0) { Database.InventoryType inventory = invCollection.FirstOrDefault(); txtAutoMakingInventoryType.Text = inventory.InventoryTypeName; } } } else { //Nothing to Do } } var saleDetailCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID).AsEnumerable(); var data = from saleDetail in saleDetailCollection join inv in context.InventoryTypes.Where(x => x.IsActive == true).AsEnumerable() on saleDetail.InventoryTypeID equals inv.InventoryTypeId select new rptrClass { ItemCode = inv.InventoryCode, ItemID = inv.InventoryTypeId.ToString(), ItemName = inv.InventoryTypeName, Quantity = saleDetail.Quantity.ToString(), SellingRate = saleDetail.SellingRate.ToString(), TotalAmount = saleDetail.TotalAmount.ToString(), VAT = saleDetail.VAT, SaleOrderDetailID = saleDetail.SaleOrderDetailID }; rptrData.DataSource = data.ToList(); rptrData.DataBind(); hdnSaleOrderID.Value = Convert.ToString(SaleOrderID); } else { lblMessage.Text = "Customer Not Found"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not Valid"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not in right format"; lblMessage.ForeColor = Color.Red; } } catch { throw; } }