public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (Minutes != 0)
{
str += "&minutes=\"" + Minutes + "\"";
}
if (TrainDate != null)
{
str += "&traindate=\"" + TrainDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
private async void CreateUserRoles(IServiceProvider serviceProvider)
{
var roleManager = serviceProvider.GetRequiredService <RoleManager <IdentityRole> >();
var userManager = serviceProvider.GetRequiredService <UserManager <IDUser> >();
var adminRole = await roleManager.FindByNameAsync(ChatConstants.AdminRole);
if (adminRole == null)
{
adminRole = new IdentityRole(ChatConstants.AdminRole);
//create the roles and seed them to the database
await roleManager.CreateAsync(adminRole);
await roleManager.CreateAsync(new IdentityRole(ChatConstants.MemberRole));
}
//Assign Admin role to the main User here we have given our newly registered
//login id for Admin management
var user = await userManager.FindByNameAsync("admin");
if (user == null)
{
user = new IDUser()
{
UserName = "******",
Email = "*****@*****.**",
};
await userManager.CreateAsync(user, "pass_WORD_1234");
await userManager.AddToRoleAsync(user, ChatConstants.AdminRole);
}
}
public override string ToString()
{
string str = "";
str += "&idserver= \"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser= \"" + IDUser.ToString() + "\"";
}
if (Goal != 0)
{
str += "&goal= \"" + Goal.ToString() + "\"";
}
if (StartGoal != null)
{
str += "&startgoal= \"" + StartGoal.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (InsertDate != null)
{
str += "&insertdate= \"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate= \"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (WValue != 0)
{
str += "&weight=\"" + WValue.ToString() + "\"";
}
if (WeightDate != null)
{
str += "&weightdate=\"" + WeightDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
public override string ToString()
{
string str = "ID: " + IDUser.ToString() + " Name: " + FullName +
" Lg: " + Login + " Em: " + Email;
return(str);
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (AlertTime != null)
{
str += "&alerttime=\"" + AlertTime /*.ToString("yyyy-MM-dd HH:mm:ss")*/ + "\"";
}
if (Status != -1)
{
str += "&status=\"" + Status.ToString() + "\"";
}
if (MealType != -1)
{
str += "&mealtype=\"" + MealType.ToString() + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (!Title.Equals(""))
{
str += "&title=\"" + Title + "\"";
}
if (!MessageText.Equals(""))
{
str += "&messagetext=\"" + MessageText + "\"";
}
str += "&seen=\"" + seen.ToString() + "\"";
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
string currentUserlogged = WindowsUser.Username;
try
{
_iDUser = new DUser();
_iDRole = new DRole();
_iFUser = new FUser(_iDUser);
_iFRole = new FRole(_iDRole);
return(_iFUser.IsMethodAccessible(currentUserlogged, AllowedRoles.ToList()));
}
catch (Exception)
{
return(false);
}
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (BeginDate != null)
{
str += "&begindate=\"" + BeginDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (EndDate != null)
{
str += "&enddate=\"" + EndDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (Price != 0)
{
str += "&price=\"" + Price.ToString() + "\"";
}
if (IsActive != 0)
{
str += "&isactive=\"" + IsActive.ToString() + "\"";
}
if (Trncode != null && !Trncode.Equals(""))
{
str += "&trncode=\"" + Trncode + "\"";
}
if (Deleted != 0)
{
str += "&deleted=\"" + Deleted.ToString() + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
internal async Task <IdentityResult> Register(string firstname, string lastname, string username, string password)
{
var user = new IDUser
{
FirstName = firstname,
LastName = lastname,
UserName = username
};
var res = await _manager.CreateAsync(user, password);
if (res.Succeeded)
{
await _signInManager.RefreshSignInAsync(user);
await _manager.AddToRoleAsync(user, ChatConstants.MemberRole);
}
return(res);
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (Name != null)
{
str += "&name=\"" + Name + "\"";
}
if (!Description.Equals(""))
{
str += "&description=\"" + Description + "\"";
}
if (IDLang != -1)
{
str += "&idlang=\"" + IDLang.ToString() + "\"";
}
if (IDUser != 0)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (IsActive != -1)
{
str += "&isActive=\"" + IsActive.ToString() + "\"";
}
if (Deleted != 0)
{
str += "&deleted=\"" + Deleted.ToString() + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
public async Task <HttpResponseMessage> UpdateStatus([FromBody] IDUser user)
{
try
{
if (user != null)
{
AditionalAccountOperations ac = new AditionalAccountOperations();
await ac.UpdateStatus(user);
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Parámetro nulo"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public static string GenerateToken(IDUser user)
{
var securityKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(key));
var credentials = new SigningCredentials(securityKey, SecurityAlgorithms.HmacSha256);
var claims = new Claim[]
{
new Claim(JwtRegisteredClaimNames.Sub, user.Id),
new Claim(JwtRegisteredClaimNames.UniqueName, user.UserName),
new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
new Claim(JwtRegisteredClaimNames.Iat, DateTime.UtcNow.ToString())
};
var secToken = new JwtSecurityToken(
signingCredentials: credentials,
issuer: "Server",
audience: "People",
claims: claims,
expires: DateTime.UtcNow.AddDays(1));
var handler = new JwtSecurityTokenHandler();
return(handler.WriteToken(secToken));
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (IDCategory != 0)
{
str += "&idcategory=\"" + IDCategory.ToString() + "\"";
}
if (IDMealUnit != 0)
{
str += "&idmealunit=\"" + IDServerMealUnit.ToString() + "\"";
}
if (Qty != 0)
{
str += "&qty=\"" + Qty.ToString() + "\"";
}
if (MealDate != null)
{
str += "&mealdate=\"" + MealDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
public override string ToString()
{
string str = "";
str += "&idserver=\"" + IDServer.ToString() + "\"";
if (IDUnit != -1)
{
str += "&idunit=\"" + IDUnit.ToString() + "\"";
}
if (IDServerMeal != -1)
{
str += "&idmeal=\"" + IDServerMeal.ToString() + "\"";
}
if (IDUser != 0)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (Calories != -1)
{
str += "&calories=\"" + Calories.ToString() + "\"";
}
if (Protein != -1)
{
str += "&protein=\"" + Protein.ToString() + "\"";
}
if (Carb != -1)
{
str += "&carb=\"" + Carb.ToString() + "\"";
}
if (Fat != -1)
{
str += "&fat=\"" + Fat.ToString() + "\"";
}
if (SatFat != -1)
{
str += "&satfat=\"" + SatFat.ToString() + "\"";
}
if (UnSatFat != -1)
{
str += "&unsatfat=\"" + UnSatFat.ToString() + "\"";
}
if (Cholesterol != -1)
{
str += "&cholesterol=\"" + Cholesterol.ToString() + "\"";
}
if (Sugar != -1)
{
str += "&sugar=\"" + Sugar.ToString() + "\"";
}
if (Natrium != -1)
{
str += "&natrium=\"" + Natrium.ToString() + "\"";
}
if (Potassium != -1)
{
str += "&potassium=\"" + Potassium.ToString() + "\"";
}
if (Fiber != -1)
{
str += "&fiber=\"" + Fiber.ToString() + "\"";
}
if (Deleted != -1)
{
str += "&deleted=\"" + Deleted.ToString() + "\"";
}
if (InsertDate != null)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != null)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
return(str.Substring(1));
}
public FUser()
{
_iDRoles = new DRole();
_iDUser = new DUser();
}
public FUser(IDUser iDUser)
{
_iDUser = iDUser;
}
public void dbEnter(string login, string password)
{
command.CommandText = "SELECT [ID_Sotrudnika] FROM [INGPROMTORG].[dbo].[Sotrudniki] WHERE [Sotrudnika_Login] = '" + login + "' and [Sotrudnika_Password] = '" + password + "'";
try
{
connection.Open();
IDUser = Convert.ToInt32(command.ExecuteScalar().ToString());
command.CommandText = "SELECT [Dolgnost_ID] FROM [INGPROMTORG].[dbo].[Sotrudniki] WHERE [ID_Sotrudnika] like '%" + IDUser.ToString() + "%'";
Proverka = Convert.ToInt32(command.ExecuteScalar().ToString());
command.CommandText = "SELECT [Dostup_Dolgnost] FROM [INGPROMTORG].[dbo].[Dolgnost] WHERE [ID_Dolgnost] like '%" + Proverka.ToString() + "%'";
Dostup = command.ExecuteScalar().ToString();
sot = Dostup[0].ToString();
dol = Dostup[1].ToString();
pokup = Dostup[2].ToString();
usl = Dostup[3].ToString();
tovar = Dostup[4].ToString();
tovn = Dostup[5].ToString();
trann = Dostup[6].ToString();
dog = Dostup[7].ToString();
}
catch
{
IDUser = 0;
}
finally
{
connection.Close();
}
}
public FUser()
{
_iDUser = new DUser();
}
public override string ToString()
{
string str = "";
if (IDUser != -1)
{
str += "&iduser=\"" + IDUser.ToString() + "\"";
}
if (!AccessToken.Equals(""))
{
str += "&accesstoken=\"" + Uri.EscapeDataString(AccessToken) + "\"";
}
if (FacebookID != -1)
{
str += "&iduser=\"" + FacebookID.ToString() + "\"";
}
if (!FirstName.Equals(""))
{
str += "&firstname=\"" + Uri.EscapeDataString(FirstName) + "\"";
}
if (!LastName.Equals(""))
{
str += "&lastname=\"" + Uri.EscapeDataString(LastName) + "\"";
}
if (Gender != -1)
{
str += "&gender=\"" + Gender.ToString() + "\"";
}
if (!Email.Equals(""))
{
str += "&email=\"" + Uri.EscapeDataString(Email) + "\"";
}
if (!Password.Equals(""))
{
str += "&password=\"" + Password + "\"";
}
if (!Location.Equals(""))
{
str += "&location=\"" + Location + "\"";
}
if (Height != -1)
{
str += "&height=\"" + Height.ToString() + "\"";
}
if (HeightType != -1)
{
str += "&heighttype=\"" + HeightType.ToString() + "\"";
}
if (Skeleton != 0)
{
str += "&skeleton=\"" + Skeleton.ToString() + "\"";
}
if (fertility != -1)
{
str += "&fertility=\"" + Fertility.ToString() + "\"";
}
if (Birthdate != null)
{
str += "&birthdate=\"" + Birthdate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (RemindDate != null)
{
str += "&reminddate=\"" + RemindDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (InsertDate != DateTime.MinValue)
{
str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (UpdateDate != DateTime.MinValue)
{
str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\"";
}
if (AdjustDiet != -1)
{
str += "&adjustdiet=\"" + AdjustDiet.ToString() + "\"";
}
return(str.Substring(1));
}
public FUser(IDRole iDRole, IDUser iDUser)
{
_iDRoles = iDRole;
_iDUser = iDUser;
}
internal bool IsLoggedIn(IDUser iDUser)
{
return(AllSocketInstances.ContainsKey(iDUser.UserName));
}
