/// <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)); }