/// <summary>
/// Insert/Update of Vehicle Purchase
/// </summary>
/// <param name="objPurchase"></param>
/// <returns></returns>
public int VehiclePurchaseInsertUpdate(VehiclePurchase objPurchase)
{
int i = 0;
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_VehiclePurchaseInsertUpdate";
cmd.Parameters.AddWithValue("@PurchaseID", objPurchase.PurchaseID);
cmd.Parameters.AddWithValue("@PurchaseDate", objPurchase.PurchaseDate);
cmd.Parameters.AddWithValue("@DeliveryDate", objPurchase.DeliveryDate);
cmd.Parameters.AddWithValue("@SupplierID", objPurchase.SupplierID);
cmd.Parameters.AddWithValue("@PONumber", objPurchase.PONumber);
cmd.Parameters.AddWithValue("@POValue", objPurchase.POValue);
cmd.Parameters.AddWithValue("@TradeLicenseID", objPurchase.TradeLicenseID);
cmd.Parameters.AddWithValue("@BuyBack", objPurchase.BuyBack);
cmd.Parameters.AddWithValue("@UserId", objPurchase.UserId);
cmd.Parameters.AddWithValue("@IsActive", objPurchase.IsActive);
//SqlParameter output = new SqlParameter("@Return_Value", SqlDbType.Int);
//output.Direction = ParameterDirection.ReturnValue;
//cmd.Parameters.Add(output);
cmd.ExecuteNonQuery();
i = 1;
}
}
catch (Exception ex)
{
i = 0;
throw ex;
}
return(i);
}
/// <summary>
/// Insert/Update of Vehicle Purchase
/// </summary>
/// <param name="objPurchase"></param>
/// <returns></returns>
public int VehiclePurchaseInsertUpdate(VehiclePurchase objPurchase)
{
return(objDal.VehiclePurchaseInsertUpdate(objPurchase));
}
