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 { }; }