class DbSaveController < ApplicationController
  	def index
		@id = params[:id]
		@date = params[:date]
		@title = params[:title]
		@sum = params[:sum]
		@status = params[:status]

		if(@status == '1') 
			@status_name = 'Открыто'
		else 
			@status_name = 'Закрыто'
		end
		
		# Save order
		sv_order = OrdersDB.new
		sv_order.id = @id
		sv_order.date = @date
		sv_order.title = @title
		sv_order.sum = @sum
		sv_order.status = @status
		#sv_order.save

		# Show result
		#@result = sv_order.find(:all,
		#			:conditions => "status" = '1')
		@result = OrdersDB.find_by_sql("SELECT id, title FROM alps ORDER BY id DESC")
		@count = OrdersDB.count

		# Update data
		
		begin
			OrdersDB.find(2)
		rescue
			print 'Такого идентификатора - НЕТ.'
		else
			updates = OrdersDB.find_by_sql("SELECT id FROM alps WHERE id=2")
			replace = updates[0]
			replace.title = "Подключение жилого подъезда"
			replace.save
		end
		
		#updates.update_attributes(:name => "Подключение жилого подъезда")
		
		# Delete
		begin
			OrdersDB.find(2)
		rescue	
			print 'Такого идентификатора - НЕТ.'
		else 	
			OrdersDB.delete(2)
		end


		# Save work group

		# Save works

		# Save materials
	end	
end


class OrdersDB < ActiveRecord::Base
	self.table_name = "alps"
end

class WorkGroupDB < ActiveRecord::Base
	self.table_name = "eployees_done"
end

class WorksDB < ActiveRecord::Base
	self.table_name = "works_done"
end

class MaterialsDB < ActiveRecord::Base
	self.table_name = "materials_done"
end