public Invoice(DTO_Invoice inv) { InvoiceID = inv.InvoiceID; ClaimID = inv.ClaimID; InvoiceTypeID = inv.InvoiceTypeID; VendorID = inv.VendorID; InvoiceAmount = inv.InvoiceAmount; InvoiceDate = inv.InvoiceDate; Paid = inv.Paid; }
public async Task AddInvoice(DTO_Invoice token) { try { var response = await client.PostAsJsonAsync(string.Format(@"{0}{1}", URL, "AddInvoice"), token); response.EnsureSuccessStatusCode(); Invoice = await response.Content.ReadAsAsync <DTO_Invoice>(); } catch (Exception e) { Console.Write(e.StackTrace); } }
public List <DTO_Invoice> GetInvoiceDAO(string sql) { List <DTO_Invoice> list = new List <DTO_Invoice>(); SqlCommand cmd = new SqlCommand(sql, dp.cnn); SqlDataReader dr; int MaHoaDon; int MaMonNuoc; int MaBan; dp.Connect(); //SqlConnection cnn = dp.getConnect(); //cnn.Open(); try { dr = cmd.ExecuteReader(); //SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { MaHoaDon = dr.GetInt32(0); MaMonNuoc = dr.GetInt32(1); MaBan = dr.GetInt32(2); DTO_Invoice prod = new DTO_Invoice(MaHoaDon, MaMonNuoc, MaBan); list.Add(prod); } return(list); } catch (SqlException ex) { return(null); throw ex; } finally { dp.DisConnect(); } }