public ActionResult ThemPYC(FormCollection collection, PHIEUYEUCAU pyc)
{
//try
//{
//TODO: Add insert logic here
var nv = collection["nv"];
var lts = collection["lts"];
var kh = collection["kh"];
//no lỗi ngay đây. nếu chặn lại thì ko sao.
pyc.ID_NHANVIEN = int.Parse(nv);
pyc.ID_LOAITAISAN = int.Parse(lts);
pyc.ID_KH = int.Parse(kh);
pyc.NGAYTAO = DateTime.Now;
pyc.TRANGTHAI = true;
data.PHIEUYEUCAUs.InsertOnSubmit(pyc);
data.SubmitChanges();
return(RedirectToAction("ThemPYC"));
//}
//catch
//{
// ViewData["nv"] = new SelectList(data.NHANVIENs.ToList().OrderBy(s => s.TENNV), "ID_NHANVIEN", "TENNV");
// ViewData["kh"] = new SelectList(data.KHACHHANGs.ToList().OrderBy(s => s.TENKH), "ID_KH", "TENKH");
// ViewData["lts"] = new SelectList(data.LOAITAISANs.ToList().OrderBy(s => s.TEN), "ID_LOAITAISAN", "TEN");
// return View();
//}
}
public ActionResult Create(User collection)
{
try
{
context.Users.InsertOnSubmit(collection);
context.SubmitChanges();
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Themnhanvien(LOAICN cn, FormCollection collection)
{
try
{
// TODO: Add insert logic here
//cn.NGAYTAO = DateTime.Now;
//cn.TRANGTHAI = true;
data.LOAICNs.InsertOnSubmit(cn);
data.SubmitChanges();
return(PartialView());
}
catch
{
return(View());
}
}
public ActionResult ThemCHCC(FormCollection collection, CANHOCHUNGCU chcc)
{
try
{
// TODO: Add insert logic here
chcc.NGUOILAPPHIEU = int.Parse(collection["nlp12"]);
chcc.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
chcc.NGUOILAPPHIEU = int.Parse(collection["nlp12"]);
chcc.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
chcc.ID_DDPL = int.Parse(collection["ddpl12"]);
chcc.ID_TIENDO = int.Parse(collection["tiendo12"]);
var qh = collection["qqqq"];
chcc.ID_QUANHUYEN = int.Parse(qh);
chcc.ID_LOAIHINH = int.Parse(collection["loaihinh12"]);
chcc.ID_LTT = int.Parse(collection["loaithongtin12"]);
chcc.ID_CHITIETLOAI = int.Parse(collection["chitietloai12"]);
chcc.ID_CAPDUONG = int.Parse(collection["capduong12"]);
chcc.ID_KETCAUDUONG = int.Parse(collection["ketcau12"]);
chcc.ID_CRMD = int.Parse(collection["chieurongmatduong12"]);
chcc.SOHIEU = collection["SOHIEU"] + "/2016/PTT-CHCC";
chcc.NGAYTAO = DateTime.Now;
chcc.TRANGTHAI = true;
data.CANHOCHUNGCUs.InsertOnSubmit(chcc);
data.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void CreateUser(User userToCreate)
{
using (var context = new DatabaseClassesDataContext(DatabaseConnectionString))
{
context.Users.InsertOnSubmit(userToCreate);
context.SubmitChanges();
}
}
public ActionResult ThemLoaitaisan(LOAITAISAN a)
{
try
{
// TODO: Add insert logic here
a.NGAYTAO = DateTime.Now;
a.TRANGTHAI = true;
data.LOAITAISANs.InsertOnSubmit(a);
data.SubmitChanges();
return(RedirectToAction("Danhmuc"));
}
catch
{
return(View());
}
}
//добавляет новое событие
public void CreateEvent(int userId, string description, int fileId = 0)
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
Event newEvent = new Event();
newEvent.UserId = userId;
newEvent.FileId = fileId;
newEvent.Description = description;
newEvent.Created = DateTime.Now;
db.Events.InsertOnSubmit(newEvent);
db.SubmitChanges();
}
public ActionResult Create(FormCollection collection, NHANVIEN nvs)
{
try
{
// TODO: Add insert logic here
var pb = collection["phongban1204"];
var lnv = collection["loainhanvien1204"];
var pq = collection["phanquyen1204"];
var pass12 = collection["PASS12"];
nvs.NGAYTAO = DateTime.Now;
nvs.ID_PHONGBAN = int.Parse(pb);
nvs.ID_LOAINHANVIEN = int.Parse(lnv);
nvs.ID_PHANQUYEN = int.Parse(pq);
nvs.PASS = GenerateMD5(pass12);
data.NHANVIENs.InsertOnSubmit(nvs);
data.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewData["phongban1204"] = new SelectList(data.PHONGBANs, "ID_PHONGBAN", "TEN");
ViewData["loainhanvien1204"] = new SelectList(data.LOAINHANVIENs, "ID_LOAINHANVIEN", "TEN");
ViewData["phanquyen1204"] = new SelectList(data.PHANQUYENs, "ID_PHANQUYEN", "TEN");
return(View());
}
}
//удаляет файл
public void DeleteFile(int fileId, int userId)
{
try
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var file = (from f in db.Files
where f.FileId == fileId && f.UserId == userId && f.IsActual == true
select f).Single();
db.Files.DeleteOnSubmit(file);
db.SubmitChanges();
}
catch { };
}
public ActionResult Create(FormCollection form)
{
Dictionary <int, int> reports = new Dictionary <int, int>();
// Parse alle cijfers naar reports (Dit kan makkelijker maar kon zo snel ff niet vinden hoe
foreach (var key in form.AllKeys)
{
if (key.StartsWith("aspect[") && key.EndsWith("]"))
{
int aspect_id = Convert.ToInt32(key.Split(new char[] { '[', ']' })[1]);
if (form[key] != null && form[key] != "")
{
reports.Add(aspect_id, Convert.ToInt32(form[key]));
}
else
{
reports.Add(aspect_id, 1);
}
}
}
// Vull alle beoordeling naar database door
foreach (KeyValuePair <int, int> entry in reports)
{
Report r = new Report();
r.reporter_id = Convert.ToInt32(form.GetValue("reporter_id").AttemptedValue);
r.subject_id = Convert.ToInt32(form.GetValue("subject_id").AttemptedValue);
r.project_report_date_id = Convert.ToInt32(form.GetValue("project_report_date_id").AttemptedValue);
r.baro_aspect_id = entry.Key;
r.grade = entry.Value;
_db.Reports.InsertOnSubmit(r);
}
_db.SubmitChanges();
return(Json(new { status = "success", subject_id = Convert.ToInt32(form.GetValue("subject_id").AttemptedValue) }));
}
//создает файл
public void CreateFile(int userId, string name, string physicalPath, int directoryId, bool isPublic, long size)
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
File newFile = new File();
newFile.UserId = userId;
newFile.Name = name;
newFile.PhysicalPath = physicalPath;
newFile.IsPublic = isPublic;
newFile.IsActual = true;
newFile.DirectoryId = directoryId;
newFile.LastWrite = DateTime.Now;
newFile.Size = size;
db.Files.InsertOnSubmit(newFile);
db.SubmitChanges();
}
//создает директорию по имени и parentId
public int CreateDirectoryByName(int userId, string name, int parentId, bool isPublic)
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
Directory newDirectory = new Directory();
newDirectory.UserId = userId;
newDirectory.Name = name;
newDirectory.IsPublic = isPublic;
newDirectory.IsActual = true;
newDirectory.ParentId = parentId;
newDirectory.Created = DateTime.Now;
db.Directories.InsertOnSubmit(newDirectory);
db.SubmitChanges();
return newDirectory.DirectoryId;
}
//создает директорию
public int CreateDirectory(int userId, string patch, bool isPublic)
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
Directory parentDirectory = GetParentDirectory(patch, userId);
Directory newDirectory = new Directory();
newDirectory.UserId = userId;
newDirectory.Name = patch.Remove(0, patch.LastIndexOf('\\')+1);
newDirectory.IsPublic = isPublic;
newDirectory.IsActual = true;
newDirectory.ParentId = parentDirectory.DirectoryId;
newDirectory.Created = DateTime.Now;
db.Directories.InsertOnSubmit(newDirectory);
db.SubmitChanges();
return newDirectory.DirectoryId;
}
public void putStudentInDatabase(int studentNumber, string email)
{
DatabaseFactory factory = DatabaseFactory.getInstance();
DatabaseClassesDataContext context = factory.getDataContext();
User newUser;
bool userExists = false;
var usertest = from u in context.Users
where u.student_number == studentNumber
select u;
if (usertest.Count() == 0)
{
newUser = new User();
newUser.student_number = studentNumber;
newUser.email = email + "@avans.nl";
newUser.rol_name = "user";
}
else
{
userExists = true;
newUser = usertest.First();
}
CurrentUser.getInstance().Studentnummer = studentNumber;
CurrentUser.getInstance().Role = newUser.rol_name;
if (!userExists)
{
context.Users.InsertOnSubmit(newUser);
}
context.SubmitChanges();
CurrentUser.getInstance().StudentId = newUser.id;
}
public ActionResult ThemPYC(FormCollection collection, PHIEUYEUCAU pyc, THONGBAO tb)
{
try
{
if (Session["ID"] == null)
{
return(RedirectToAction("Login", "Login"));
}
//TODO: Add insert logic here
var nv = collection["Nhanvien3"];
var lts = collection["Loaitaisan3"];
var kh = collection["Khachhang3"];
//no lỗi ngay đây. nếu chặn lại thì ko sao.
pyc.SOPYC = collection["SOPYC"] + "/2016/PYC-AMAX";
pyc.NGAYTAO = DateTime.Now;
pyc.TRANGTHAI = true;
pyc.ID_NHANVIEN = int.Parse(nv);
pyc.ID_LOAITAISAN = int.Parse(lts);
pyc.ID_KH = int.Parse(kh);
data.PHIEUYEUCAUs.InsertOnSubmit(pyc);
data.SubmitChanges();
var id = data.PHIEUYEUCAUs.FirstOrDefault(s => s.SOPYC == pyc.SOPYC);
tb.ID_PYC = id.ID_PYC;
tb.ID_NGUOIGUI = 1;
tb.ID_NGUOINHAN = int.Parse(nv);
tb.NOIDUNG = "Bạn được giao: " + collection["SOPYC"] + "/2016/PYC-AMAX";
tb.NGAYGUI = DateTime.Now;
tb.TRANGTHAIXEM = false;
tb.TRANGTHAI = true;
data.THONGBAOs.InsertOnSubmit(tb);
data.SubmitChanges();
return(RedirectToAction("ThemPYC"));
}
catch
{
if (Session["ID"] == null)
{
return(RedirectToAction("Login", "Login"));
}
ViewData["Nhanvien3"] = new SelectList(data.NHANVIENs.ToList().OrderBy(s => s.TENNV).Where(s => s.PHONGBAN.ID_PHONGBAN == 2), "ID_NHANVIEN", "TENNV");
ViewData["Khachhang3"] = new SelectList(data.KHACHHANGs.ToList().OrderBy(s => s.TENKH), "ID_KH", "TENKH");
ViewData["Loaitaisan3"] = new SelectList(data.LOAITAISANs.ToList().OrderBy(s => s.TEN), "ID_LOAITAISAN", "TEN");
ViewBag.Thongbao = "0";
return(View());
}
}
//перемещает каталог
public void Move(int directoryId, int outDirectoryId, int userId)
{
try
{
Directory directoryInfo = DirectoryModel.Instance.GetDirectoryById(directoryId, userId);
Directory parentDirectoryInfo = DirectoryModel.Instance.GetDirectoryById(outDirectoryId, userId);
string directoryName = directoryInfo.Name;
int i = 1;
while (ExistByName(directoryName, outDirectoryId, userId))
{
directoryName = directoryInfo.Name + string.Format("({0})", ++i);
}
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var existFile = (from d in db.Directories
where d.DirectoryId == directoryId && d.UserId == userId
select d).Single();
existFile.ParentId = outDirectoryId;
existFile.Name = directoryName;
db.SubmitChanges();
}
catch { };
}
//делает файл не активным
public void MakeFileNotActive(int fileId, int userId)
{
try
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var existFile = (from f in db.Files
where f.FileId == fileId && f.UserId == userId && f.IsActual == true
select f).Single();
existFile.IsActual = false;
db.SubmitChanges();
}
catch { };
}
public ActionResult Themnhanvien(NHANVIEN nv, FormCollection collection)
{
if (Session["ID"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
ViewData["Phongban2"] = new SelectList(data.PHONGBANs.ToList().OrderBy(s => s.TEN), "ID_PHONGBAN", "TEN");
ViewData["Loainhanvien2"] = new SelectList(data.LOAINHANVIENs.ToList().OrderBy(s => s.TEN), "ID_LOAINHANVIEN", "TEN");
var c = collection["Phongban2"];
var b = collection["Loainhanvien2"];
nv.ID_PHONGBAN = int.Parse(c);
nv.ID_LOAINHANVIEN = int.Parse(b);
nv.NGAYTAO = DateTime.Now;
nv.NGUOITAO = int.Parse(Session["ID"].ToString());
nv.PASS = "******";//pass 123456
nv.TRANGTHAI = true;
nv.ID_PHANQUYEN = 2;
nv.ANH = "user.jpg";
data.NHANVIENs.InsertOnSubmit(nv);
data.SubmitChanges();
return(RedirectToAction("Themnhanvien"));
}
catch
{
ViewData["Phongban2"] = new SelectList(data.PHONGBANs.ToList().OrderBy(s => s.TEN), "ID_PHONGBAN", "TEN");
ViewData["Loainhanvien2"] = new SelectList(data.LOAINHANVIENs.ToList().OrderBy(s => s.TEN), "ID_LOAINHANVIEN", "TEN");
return(View());
}
}
//удаляет директорию
public void DeleteDirectory(int direstoryId, int userId)
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var deleteQuerry = from d in db.Directories
where d.DirectoryId == direstoryId && d.UserId == userId
select d;
if (deleteQuerry.Count<Directory>() > 0)
{
db.Directories.DeleteOnSubmit(deleteQuerry.First<Directory>());
db.SubmitChanges();
}
}
//перемещает файл в другой каталог
public void Move(int fileId, int outDirectoryId, int userId)
{
try
{
File fileInfo = GetFileById(fileId, userId);
string fileName = fileInfo.Name;
int i=1;
while (Exist(outDirectoryId, fileName, userId))
{
fileName = fileInfo.Name + string.Format("({0})", ++i);
}
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var existFile = (from f in db.Files
where f.FileId == fileId && f.UserId == userId && f.IsActual == true
select f).Single();
existFile.Name = fileName;
existFile.DirectoryId = outDirectoryId;
db.SubmitChanges();
}
catch { };
}
//переименование файла
public void Rename(int fileId, string newName, int userId)
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var existFile = (from f in db.Files
where f.FileId == fileId && f.UserId == userId && f.IsActual == true
select f).Single();
existFile.Name = newName;
db.SubmitChanges();
}
//переименование каталога
public void Rename(int directoryId, string newName, int userId)
{
try
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var existFile = (from d in db.Directories
where d.DirectoryId == directoryId && d.UserId == userId && d.ParentId != 0
select d).Single();
existFile.Name = newName;
db.SubmitChanges();
}
catch { };
}
//делает каталог не активным
public void MakeFileNotActive(int directoryId, int userId)
{
try
{
DatabaseClassesDataContext db = new DatabaseClassesDataContext();
var existFile = (from d in db.Directories
where d.DirectoryId == directoryId && d.UserId == userId && d.ParentId!=0
select d).Single();
existFile.IsActual = false;
db.SubmitChanges();
}
catch { };
}
