Hi
I have below 2 classes & want to insert record using Ado.Net
public class Invoice
{
public Invoice()
{
}
[Key]
public string No { get; set; }
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:dd/MM/yyyy}", ApplyFormatInEditMode = true)]
public string DocDate { get; set; }
public virtual ICollection InvoiceDetails { get; set; }
public string Status { get; set; }
}
public partial class InvoiceDetail
{
public string DocNo { get; set; }
public Product Id { get; set; }
public decimal Quantity { get; set; }
public Nullable price { get; set; }
public Nullable GrossAmount { get; set; }
public Nullable NetAmount { get; set; }
}
Trying like below but it is not showing Invoice Details fields.
public int Add(Invoice objInvoice)
{
int i;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand("sp_Invoice", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@No", objInvoice.No);
cmd.Parameters.AddWithValue("@No", objInvoice.DocDate);
cmd.Parameters.AddWithValue("@No", objInvoice.Po_No);
cmd.Parameters.AddWithValue("@No", objInvoice.PO_Date);
cmd.Parameters.AddWithValue("@Action", "C");
i = cmd.ExecuteNonQuery();
}
return i;
}
Thanks