private int GetUserAssessment(int idUser, int idHomework)
{
var db = new DbConfig();
var sr = new Screening();
var assessment = 0;
var sqlQuary = "SELECT assessment " +
" FROM h_assessment " +
" WHERE id_user = "******" and id_homework = " + sr.GetScr() + idHomework + sr.GetScr();
foreach (var item in db.GetSqlQuaryData(sqlQuary))
{
assessment += Int32.Parse(item[0]);
}
return(assessment);
}
public async Task <IActionResult> CreateGroup(string title, string description, IFormFile photoGroup = null)
{
var idPic = GetIdForPic();
var downloadCode = await Picture.Download(idPic, photoGroup);
if (downloadCode == Picture.DownloadCodes.Fine)
{
var db = new DbConfig();
var sr = new Screening();
var login =
HttpContext.Session.GetString("login");
var userId = UserModel.GetId(login);
var photoType = sr.GetScr() + photoGroup.FileName.Split(".").Last() + sr.GetScr();
var sqlQuaryCreateGroup = $@"
INSERT INTO groups(
title, description, id_pic , id_founder)
VALUES ({sr.GetScr() +title +sr.GetScr()},
{sr.GetScr() + description + sr.GetScr()},
{sr.GetScr() + idPic + sr.GetScr() } ,{userId}); ";
var sqlQuaryCreatePicture = $@"
INSERT INTO pictures(guid, type_pic)
VALUES ({sr.GetScr() + idPic + sr.GetScr() }, {photoType});";
var sqlQuaryGetIdGroup = $@"
SELECT id
FROM groups
WHERE id_founder = {userId}
ORDER BY id DESC
LIMIT 1 ;";
db.UseSqlQuary(sqlQuaryCreatePicture);
db.UseSqlQuary(sqlQuaryCreateGroup);
var groupData = db.GetSqlQuaryData(sqlQuaryGetIdGroup);
var idGroup = -1;
foreach (var item in groupData)
{
idGroup = Convert.ToInt32(item[0]);
}
return(await Task.Run(() => RedirectToAction("ShowGroup", new RouteValueDictionary(
new { controller = "Group", action = "ShowGroup", idGroup = idGroup }))));
}
return(await Task.Run(() => RedirectToAction("Index", new RouteValueDictionary(
new { controller = "Home", action = "Index" }))));
}
private bool IsRegisterEmail(string Email)
{
var db = new DbConfig();
var sr = new Screening();
var sqlQuary = "select id from users where mail = " + sr.GetScr() + Email + sr.GetScr();
var userData = db.GetSqlQuaryData(sqlQuary);
if (userData.Count() > 0)
{
return(true);
}
return(false);
}
static public int GetId(string login)
{
var db = new DbConfig();
var sr = new Screening();
var sqlQuary = "select id from users where login = " + sr.GetScr() + login + sr.GetScr();
var idUser = -1;
foreach (var userData in db.GetSqlQuaryData(sqlQuary))
{
idUser = Convert.ToInt32(userData[0]);
}
return(idUser);
}
private Guid GetIdForPic()
{
var db = new DbConfig();
var sr = new Screening();
var NewIdPic = Guid.NewGuid();
while (true)
{
var sqlQuary = $@" SELECT guid
From Pictures
WHERE guid = {sr.GetScr() + NewIdPic + sr.GetScr()}";
var picId = db.GetSqlQuaryData(sqlQuary);
if (picId.Count() > 0)
{
NewIdPic = Guid.NewGuid();
}
else
{
break;
}
}
return(NewIdPic);
}
public IActionResult UpdateInfopPage()
{
var sr = new Screening();
var db = new DbConfig();
var login = HttpContext.Session.GetString("login");
var usersData =
db.GetSqlQuaryData("SELECT first_name,second_name,picture_profile FROM users " +
" WHERE users.login = " + sr.GetScr() + login + sr.GetScr());
var userData = new List <string>();
foreach (var item in usersData)
{
userData = item;
}
var user = new UserModel();
user.first_name = userData[0];
user.second_name = userData[1];
user.picture_profile = userData[2];
ViewBag.User_data = user;
return(View());
}
public async Task <IActionResult> Reg(string _mail, string _login, string _password, string _password2)
{
var db = new DbConfig();
HttpContext.Session.SetString("reg_mail", "" + _mail);
HttpContext.Session.SetString("reg_login", "" + _login);
if (_password != _password2)
{
return(await Task.Run(() => RedirectToAction("Reg", new { type = 1 })));
}
else
{
if (_password.Length > 8)
{
var sr = new Screening();
var usersId = GetUserId(_login);
if (usersId == -1)
{
var ex = new Regex("^[0-9A-Za-z]{1}[0-9A-Za-z_-]*@{1}[A-Za-z]+[.][A-Za-z]+$");
if (ex.IsMatch(_mail))
{
if (IsRegisterEmail(_mail))
{
return(await Task.Run(() => RedirectToAction("Reg", new { type = 3 })));
}
db.UseSqlQuary("INSERT INTO users(mail,login,password) " +
" VALUES " +
" (" + sr.GetScr() + _mail + sr.GetScr() +
" ,lower(" + sr.GetScr() + _login + sr.GetScr() +
"),crypt(" + sr.GetScr() + _password + sr.GetScr() + ", gen_salt('bf', 8)))");
return(await Task.Run(() => RedirectToAction("Authorization", new{ ex = 3 })));
}
else
{
return(await Task.Run(() => RedirectToAction("Reg", new { type = 4 })));
}
}
else
{
Console.WriteLine("2");
return(await Task.Run(() => RedirectToAction("Reg", new { type = 2 })));
}
}
else
{
return(await Task.Run(() => RedirectToAction("Reg", new { type = 5 })));
}
}
}
public async Task <IActionResult> SearchGroup(string name = null)
{
var sr = new Screening();
var db = new DbConfig();
var sqlQuarySelectGroupByName = "";
if (string.IsNullOrEmpty(name))
{
sqlQuarySelectGroupByName = $@"
SELECT id, title, description, pictures.guid , type_pic
FROM groups inner join pictures on
groups.id_pic = pictures.guid
";
}
else
{
sqlQuarySelectGroupByName = $@"
SELECT id, title, description, pictures.guid , type_pic
FROM groups inner join pictures on
groups.id_pic = pictures.guid WHERE title = {sr.GetScr() + name + sr.GetScr()}
";
}
var groups = new List <GroupModel>();
var groupsData = db.GetSqlQuaryData(sqlQuarySelectGroupByName);
foreach (var item in groupsData)
{
var group = new GroupModel(item[3], item[4]);
group.idGroup = Int32.Parse(item[0]);
group.title = item[1];
group.description = item[2];
groups.Add(group);
}
ViewBag.Groups = groups;
ViewBag.SearchName = name;
return(await Task.Run(() => View()));
}
public async Task <IActionResult> AddPost(int idGroup, string title, string text, IFormFile file = null)
{
//here need check (is user group )
//add change to upload file with some material .doc ect
// here a early version. Please if u want upgrade the func u can do it :)
// Last date edit 21.06.2020
var db = new DbConfig();
var sr = new Screening();
var sqlQuaryAddPost = $@"
INSERT INTO public.group_post( id_group, title, description)
VALUES ( {sr.GetScr() + idGroup + sr.GetScr()},
{sr.GetScr() + title + sr.GetScr()},
{sr.GetScr() + text + sr.GetScr()});";
db.UseSqlQuary(sqlQuaryAddPost);
return(await Task.Run(() => RedirectToAction("ShowGroup", new RouteValueDictionary(
new { controller = "Group", action = "ShowGroup", idGroup = idGroup }))));
}
public async Task <IActionResult> UpdateInfo(string first_name, string second_name, IFormFile u_file = null)
{
string filePath = "";
string file_name = "";
var sr = new Screening();
var db = new DbConfig();
var _login = HttpContext.Session.GetString("login");
if (_login == "")
{
return(RedirectToAction("Authorization", new RouteValueDictionary(
new { controller = "User ", action = "Profile" })));
}
else
{
if (u_file != null)
{
string [] type = u_file.FileName.Split('.');
type[1] = type[1].ToUpper();
if ((type[1] == "PNG") || (type[1] == "JPEG") || (type[1] == "JPG"))
{
string [] type_pic = u_file.FileName.Split('.');
Guid id_pic = Guid.NewGuid();
filePath = "wwwroot\\Pictures\\" + id_pic + "." + type_pic[1];
file_name = "" + id_pic + "." + type_pic[1];
Console.WriteLine("2 -- -- -- " + filePath + " -- " + id_pic);
Bitmap myBitmap;
using (Stream fs = new FileStream(filePath, FileMode.OpenOrCreate))
{
await u_file.CopyToAsync(fs);
Console.WriteLine(fs.Position + " --- - - - -- " + u_file.Length);
while (fs.Position != u_file.Length)
{
} // ожидание загрузки изображения
myBitmap = new Bitmap(fs);
Console.WriteLine(myBitmap.Width + " -+_+-" + myBitmap.Height);
}
Image img = myBitmap;
var im_w = myBitmap.Width;
var im_h = myBitmap.Height;
if (im_w > im_h)
{
im_w = im_h;
}
else
{
im_h = im_w;
}
//XXX тут надо нормально пререписать как вырезать изображение :)
img = img.Crop(new Rectangle(0, 0, im_w, im_h));
img.Save(filePath);
}
else
{
return(RedirectToAction("UpdateInfo_page", new RouteValueDictionary(
new { controller = "User", action = "UpdateInfo_page" })));
}
db.UseSqlQuary("UPDATE users set first_name = " + sr.GetScr() + first_name
+ sr.GetScr() + " ,second_name = " + sr.GetScr() + second_name + sr.GetScr() + "," +
"picture_profile = " + sr.GetScr() + file_name + sr.GetScr() +
" WHERE users.login = "******"UPDATE users set first_name = " + sr.GetScr() + first_name
+ sr.GetScr() + " ,second_name = " + sr.GetScr() + second_name + sr.GetScr() + " " +
" WHERE users.login = "******"Profile", new RouteValueDictionary(
new { controller = "User", action = "Profile" })));
}
