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();
}
