public ActionResult Create([Bind(Include = "WorkListId,DateIn,DateOut,DateModifcation,Deadline,QueryId,WorkTypeId,PersonExecId,StateWorkId,Verification,Comment")] jWorkList jWorkList) { if (ModelState.IsValid) { jWorkList.DateIn = DateTime.Parse(DateTime.Today.ToShortDateString()); jWorkList.DateModifcation = DateTime.Now; jWorkList.DateModifcation = jWorkList.DateModifcation.AddMilliseconds(-jWorkList.DateModifcation.Millisecond); DateTime dmd = jWorkList.DateModifcation; jWorkList.StateWorkId = db.hStateWork.First(m => m.Description == "Ожидает").StateWorkId; jWorkList.Verification = false; if (jWorkList.Comment != null) { string com = "-" + jWorkList.Comment + " " + User.Identity.Name + " " + DateTime.Now.ToString(); jWorkList.Comment = com; } db.jWorkList.Add(jWorkList); db.SaveChanges(); jJournal jJur = new jJournal(); string dmdstr = dmd.ToString("yyyy-MM-dd HH:mm:ss") + ".000"; DateTime dmdn = DateTime.Parse(dmdstr); db = new KOMK_Main_v2Entities(); jWorkList jW = db.jWorkList.First(m => m.DateModifcation == dmdn); jJur.Date = DateTime.Now; jJur.EventTypeId = db.hEventType.First(m => m.Description == "Создание работы").EventTypeId; jJur.WorkListId = jW.WorkListId; jJur.PersonId = User.Identity.GetUserId(); jJur.QueryID = jW.QueryId; if (jW.Comment != null) { jJur.Description = " Коментарий перед работой: " + jW.Comment; } else { jJur.Description = "Комментария перед работой не было"; } db.jJournal.Add(jJur); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PersonExecId = new SelectList(db.AspNetUsers, "Id", "Fio", jWorkList.PersonExecId); ViewBag.StateWorkId = new SelectList(db.hStateWork, "StateWorkId", "Description", jWorkList.StateWorkId); ViewBag.WorkTypeId = new SelectList(db.hWorkType, "WorkTypeId", "Description", jWorkList.WorkTypeId); ViewBag.QueryId = new SelectList(db.jQuery, "QueryId", "Text", jWorkList.QueryId); return(View(jWorkList)); }
public ActionResult Create([Bind(Include = "QueryId,DateOut,DateIn,DateModification,DeadLine,Text,StateId,PersonId,PersonSpId")] jQuery jQuery) { if (ModelState.IsValid) { //Заполняем необходимые для для создания заявки поля, которые не видит пользователь jQuery.DateIn = DateTime.Parse(DateTime.Today.ToShortDateString()); jQuery.DateModification = DateTime.Now; jQuery.DateModification = jQuery.DateModification.AddMilliseconds(-jQuery.DateModification.Millisecond); DateTime dmd = jQuery.DateModification; jQuery.StateId = db.hState.First(m => m.Description == "Ожидает").StateId; jQuery.PersonId = User.Identity.GetUserId(); db.jQuery.Add(jQuery); db.SaveChanges(); jJournal jJur = new jJournal(); string dmdstr = dmd.ToString("yyyy-MM-dd HH:mm:ss") + ".000"; DateTime dmdn = DateTime.Parse(dmdstr); db = new KOMK_Main_v2Entities(); jQuery jQ = db.jQuery.First(m => m.DateModification == dmdn); jJur.Date = DateTime.Now; jJur.EventTypeId = db.hEventType.First(m => m.Description == "Создание заявки").EventTypeId; jJur.WorkListId = null; jJur.PersonId = User.Identity.GetUserId(); jJur.QueryID = jQ.QueryId; jJur.Description = " Содержание: " + jQ.Text; db.jJournal.Add(jJur); db.SaveChanges(); return(RedirectToAction("Index")); } //Если данные не валидны то делаем тоже что и в методе GET ViewBag.PersonId = new SelectList(db.AspNetUsers, "Id", "Fio", jQuery.PersonId); ViewBag.PersonSpId = new SelectList(db.AspNetUsers, "Id", "Fio", jQuery.PersonSpId); ViewBag.StateId = new SelectList(db.hState, "StateId", "Description", jQuery.StateId); return(View(jQuery)); }
public ActionResult Import(HttpPostedFileBase excelfile) { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); if (excelfile == null || excelfile.ContentLength == 0) { ViewBag.Error = "Файл не выбран! <br>"; return(View("Index", db.AspNetUsers.ToList())); } else { if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx")) { db = new KOMK_Main_v2Entities(); string path = Server.MapPath("~/Import/" + excelfile.FileName); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } excelfile.SaveAs(path); //Читаем из файла // Excel.Application ap = new Excel.Application(); Excel.Application application = new Excel.Application(); Excel.Workbook workbook = application.Workbooks.Open(path); Excel.Worksheet worksheet = workbook.ActiveSheet; Excel.Range range = worksheet.UsedRange; List <AspNetUsers> listUsers = new List <AspNetUsers>(); for (int row = 2; row <= range.Rows.Count; row++) { AspNetUsers user = new AspNetUsers(); user.Fio = ((Excel.Range)range.Cells[row, 1]).Text; user.PasswordHash = ((Excel.Range)range.Cells[row, 2]).Text; user.SecurityStamp = ((Excel.Range)range.Cells[row, 3]).Text; user.Email = ((Excel.Range)range.Cells[row, 4]).Text; user.UserName = ((Excel.Range)range.Cells[row, 5]).Text; user.Id = Guid.NewGuid().ToString(); user.EmailConfirmed = false; user.PhoneNumberConfirmed = false; user.TwoFactorEnabled = false; user.LockoutEnabled = true; user.AccessFailedCount = 0; db.AspNetUsers.Add(user); db.SaveChanges(); //AspNetUserRoles acc = new AspNetUserRoles(); //acc.UserId = user.Id; //acc.RoleId = db.AspNetRoles.Where(m => m.Name == "User").First().Id; //db.AspNetUserRoles.Add(acc); //db.SaveChanges(); } workbook.Close(); ViewBag.Error = "Данные загружены <br>"; return(View("Index", db.AspNetUsers.ToList())); } else { ViewBag.Error = "Это не Excel! <br>"; return(View("Index", db.AspNetUsers.ToList())); } } }
public Mydb() { this.db = new KOMK_Main_v2Entities(); }