public ActionResult Index(Object sender)
{
GasChannelDB _database = new GasChannelDB();
_database.InputDataVariants.RemoveRange(_database.InputDataVariants.Where(o => o.Owner.ID_User == _users.CurrentUser.ID_User));
_database.SaveChanges();
return(RedirectToAction("Index"));
}
public SimpleMembershipInitializer()
{
Database.SetInitializer <GasChannelDB>(null);
try
{
using (var context = new GasChannelDB())
{
if (!context.Database.Exists())
{
// Создание базы данных SimpleMembership без применения миграции Entity Framework
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
// Настройка ASP.NET Simple Membership
// 1 параметр - имя строки подключения к базе данных.
// 2 параметр - таблица, которая содержит информацию о пользователях
// 3 параметр - имя колонки в таблице, которая отвечает за хранение логина
// 4 параметр - autoCreateTables автоматическое создание таблиц если они не существуют в базе
WebSecurity.InitializeDatabaseConnection("GasChannelConnection", "UserProfile", "ID_User", "UserName", autoCreateTables: true);
SimpleRoleProvider roles = (SimpleRoleProvider)Roles.Provider;
SimpleMembershipProvider membership = (SimpleMembershipProvider)Membership.Provider;
// Проверка наличия роли Admin
if (!roles.RoleExists("Admin"))
{
roles.CreateRole("Admin");
}
// Проверка наличия роли Operator
if (!roles.RoleExists("Operator"))
{
roles.CreateRole("Operator");
}
// Поиск пользователя с логином admin для роли Admin
if (membership.GetUser("admin", false) == null)
{
membership.CreateUserAndAccount("admin", "qwe123"); // создание пользователя
roles.AddUsersToRoles(new[] { "admin" }, new[] { "Admin" }); // установка роли для пользователя
}
//// Поиск пользователя с логином user1 для роли Operator
//if (membership.GetUser("user1", false) == null)
//{
// membership.CreateUserAndAccount("user1", "qwe123"); // создание пользователя
// roles.AddUsersToRoles(new[] { "user1" }, new[] { "Operator" }); // установка роли для пользователя
//}
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
public ActionResult Index(InputDataVariants inputDataVariants)
{
GasChannelDB _database = new GasChannelDB();
#region --- Ввод тестовых данных в базу данных
int _ID_Variant_1 = _database.Variants.Where(p => p.NameVariant == "Вариант 1" && p.Owner.ID_User == _users.CurrentUser.ID_User).First().ID_Variant;
InputDataVariants inputDataVariants_1 = new InputDataVariants
{
ID_Variant = _ID_Variant_1,
Kol_prod_gorenija = 19165,
Ro_0 = 1.28,
Ro_v = 1.29,
H_pechi = 3.55,
L_pechi = 2.15,
T_fume = 1223,
T_fume_v = 1198,
L_vert = 1,
b_vert = 0.7,
H_vert = 3,
lambda_vert = 0.05,
L_bor_vert_rek = 11,
Td_rek_fume_bor = 1176,
Tv_bor = 293,
H_bor = 2.15,
L_bor = 6,
T_rek = 450,
L_rek = 1.4,
W_rek = 2.5,
d_trub_rek = 57,
T_rek_vh = 1176,
W0_rek = 4.8,
n_trub = 14,
T_trub = 593,
d_h_diag = 8,
fi_s1 = 0.95,
fi_s2 = 1,
fi_d = 1.11,
fi_t_st = 1.06,
Owner = _users.CurrentUser
};
_inputDataVariants.InsertOrUpdate(inputDataVariants_1);
_inputDataVariants.Save();
#endregion --- Ввод тестовых данных в базу данных
return(RedirectToAction("Index"));
}
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
{
string provider = null;
string providerUserId = null;
if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId))
{
return(RedirectToAction("Manage"));
}
if (ModelState.IsValid)
{
// Insert a new user into the database
using (GasChannelDB db = new GasChannelDB())
{
UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
// Check if user already exists
if (user == null)
{
// Insert name into the profile table
db.UserProfiles.Add(new UserProfile {
UserName = model.UserName
});
db.SaveChanges();
OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);
return(RedirectToLocal(returnUrl));
}
else
{
ModelState.AddModelError("UserName", "Пользователь с таким именем уже существует. Пожалуйста, введите другое имя.");
}
}
}
ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
ViewBag.ReturnUrl = returnUrl;
return(View(model));
}
public ActionResult Demo()
{
GasChannelDB gcdb = new GasChannelDB();
if (gcdb.Variants.Where(p => p.Owner.ID_User == _users.CurrentUser.ID_User).FirstOrDefault() == null)
{
double _Kol_prod_gorenija = 19165;
double _Ro_0 = 1.28;
double _Ro_v = 1.29;
double _H_pechi = 3.55;
double _L_pechi = 2.15;
double _T_fume = 1223;
double _T_fume_v = 1198;
double _L_vert = 1;
double _b_vert = 0.7;
double _H_vert = 3;
double _lambda_vert = 0.05;
double _L_bor_vert_rek = 11;
double _Td_rek_fume_bor = 1176;
double _Tv_bor = 293;
double _T_rek = 450;
double _L_rek = 1.4;
double _W_rek = 2.5;
double _d_trub_rek = 57;
double _T_rek_vh = 1176;
double _W0_rek = 4;
int _n_trub = 14;
double _T_trub = 593;
double _d_h_diag = 8;
double _fi_s1 = 0.95;
double _fi_s2 = 1;
double _fi_d = 1.11;
double _fi_t_st = 1.06;
string _NameDefaultVariant = "Шаблон";
Variants var_default = new Variants
{
NameVariant = _NameDefaultVariant,
DateVariant = System.DateTime.Now,
Owner = _users.CurrentUser
};
_variants.InsertOrUpdate(var_default);
_variants.Save();
int _ID_Variant_new = gcdb.Variants.Where(p => p.NameVariant == _NameDefaultVariant && p.Owner.ID_User == _users.CurrentUser.ID_User).First().ID_Variant;
InputDataVariants inputDataVariants_new = new InputDataVariants
{
ID_Variant = _ID_Variant_new,
Kol_prod_gorenija = _Kol_prod_gorenija,
Ro_0 = _Ro_0,
Ro_v = _Ro_v,
H_pechi = _H_pechi,
L_pechi = _L_pechi,
T_fume = _T_fume,
T_fume_v = _T_fume_v,
L_vert = _L_vert,
b_vert = _b_vert,
H_vert = _H_vert,
lambda_vert = _lambda_vert,
L_bor_vert_rek = _L_bor_vert_rek,
Td_rek_fume_bor = _Td_rek_fume_bor,
Tv_bor = _Tv_bor,
T_rek = _T_rek,
L_rek = _L_rek,
W_rek = _W_rek,
d_trub_rek = _d_trub_rek,
T_rek_vh = _T_rek_vh,
W0_rek = _W0_rek,
n_trub = _n_trub,
T_trub = _T_trub,
d_h_diag = _d_h_diag,
fi_s1 = _fi_s1,
fi_s2 = _fi_s2,
fi_d = _fi_d,
fi_t_st = _fi_t_st,
Owner = _users.CurrentUser
};
_inputDataVariants.InsertOrUpdate(inputDataVariants_new);
_inputDataVariants.Save();
}
int _ID_Variant_First = gcdb.Variants.First(p => p.Owner.ID_User == _users.CurrentUser.ID_User).ID_Variant;
GasChannelLib.GasChannelLib gcl = new GasChannelLib.GasChannelLib();
#region --- Задать исходные данные для первого найденного варианта
gcl.Kol_prod_gorenija = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).Kol_prod_gorenija;
gcl.Ro_0 = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).Ro_0;
gcl.Ro_v = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).Ro_v;
gcl.H_pechi = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).H_pechi;
gcl.L_pechi = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).L_pechi;
gcl.T_fume = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).T_fume;
gcl.T_fume_v = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).T_fume_v;
gcl.L_vert = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).L_vert;
gcl.b_vert = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).b_vert;
gcl.H_vert = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).H_vert;
gcl.lambda_vert = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).lambda_vert;
gcl.L_bor_vert_rek = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).L_bor_vert_rek;
gcl.Td_rek_fume_bor = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).Td_rek_fume_bor;
gcl.Tv_bor = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).Tv_bor;
gcl.T_rek = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).T_rek;
gcl.L_rek = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).L_rek;
gcl.W_rek = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).W_rek;
gcl.d_trub_rek = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).d_trub_rek;
gcl.T_rek_vh = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).T_rek_vh;
gcl.W0_rek = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).W0_rek;
gcl.n_trub = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).n_trub;
gcl.T_trub = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).T_trub;
gcl.d_h_diag = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).d_h_diag;
gcl.fi_s1 = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).fi_s1;
gcl.fi_s2 = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).fi_s2;
gcl.fi_d = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).fi_d;
gcl.fi_t_st = _inputDataVariants.All.First(p => p.Variants.ID_Variant == _ID_Variant_First && p.Owner.ID_User == _users.CurrentUser.ID_User).fi_t_st;
#endregion --- Задать исходные данные для первого найденного варианта
ViewBag.InputData = gcl;
ViewBag.ID_Variant = new SelectList(_variants.All.Where(t => t.Owner.ID_User == _users.CurrentUser.ID_User), "ID_Variant", "NameVariant");
ViewBag.NameNewVariant = "Новый вариант";
return(View());
}
public ActionResult Demo(InputDataModel InputData, string NameNewVariant)
{
GasChannelDB gcdb = new GasChannelDB();
double _Kol_prod_gorenija = double.Parse(InputData.Kol_prod_gorenija.ToString());
double _Ro_0 = double.Parse(InputData.Ro_0.ToString());
double _Ro_v = double.Parse(InputData.Ro_v.ToString());
double _H_pechi = double.Parse(InputData.H_pechi.ToString());
double _L_pechi = double.Parse(InputData.L_pechi.ToString());
double _T_fume = double.Parse(InputData.T_fume.ToString());
double _T_fume_v = double.Parse(InputData.T_fume_v.ToString());
double _L_vert = double.Parse(InputData.L_vert.ToString());
double _b_vert = double.Parse(InputData.b_vert.ToString());
double _H_vert = double.Parse(InputData.H_vert.ToString());
double _lambda_vert = double.Parse(InputData.lambda_vert.ToString());
double _L_bor_vert_rek = double.Parse(InputData.L_bor_vert_rek.ToString());
double _Td_rek_fume_bor = double.Parse(InputData.Td_rek_fume_bor.ToString());
double _Tv_bor = double.Parse(InputData.Tv_bor.ToString());
double _H_bor = double.Parse(InputData.H_bor.ToString());
double _L_bor = double.Parse(InputData.L_bor.ToString());
double _T_rek = double.Parse(InputData.T_rek.ToString());
double _L_rek = double.Parse(InputData.L_rek.ToString());
double _W_rek = double.Parse(InputData.W_rek.ToString());
double _d_trub_rek = double.Parse(InputData.d_trub_rek.ToString());
double _T_rek_vh = double.Parse(InputData.T_rek_vh.ToString());
double _W0_rek = double.Parse(InputData.W0_rek.ToString());
int _n_trub = int.Parse(InputData.n_trub.ToString());
double _T_trub = double.Parse(InputData.T_trub.ToString());
double _d_h_diag = double.Parse(InputData.d_h_diag.ToString());
double _fi_s1 = double.Parse(InputData.fi_s1.ToString());
double _fi_s2 = double.Parse(InputData.fi_s2.ToString());
double _fi_d = double.Parse(InputData.fi_d.ToString());
double _fi_t_st = double.Parse(InputData.fi_t_st.ToString());
string _NameNewVariant = NameNewVariant.ToString();
Variants var_new = new Variants
{
NameVariant = _NameNewVariant,
DateVariant = System.DateTime.Now,
Owner = _users.CurrentUser
};
_variants.InsertOrUpdate(var_new);
_variants.Save();
int _ID_Variant_new = gcdb.Variants.Where(p => p.NameVariant == _NameNewVariant && p.Owner.ID_User == _users.CurrentUser.ID_User).First().ID_Variant;
InputDataVariants inputDataVariants_new = new InputDataVariants
{
ID_Variant = _ID_Variant_new,
Kol_prod_gorenija = _Kol_prod_gorenija,
Ro_0 = _Ro_0,
Ro_v = _Ro_0,
H_pechi = _H_pechi,
L_pechi = _L_pechi,
T_fume = _T_fume,
T_fume_v = _T_fume_v,
L_vert = _L_vert,
b_vert = _b_vert,
H_vert = _H_vert,
L_bor_vert_rek = _L_bor_vert_rek,
Td_rek_fume_bor = _Td_rek_fume_bor,
Tv_bor = _Tv_bor,
H_bor = _H_bor,
L_bor = _L_bor,
T_rek = _T_rek,
L_rek = _L_rek,
W_rek = _W_rek,
d_trub_rek = _d_trub_rek,
T_rek_vh = _T_rek_vh,
W0_rek = _W0_rek,
n_trub = _n_trub,
T_trub = _T_trub,
d_h_diag = _d_h_diag,
fi_s1 = _fi_s1,
fi_s2 = _fi_s2,
fi_d = _fi_d,
fi_t_st = _fi_t_st,
Owner = _users.CurrentUser
};
_inputDataVariants.InsertOrUpdate(inputDataVariants_new);
_inputDataVariants.Save();
return(RedirectToAction("Demo", "Home"));
}
