using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DataAccess.Data.impl.SQL
{
    internal static class SQLStrings
    {
        public static string SQL_SERVER = "ealdb1.eal.local";
        public static string DB_NAME = "EJL14_DB";
        public static string USER_ID = "ejl14_usr";
        public static string PASSWORD = "Baz1nga14";

        public static string CONNECTION_STRING = @"Data Source=" + SQL_SERVER + ";Initial Catalog=" + DB_NAME + ";Persist Security Info=True;User ID=" + USER_ID + ";Password=" + PASSWORD + ";Timeout=5";
        
        
        //Customers StoredProcedure Names
        public static string LOAD_ALL_CUSTOMERS_PROCEDURE_NAME = "labi_GetAllCustomers"; //mama_GetallCustomers
        public static string LOAD_CUSTOMER_PROCEDURE_NAME = "labi_GetCustomer"; //mama_GetCustomer
        public static string CREATE_CUSTOMER_PROCEDURE_NAME = "labi_CreateCustomer"; //mama_CreateCustomer
        public static string UPDATE_CUSTOMER_PROCEDURE_NAME = "labi_UpdateCustomer"; //mama_UpdateCustomer
        public static string DELETE_CUSTOMER_PROCEDURE_NAME = "labi_DeleteCustomer"; //mama_DeleteCustomer
        
        
        //Customer StroedProcedure Names
        public static string LOAD_ORDER_PROCEDURE_NAME = "Your Name";
        public static string LOAD_ALL_ORDERS_PROCEDURE_NAME = "Your Name";
        public static string CREATE_ORDER_PROCEDURE_NAME = "Your Name";
        public static string UPDATE_ORDER_PROCEDURE_NAME = "Your Name";
        public static string DELETE_ORDER_PROCEDURE_NAME = "Your Name";
        public static string FIND_ORDERS_FROM_CUSTOMER_PROCEDURE_NAME = "Mama_GetAllOrders";

        
    }
}