public int AddETA(List <OrderInvoiceEntity> entity)
{
ConvertEntitiesDL obj = new ConvertEntitiesDL();
DataTable table = obj.ConvertInvoiceETAListToDataTable(entity);
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spUpdateEtaInvoiceOrder", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter INVOrderNo = cmd.Parameters.AddWithValue("@INVOrderNo", table.Rows[0][0].ToString());
SqlParameter ETADate = cmd.Parameters.AddWithValue("@ETADATE", table.Rows[0][1].ToString());
return((int)cmd.ExecuteScalar());
}
}
}
