protected void saveButton_Click(object sender, EventArgs e) { string msg = string.Empty; SalesOrderBLL salesOrder = new SalesOrderBLL(); DataTable dtPrdList = new DataTable(); DataRow dr = null; decimal quantity = 0; double rate = 0; double amount = 0; TextBox orderQuantityTextBox; TextBox ratePerUnitTextBox; TextBox amountTextBox; int i = 0; dtPrdList.Columns.Add("ProductId"); dtPrdList.Columns.Add("Available"); dtPrdList.Columns.Add("Quantity"); dtPrdList.Columns.Add("RatePerUnit"); dtPrdList.Columns.Add("VATPercentage"); dtPrdList.Columns.Add("Amount"); //dtPrdList.Columns.Add("Height"); //dtPrdList.Columns.Add("Width"); try { if (totalAmountTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Total Amount field is required."; return; } else if (vatTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "VAT field is required."; return; } else if (receivedAmountTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Received Amount field is required."; return; } else if (customerIdDropDownList.SelectedValue == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer ID field is required."; return; } else if (customerIdDropDownList.SelectedValue == "Retail" && customerNameTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer Name field is required."; return; } else if (customerIdDropDownList.SelectedValue == "Retail" && customerContactNumberTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer Contact Number field is required."; return; } else if (customerIdDropDownList.SelectedValue == "Retail" && customerAddressTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Customer Address field is required."; return; } //else if (transportTypeDropDownList.SelectedValue == "") //{ // msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Transport Type field is required."; // return; //} if (paymentModeDropDownList.SelectedValue == "Cheque") { if (chequeNumberTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Cheque Number field is required."; return; } else if (chequeDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Cheque Date field is required."; return; } else if (bankDropDownList.Text == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Bank Name field is required."; return; } else if (bankBranchTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Bank Branch Name field is required."; return; } } for (i = 0; i < selectedProductListGridView.Rows.Count; i++) { orderQuantityTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("orderQuantityTextBox"); ratePerUnitTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("ratePerUnitTextBox"); amountTextBox = (TextBox)selectedProductListGridView.Rows[i].FindControl("amountTextBox"); if (string.IsNullOrEmpty(orderQuantityTextBox.Text.Trim()) || !decimal.TryParse(orderQuantityTextBox.Text.Trim(), out quantity)) { msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid quantity."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } else if (string.IsNullOrEmpty(ratePerUnitTextBox.Text.Trim()) || !double.TryParse(ratePerUnitTextBox.Text.Trim(), out rate)) { msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid rate."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } else if (string.IsNullOrEmpty(amountTextBox.Text.Trim()) || !double.TryParse(amountTextBox.Text.Trim(), out amount)) { msg = "Product ID [" + selectedProductListGridView.Rows[i].Cells[0].Text.ToString() + "] has no valid amount."; msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = msg; return; } else { dr = dtPrdList.NewRow(); dr["ProductId"] = selectedProductListGridView.Rows[i].Cells[1].Text.ToString(); dr["Available"] = selectedProductListGridView.Rows[i].Cells[4].Text.ToString(); dr["Quantity"] = quantity.ToString(); dr["RatePerUnit"] = rate.ToString(); dr["VATPercentage"] = selectedProductListGridView.Rows[i].Cells[7].Text.ToString(); dr["Amount"] = amount.ToString(); //dr["Height"] = "0.00"; //dr["Width"] = "0.00"; dtPrdList.Rows.Add(dr); } } salesOrder.SalesCenterId = ddlSelectWareHouseOrSalesCenter.SelectedValue; salesOrder.CustomerId = customerIdDropDownList.SelectedValue.Trim(); salesOrder.CustomerName = customerNameTextBox.Text.Trim(); salesOrder.CustomerContactNumber = customerContactNumberTextBox.Text.Trim(); salesOrder.CustomerAddress = customerAddressTextBox.Text.Trim(); salesOrder.SalesCenterId = ddlSelectWareHouseOrSalesCenter.SelectedValue; salesOrder.SalesPersonId = LumexSessionManager.Get("ActiveUserId").ToString(); salesOrder.DeliveryDate = LumexLibraryManager.ParseAppDate(deliveryDateTextBox.Text.Trim()); salesOrder.Narration = txtNaration.Text.Trim(); salesOrder.TransportType = transportTypeDropDownList.SelectedValue.Trim(); salesOrder.PaymentMode = paymentModeDropDownList.SelectedValue; salesOrder.AccountId = accountHeadDropDownList.SelectedValue; salesOrder.Bank = bankDropDownList.Text.Trim(); salesOrder.BankBranch = bankBranchTextBox.Text.Trim(); salesOrder.ChequeNumber = chequeNumberTextBox.Text.Trim(); salesOrder.ChequeDate = LumexLibraryManager.ParseAppDate(chequeDateTextBox.Text.Trim()); salesOrder.LCNumber = lcNumberTextBox.Text.Trim(); salesOrder.ShippingAddress = shippingAddressTextBox.Text.Trim(); salesOrder.BillingAddress = billingAddressTextBox.Text.Trim(); salesOrder.TotalAmount = totalAmountTextBox.Text.Trim(); salesOrder.DiscountAmount = discountTextBox.Text.Trim(); salesOrder.VAT = vatTextBox.Text.Trim(); salesOrder.TotalReceivable = receivableAmountTextBox.Text.Trim(); salesOrder.Due = DuesAmoutPayTextBox.Text; salesOrder.ReceivedAmount = receivedAmountTextBox.Text.Trim(); salesOrder.ChangeAmount = (Convert.ToDecimal(salesOrder.ReceivedAmount) - Convert.ToDecimal(salesOrder.TotalReceivable)).ToString(); // salesOrder.ChangeAmount = changeAmountTextBox.Text.Trim(); //salesOrder.TotalVATAmount = CalculateTotalVATAmount().ToString(); salesOrder.TotalVATAmount = totalVATAmountHiddenField.Value; if (dtPrdList.Rows.Count == selectedProductListGridView.Rows.Count) { string salesRecordId = salesOrder.SaveSalesOrder(dtPrdList); string message = "Product's <span class='actionTopic'>Sales</span> Successfully with Sale ID: <span class='actionTopic'>" + salesRecordId + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesOrder/CreateSalesOrder.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } //MyAlertBox("alert(\"Retail Sales Created Successfully with Sales ID: " + salesRecordId.Trim() + " \"); window.location=\"/UI/Sales/RetailSalesList.aspx\""); //Response.Redirect("/UI/Sales/RetailSalesList.aspx", false); // } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { salesOrder = null; dtPrdList = null; } }