public async Task <IActionResult> GetDue(CustomerDue request) { try { acc.REST_KeepLogRequest("", func.JsonSerialize(request)); dt = new DataTable(); dt = await acc.CheckExistingRegister(request.IDCard); if (dt.Rows.Count == 0) { return(BadRequest(func.ResponseWithUnAuthorize("Not Register"))); } PaymentDue data = new PaymentDue(); data = cus.REST_GetPaymentCurrentDue(request.IDCard, request.BirthDay, request.AgreementNo); if (data.DueDate == null) { return(NotFound(data)); } return(Ok(data)); } catch (Exception e) { acc.REST_KeepLogRequest(e.Message, func.JsonSerialize(request)); return(BadRequest(e.Message)); } }
private void ResetButton_Click(object sender, EventArgs e) { PaymentDue.Clear(); VATAmount.Clear(); SubTotal.Clear(); HoursText.ResetText(); DevelopmentOptions.SelectedIndex = -1; }
public void InsertIntoDB() { foreach (DatagramTransactionPaymentSalesTax tax in SalesTax) { tax.InsertIntoDB(); } foreach (DatagramTransactionPaymentVAT vAT in VAT) { vAT.InsertIntoDB(); } foreach (DatagramTransactionPaymentPrepayment prepayment in Prepayment) { prepayment.InsertIntoDB(); } PaymentDue.InsertIntoDB(); string connectionString = @"Data Source=LOCALHOST\SQLEXPRESS;Initial Catalog=TLGPizza;Integrated Security=True"; using (SqlConnection connection = new SqlConnection(connectionString)) { string insertStmt = "INSERT INTO [TLGPizza].[Payment] (PurchaseTotal, Notes) VALUES(@purchaseTotal, @notes);"; using (SqlCommand cmd = new SqlCommand(insertStmt, connection)) { cmd.CommandText = insertStmt; cmd.Parameters.Add("@purchaseTotal", SqlDbType.Decimal); cmd.Parameters.Add("@notes", SqlDbType.VarChar); cmd.Parameters["@purchaseTotal"].Value = PurchaseTotal.Amount; cmd.Parameters["@notes"].Value = Notes; connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); } } }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { if (string.IsNullOrEmpty(InvoiceNo)) { yield return(new ValidationResult("InvoiceNo harus diisi", new List <string> { "InvoiceNo" })); } if (string.IsNullOrEmpty(From)) { yield return(new ValidationResult("From harus diisi", new List <string> { "From" })); } if (string.IsNullOrEmpty(To)) { yield return(new ValidationResult("To harus diisi", new List <string> { "To" })); } if (SailingDate == default(DateTimeOffset)) { yield return(new ValidationResult("SailingDate harus diisi", new List <string> { "SailingDate" })); } if (string.IsNullOrEmpty(Consignee)) { yield return(new ValidationResult("Consignee harus diisi", new List <string> { "Consignee" })); } if (string.IsNullOrEmpty(ShippingPer)) { yield return(new ValidationResult("ShippingPer harus diisi", new List <string> { "ShippingPer" })); } //if (string.IsNullOrEmpty(ConfirmationOfOrderNo)) // yield return new ValidationResult("ConfirmationOfOrderNo harus diisi", new List<string> { "ConfirmationOfOrderNo" }); if (string.IsNullOrEmpty(ShippingStaff)) { yield return(new ValidationResult("ShippingStaff harus diisi", new List <string> { "ShippingStaff" })); } if (string.IsNullOrEmpty(FabricType)) { yield return(new ValidationResult("FabricType harus diisi", new List <string> { "FabricType" })); } //if (string.IsNullOrEmpty(BankAccount)) // yield return new ValidationResult("BankDetail harus diisi", new List<string> { "BankAccount" }); if (PaymentDue.Equals(0)) { yield return(new ValidationResult("PaymentDue harus diisi", new List <string> { "PaymentDue" })); } if (string.IsNullOrEmpty(CPrice)) { yield return(new ValidationResult("CPrice harus diisi", new List <string> { "CPrice" })); } if (string.IsNullOrEmpty(ConsigneeAddress)) { yield return(new ValidationResult("ConsigneeAddress harus diisi", new List <string> { "ConsigneeAddress" })); } if (Items.Count == 0) { yield return(new ValidationResult("Detail harus Diisi", new List <string> { "ItemsCount" })); } else { int errorItemsCount = 0; List <Dictionary <string, object> > errorItems = new List <Dictionary <string, object> >(); foreach (var item in Items) { Dictionary <string, object> errorItem = new Dictionary <string, object>(); if (string.IsNullOrWhiteSpace(item.RONo)) { errorItem["RONo"] = "RONo tidak boleh kosong"; errorItemsCount++; } if (item.Quantity == 0) { errorItem["Quantity"] = "Quantity tidak boleh 0"; errorItemsCount++; } if (item.Price == 0) { errorItem["Price"] = "Price tidak boleh 0"; errorItemsCount++; } errorItems.Add(errorItem); } if (errorItemsCount > 0) { yield return(new ValidationResult(JsonConvert.SerializeObject(errorItems), new List <string> { "Items" })); } } if (GarmentShippingInvoiceAdjustments.Count > 0) { int errorAdjustmentCount = 0; List <Dictionary <string, object> > errorAdjustments = new List <Dictionary <string, object> >(); foreach (var item in GarmentShippingInvoiceAdjustments) { Dictionary <string, object> errorItem = new Dictionary <string, object>(); if (string.IsNullOrEmpty(item.AdjustmentDescription) && item.AdjustmentValue > 0) { errorItem["AdjustmentDescription"] = "AdjustmentDescription tidak boleh kosong"; errorAdjustmentCount++; } if (item.AdjustmentValue == 0 && item.AdjustmentDescription != "") { errorItem["AdjustmentValue"] = "AdjustmentValue tidak boleh 0"; errorAdjustmentCount++; } errorAdjustments.Add(errorItem); } if (errorAdjustmentCount > 0) { yield return(new ValidationResult(JsonConvert.SerializeObject(errorAdjustments), new List <string> { "GarmentShippingInvoiceAdjustments" })); } } }