private void AddDataToPost(Post post, PostItemModel model, UserItemModel curUser)
{
post.Title = model.Title;
post.StartDate = model.StartDate;
post.EndDate = model.EndDate;
post.ShortDesc = model.ShortDesc;
post.FullDesc = model.FullDesc;
#region Image
if (CheckHaveNewImage(post, model))
{
var imageUrl = new ImageURLModel();
var imageOriganalUrl = $"{ImageHelper.IMAGE_URL}{model.ID}/{ImageHelper.IMAGE_ORIGINAL_Folder}/";
var imageThumbPathURL = $"{ImageHelper.IMAGE_URL}{model.ID}/{ImageHelper.IMAGE_THUMB_Folder}/";
var imageThumbPath = Server.MapPath(imageThumbPathURL);
var imageOriganalPhy = Server.MapPath(model.AvataImage);
imageUrl.AvataImage = new AvataImageUrlModel()
{
Original = model.AvataImage,
Medium = imageThumbPathURL + ImageHelper.ResizeImageMedium(imageOriganalPhy, imageThumbPath),
Thumb = imageThumbPathURL + ImageHelper.ResizeImageThumb(imageOriganalPhy, imageThumbPath)
};
imageUrl.ImageList = ImageHelper.GetImageInFolder(Server.MapPath(imageOriganalUrl));
post.ImageURL = JsonConvert.SerializeObject(imageUrl);
}
#endregion
#region SEO
post.SeoTitle = model.SeoTitle;
post.SeoDescription = model.SeoDescription;
post.SeoKeyword = model.SeoKeyword;
#endregion
#region Add Setting
if (!post.IsShow && model.IsShow)
{
post.IsShow = model.IsShow;
post.PublicBy = curUser.Id;
post.PublicDate = DateTime.Now;
}
post.IsHot = model.IsHot;
post.IsAllowComment = model.IsAllowComment;
#endregion
#region Add Category
post.Categories.Clear();
//var cat = ol.Posts.Where(model.CategoriesID.);
#endregion
}
public IHttpActionResult AddToCart(UserItemModel model)
{
if (model.Quantity <= 0)
{
return(BadRequest("Cannot add 0 or negative quantity"));
}
var cartItem = Manager.AddItemToCart(model.UserId, model.ItemId, model.Quantity);
if (cartItem == null)
{
return(BadRequest("Item Not Found"));
}
return(Ok("Added " + cartItem.Quantity));
}
private void fmUserForm_Load(object sender, EventArgs e)
{
try
{
string conToDb = @"Data Source=dell7020\sqlexpress;Initial Catalog=GridUserForm;Integrated Security=True";
using (SqlConnection con = new SqlConnection(conToDb))
{
con.Open();
// запит на конкретного користувача за Id (того користувача який залогінюється)
string query = "SELECT * FROM tblUsers, tblUserProfile "
+ $"WHERE tblUserProfile.Id = {id}";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = con;
sqlCommand.CommandText = query;
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
TimeSpan span = DateTime.Now - Convert.ToDateTime(reader["DateBirth"]);
var user = new UserItemModel
{ // читаємо усю його інфу
Id = int.Parse(reader["Id"].ToString()),
FullName = reader["Lastname"].ToString() + " " + reader["Firstname"].ToString() + " " + reader["Secondname"].ToString(),
Email = reader["Email"].ToString(),
Role = reader["Role"].ToString(),
Age = span.Days / 365,
Phone = reader["Phone"].ToString(),
Sex = Convert.ToBoolean(reader["Sex"]),
IsActive = Convert.ToBoolean(reader["IsActive"])
};
// і розкидаємо по відповідним лейблам
lbFullNameInfo.Text = user.FullName;
lbEmailInfo.Text = user.Email;
lbBirthInfo.Text = Convert.ToDateTime(reader["DateBirth"]).ToString("dd.MM.yyyy") + " (" + user.Age.ToString() + " років)";
lbRoleInfo.Text = user.Role;
lbSexInfo.Text = user.Sex == true ? "чоловіча" : "жіноча";
lbStatusInfo.Text = user.IsActive == true ? "активний" : "забанений";
lbPhoneInfo.Text = user.Phone;
}
reader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show($"Помилка завантаження даних\n\t{ex.Message}", ex.Message);
}
}
internal Task SetAndShow(UserItemModel uim)
{
_uim = uim;
ItemName = uim.ItemTypeName;
ItemAmount = uim.Amount;
UnitPrice = 0;
SellingAmount = 0;
dynamic settings = new ExpandoObject();
settings.WindowStartupLocation = WindowStartupLocation.CenterOwner;
settings.ResizeMode = ResizeMode.NoResize;
settings.Title = "Create Sell Offer";
return(_wm.ShowDialogAsync(this, null, settings));
}
// зчитуємо усіх користувачів і заливає у грід
private void fmMain_Load(object sender, EventArgs e)
{
try
{
string conToDb = @"Data Source=dell7020\sqlexpress;Initial Catalog=GridUserForm;Integrated Security=True";
using (SqlConnection con = new SqlConnection(conToDb))
{
con.Open();
string query = "SELECT * FROM tblUsers, tblUserProfile "
+ "WHERE tblUsers.Id = tblUserProfile.Id ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = con;
sqlCommand.CommandText = query;
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
TimeSpan span = DateTime.Now - Convert.ToDateTime(reader["DateBirth"]);
var user = new UserItemModel
{
Id = int.Parse(reader["Id"].ToString()),
FullName = reader["Lastname"].ToString() + " " + reader["Firstname"].ToString() + " " + reader["Secondname"].ToString(),
Email = reader["Email"].ToString(),
Role = reader["Role"].ToString(),
Age = span.Days / 365,
Phone = reader["Phone"].ToString(),
Sex = Convert.ToBoolean(reader["Sex"]),
};
string sex = user.Sex == true ? "чоловіча" : "жіноча";
object[] row =
{
user.Id, user.FullName, user.Email, user.Phone, user.Role, user.Age, sex
};
dvgUsers.Rows.Add(row);
}
reader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show($"Помилка завантаження даних\n\t{ex.Message}", ex.Message);
}
}
public async Task <IActionResult> Edit(string userId)
{
// получаем пользователя
ApplicationUser user = await userManager.FindByIdAsync(userId);
if (user != null)
{
// получем список ролей пользователя
var userRoles = await userManager.GetRolesAsync(user);
var allRoles = roleManager.Roles.ToList();
UserItemModel model = new UserItemModel
{
UserId = user.Id,
UserEmail = user.Email,
UserRoles = userRoles,
AllRoles = allRoles
};
return(View(model));
}
return(NotFound());
}
public static UserItemModel Convert(
this User user,
bool withFullDesc = false)
{
var _return = new UserItemModel()
{
ID = user.Id,
Email = user.Email
};
_return.FullName = user.FullName;
_return.ImageURL = string.IsNullOrEmpty(user.ImageURL) ? IMAGE_USER_DEFAULE : user.ImageURL;
_return.AuthorName = user.AuthorName;
if (withFullDesc)
{
_return.Description = user.Description;
}
else
{
_return.ImageURL = IMAGE_USER_DEFAULE;
}
return(_return);
}
public EditViewModel(HttpContext context, UserItemModel itemToEdit, IEnumerable <UserListModel> lists, UserListModel selectedList) : base(context)
{
ItemToEdit = itemToEdit;
Lists = lists;
SelectedList = selectedList;
}
