public bool RegisterUser(RegisterModel model) { using (SqlConnection connection = new SqlConnection(CONSTANT.connectBD)) { ID_user = Guid.NewGuid().ToString(); //model.typeShop = "340eb5f2-0ffd-411b-9cf2-318a60b22604"; Type_shop = TYPE_SHOP.GetName(model.typeShop); model.Email = model.Email.Trim(); string sqlExpression = @"INSERT INTO USERS ( ID_user, Type_shop, Email, Password ) VALUES( '" + ID_user + @"', '" + model.typeShop + @"', '" + model.Email + @"', '" + model.Password + @"' ) "; connection.Open(); SqlCommand command = new SqlCommand(); command.CommandText = sqlExpression; command.Connection = connection; int numbInsUser = command.ExecuteNonQuery(); // если успешно вставились данные if (numbInsUser > 0) { //создание времени работы string id_TimeWork = TimeWork.CreateTimeWork(); if (id_TimeWork != "") { if (Shop.CreateShop(ID_user, Type_shop, id_TimeWork)) { return(true); } } } } return(false); }
public RegisterModel() { TYPE_SHOPs = TYPE_SHOP.GetListTP(); }