public int Update(UltrasoundInvoice ultrasoundInvoice)
{
UpdateCommand.Parameters["@ID"].Value = ultrasoundInvoice.ID;
UpdateCommand.Parameters["@InvoiceNo"].Value = ultrasoundInvoice.InvoiceNo;
UpdateCommand.Parameters["@ItemTypeID"].Value = ultrasoundInvoice.ItemTypeID;
UpdateCommand.Parameters["@Description"].Value = ultrasoundInvoice.Description;
UpdateCommand.Parameters["@UnitCost"].Value = ultrasoundInvoice.UnitCost;
UpdateCommand.Parameters["@Qty"].Value = ultrasoundInvoice.Qty;
UpdateCommand.Parameters["@AmountCost"].Value = ultrasoundInvoice.AmountCost;
UpdateCommand.Parameters["@Status"].Value = ultrasoundInvoice.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
public int Insert(UltrasoundInvoice ultrasoundInvoice)
{
InsertCommand.Parameters["@InvoiceNo"].Value = ultrasoundInvoice.InvoiceNo;
InsertCommand.Parameters["@ItemTypeID"].Value = ultrasoundInvoice.ItemTypeID;
InsertCommand.Parameters["@Description"].Value = ultrasoundInvoice.Description;
InsertCommand.Parameters["@UnitCost"].Value = ultrasoundInvoice.UnitCost;
InsertCommand.Parameters["@Qty"].Value = ultrasoundInvoice.Qty;
InsertCommand.Parameters["@AmountCost"].Value = ultrasoundInvoice.AmountCost;
InsertCommand.Parameters["@Status"].Value = ultrasoundInvoice.Status;
int returnValue = -1;
try
{
InsertCommand.Connection.Open();
returnValue = (int)InsertCommand.ExecuteScalar();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
InsertCommand.Connection.Close();
}
return(returnValue);
}
private UltrasoundInvoice DataTableToEntity(DataTable dt)
{
UltrasoundInvoice ultrasoundInvoice = new UltrasoundInvoice();
if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0)
{
if (Null.IsNotNull(dt.Rows[0]))
{
DataRow dr = dt.Rows[0];
if (Null.IsNotNull(dr["ID"]))
{
ultrasoundInvoice.ID = Convert.ToInt32(dr["ID"]);
}
else
{
ultrasoundInvoice.ID = 0;
}
if (Null.IsNotNull(dr["InvoiceNo"]))
{
ultrasoundInvoice.InvoiceNo = Convert.ToInt32(dr["InvoiceNo"]);
}
else
{
ultrasoundInvoice.InvoiceNo = 0;
}
if (Null.IsNotNull(dr["ItemTypeID"]))
{
ultrasoundInvoice.ItemTypeID = Convert.ToInt32(dr["ItemTypeID"]);
}
else
{
ultrasoundInvoice.ItemTypeID = 0;
}
if (Null.IsNotNull(dr["Description"]))
{
ultrasoundInvoice.Description = Convert.ToString(dr["Description"]);
}
else
{
ultrasoundInvoice.Description = string.Empty;
}
if (Null.IsNotNull(dr["UnitCost"]))
{
ultrasoundInvoice.UnitCost = Convert.ToDecimal(dr["UnitCost"]);
}
else
{
ultrasoundInvoice.UnitCost = 0.00m;
}
if (Null.IsNotNull(dr["Qty"]))
{
ultrasoundInvoice.Qty = Convert.ToInt32(dr["Qty"]);
}
else
{
ultrasoundInvoice.Qty = 0;
}
if (Null.IsNotNull(dr["AmountCost"]))
{
ultrasoundInvoice.AmountCost = Convert.ToDecimal(dr["AmountCost"]);
}
else
{
ultrasoundInvoice.AmountCost = 0.00m;
}
if (Null.IsNotNull(dr["Status"]))
{
ultrasoundInvoice.Status = Convert.ToString(dr["Status"]);
}
else
{
ultrasoundInvoice.Status = string.Empty;
}
}
}
return(ultrasoundInvoice);
}
