Esempio n. 1
0
        public System.Web.Http.Results.OkNegotiatedContentResult <ReturnCodeModel> SaveRestaurantMenuCategory([FromBody] RestaurantMenuCategoryModel restaurantMenuCategory)
        {
            try
            {
                Int32 recordId = 0;

                SqlConnection myConnection = new SqlConnection();
                myConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["DBConnection"];
                SqlCommand sqlCmd = new SqlCommand();
                sqlCmd.CommandText = "spSaveRestaurantMenuCategory";
                sqlCmd.CommandType = CommandType.StoredProcedure;
                sqlCmd.Connection  = myConnection;

                SqlParameter parameter = new SqlParameter();
                parameter.ParameterName = "@Restaurant_Menu_Category_Id";
                parameter.SqlDbType     = SqlDbType.Int;
                parameter.Size          = 4;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurantMenuCategory.RestaurantMenuCategoryId;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Restaurant_Id";
                parameter.SqlDbType     = SqlDbType.Int;
                parameter.Size          = 4;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurantMenuCategory.RestaurantId;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Restaurant_Menu_Category";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 150;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurantMenuCategory.RestaurantMenuCategory;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Sort_Index";
                parameter.SqlDbType     = SqlDbType.Int;
                parameter.Size          = 4;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurantMenuCategory.SortIndex;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@End_Date";
                parameter.SqlDbType     = SqlDbType.DateTime;
                parameter.Size          = 8;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurantMenuCategory.EndDate;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Return_Id";
                parameter.SqlDbType     = SqlDbType.Int;
                parameter.Size          = 4;
                parameter.Direction     = ParameterDirection.Output;
                sqlCmd.Parameters.Add(parameter);


                myConnection.Open();
                sqlCmd.ExecuteNonQuery();
                recordId = (Int32)parameter.Value;
                myConnection.Close();

                ReturnCodeModel returnCodeModel = new ReturnCodeModel();
                returnCodeModel.RecordId   = recordId;
                returnCodeModel.ReturnCode = "success";
                returnCodeModel.Message    = "The record has been saved successfully";

                return(Ok(content: returnCodeModel));
            }
            catch (Exception ex)
            {
                ExceptionModel.SaveException(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), System.Reflection.MethodInfo.GetCurrentMethod().Name);
                return(null);
            }
        }
Esempio n. 2
0
        public System.Web.Http.Results.OkNegotiatedContentResult <ReturnCodeModel> SaveRestaurant([FromBody] RestaurantModel restaurant)
        {
            try
            {
                Int32 recordId = 0;

                SqlConnection myConnection = new SqlConnection();
                myConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["DBConnection"];
                SqlCommand sqlCmd = new SqlCommand();
                sqlCmd.CommandText = "spSaveRestaurant";
                sqlCmd.CommandType = CommandType.StoredProcedure;
                sqlCmd.Connection  = myConnection;


                SqlParameter parameter = new SqlParameter();
                parameter.ParameterName = "@Restaurant_Id";
                parameter.SqlDbType     = SqlDbType.Int;
                parameter.Size          = 4;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.RestaurantId;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Restaurant_Name";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 100;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.RestaurantName;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Address";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 50;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.Address;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@City";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 50;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.City;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@State";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 50;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.State;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Zip_Code";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 20;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.ZipCode;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Email_Address";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 50;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.EmailAddress;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Restaurant_Image_URL";
                parameter.SqlDbType     = SqlDbType.VarChar;
                parameter.Size          = 1000;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.RestaurantImageURL;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Sales_Tax_Percent";
                parameter.SqlDbType     = SqlDbType.Decimal;
                parameter.Size          = 10;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.SalesTaxPercentage;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@End_Date";
                parameter.SqlDbType     = SqlDbType.DateTime;
                parameter.Size          = 8;
                parameter.Direction     = ParameterDirection.Input;
                parameter.Value         = restaurant.EndDate;
                sqlCmd.Parameters.Add(parameter);

                parameter = new SqlParameter();
                parameter.ParameterName = "@Return_Id";
                parameter.SqlDbType     = SqlDbType.Int;
                parameter.Size          = 4;
                parameter.Direction     = ParameterDirection.Output;
                sqlCmd.Parameters.Add(parameter);


                myConnection.Open();
                sqlCmd.ExecuteNonQuery();
                recordId = (Int32)parameter.Value;
                myConnection.Close();

                ReturnCodeModel returnCodeModel = new ReturnCodeModel();
                returnCodeModel.RecordId   = recordId;
                returnCodeModel.ReturnCode = "success";
                returnCodeModel.Message    = "The record has been saved successfully";

                return(Ok(content: returnCodeModel));
            }
            catch (Exception ex)
            {
                ExceptionModel.SaveException(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), System.Reflection.MethodInfo.GetCurrentMethod().Name);
                return(null);
            }
        }