public ActionResult Edit(education__institution education__institution)
{
if (ModelState.IsValid)
{
audit_object site = db.audit_object.Find(education__institution.audit_object_id);
site.adress_site = education__institution.audit_object.adress_site;
db.audit_object.AddOrUpdate(site);
db.SaveChanges();
education__institution.audit_object = null;
db.Entry(education__institution).State = EntityState.Modified;
db.SaveChanges();
}
ViewBag.audit_object_id = new SelectList(db.audit_object, "id", "title_site", education__institution.audit_object_id);
ViewBag.department_subordination_id = new SelectList(db.department_subordination, "id", "name", education__institution.department_subordination_id);
ViewBag.district_id = new SelectList(db.district, "id", "name", education__institution.district_id);
if (education__institution.district_id > 0)
{
ViewBag.area_id = new SelectList(db.area, "id", "name", db.district.Find(education__institution.district_id).area_id);
}
else
{
ViewBag.area_id = new SelectList(db.area, "id", "name");
}
ViewBag.kind_edu_id = new SelectList(db.kind_edu, "id", "name", education__institution.kind_edu_id);
ViewBag.ownership_type_id = new SelectList(db.ownership_type, "id", "name", education__institution.ownership_type_id);
ViewBag.type_edu_id = new SelectList(db.type_edu, "id", "name", education__institution.type_edu_id);
ViewBag.type_education_institution_id = new SelectList(db.type_education_institution, "id", "nane", education__institution.type_education_institution_id);
return(View(education__institution));
}
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
education__institution education__institution = await db.education__institution.FindAsync(id);
if (education__institution == null)
{
return(HttpNotFound());
}
ViewBag.audit_object_id = new SelectList(db.audit_object, "id", "title_site", education__institution.audit_object_id);
ViewBag.department_subordination_id = new SelectList(db.department_subordination, "id", "name", education__institution.department_subordination_id);
ViewBag.district_id = new SelectList(db.district.Where(p => p.area_id == education__institution.district.area_id), "id", "name", education__institution.district_id);
if (education__institution.district_id > 0)
{
ViewBag.area_id = new SelectList(db.area, "id", "name", db.district.Find(education__institution.district_id).area_id);
}
else
{
ViewBag.area_id = new SelectList(db.area, "id", "name");
}
ViewBag.kind_edu_id = new SelectList(db.kind_edu, "id", "name", education__institution.kind_edu_id);
ViewBag.ownership_type_id = new SelectList(db.ownership_type, "id", "name", education__institution.ownership_type_id);
ViewBag.type_edu_id = new SelectList(db.type_edu, "id", "name", education__institution.type_edu_id);
ViewBag.type_education_institution_id = new SelectList(db.type_education_institution, "id", "nane", education__institution.type_education_institution_id);
return(View(education__institution));
}
public ActionResult InstitutionMonitoring(int edu_id, int?m)
{
education__institution edu = db.education__institution.Find(edu_id);
ViewBag.groups = db.Groups.ToList();
if (m == null)
{
monitoring mm = db.monitoring.OrderByDescending(p => p.date_end).FirstOrDefault(p => p.date_end < DateTime.Now && p.Rating.Count(a => a.audit_object_id == edu.audit_object_id) > 0);
if (mm != null)
{
m = mm.id;
}
}
int place = 0;
if (m != null)
{
Rating rating = db.Rating.First(p => p.monitoring_id == m && p.audit_object_id == edu.audit_object_id);
place = db.Rating.Count(p => p.monitoring_id == m && p.sum > rating.sum) + 1;
}
ViewBag.place = place;
ViewBag.monitoring = m;
return(View(edu));
}
public ActionResult SubordinateOrganizations()
{
int site = Convert.ToInt32(Session["curator_site_id"]);
education__institution e = db.education__institution.FirstOrDefault(p => p.audit_object_id == site);
List <education__institution> edu = db.education__institution.Where(p => p.UNP_superior_management.Contains(e.UNP)).ToList();
return(View(edu));
}
public JsonResult Delete(int?id)
{
if (id != null)
{
education__institution edu = db.education__institution.Find(id);
edu.state_id = 2;
db.education__institution.AddOrUpdate(edu);
db.SaveChanges();
}
return(Json(""));
}
public ActionResult Create(education__institution education__institution)
{
education__institution.id = (db.education__institution.Count() > 0) ? (db.education__institution.Max(p => p.id) + 1) : 1;
audit_object a = new audit_object();
a.id = (db.audit_object.Count() > 0) ? (db.audit_object.Max(p => p.id) + 1) : 1;
a.adress_site = education__institution.audit_object.adress_site;
a.title_site = education__institution.full_name;
db.audit_object.Add(a);
db.SaveChanges();
education__institution.audit_object = null;
education__institution.state_id = 1;
education__institution.audit_object_id = a.id;
db.education__institution.Add(education__institution);
db.SaveChanges();
return(Redirect("/Institution/Index"));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
education__institution education__institution = await db.education__institution.FindAsync(id);
if (education__institution == null)
{
return(HttpNotFound());
}
if (education__institution.phone != null)
{
ViewBag.phone = "+375" + education__institution.phone.Replace("(", "").Replace(")", "").Replace("-", "").Replace(" ", "");
}
return(View(education__institution));
}
public ActionResult GetExcelUO()
{
Microsoft.Office.Interop.Excel.Application ObjWorkExcel = new Microsoft.Office.Interop.Excel.Application(); //открыть эксель
Microsoft.Office.Interop.Excel.Workbook ObjWorkBook = ObjWorkExcel.Workbooks.Open(@"d:\novopolock_forma.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); //открыть файл
Microsoft.Office.Interop.Excel.Worksheet ObjWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ObjWorkBook.Sheets[1]; //получить 1 лист
var lastCell = ObjWorkSheet.Cells.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeLastCell); //1 ячейку
int iLastRow = ObjWorkSheet.Cells[ObjWorkSheet.Rows.Count, "A"].End[Microsoft.Office.Interop.Excel.XlDirection.xlUp].Row; //последняя заполненная строка в столбце А
var arrData = (object[, ])ObjWorkSheet.Range["A1:Z" + iLastRow].Value;
ObjWorkBook.Close(false, Type.Missing, Type.Missing); //закрыть не сохраняя
ObjWorkExcel.Quit(); // выйти из экселя
int id1 = (db.audit_object.Count() > 0) ? (db.audit_object.Max(p => p.id) + 1) : 1, id2 = (db.education__institution.Count() > 0) ? (db.education__institution.Max(p => p.id) + 1) : 1, id3 = (db.User.Count() > 0) ? (db.User.Max(p => p.id) + 1) : 1, id4 = (db.curators_and_controlers.Count() > 0) ? (db.curators_and_controlers.Max(p => p.id) + 1) : 1;
for (int i = 5; i <= iLastRow; ++i)
{
string site = (arrData[i, 20] != null) ? arrData[i, 20].ToString() : " ";
audit_object a = new audit_object();
if (!site.Equals(" "))
{
a.id = id1++;
a.adress_site = site;
a.title_site = (arrData[i, 3] != null) ? arrData[i, 3].ToString() : " ";
db.audit_object.Add(a);
db.SaveChanges();
}
education__institution e = new education__institution();
e.id = id2++;
e.full_name = (arrData[i, 2] != null) ? arrData[i, 2].ToString() : " ";
e.short_name = (arrData[i, 3] != null) ? arrData[i, 3].ToString() : " ";
if (!site.Equals(" "))
{
e.audit_object_id = a.id;
}
if (arrData[i, 5] != null)
{
e.district_id = Convert.ToInt32(arrData[i, 5]);
}
e.address = (arrData[i, 6] != null) ? arrData[i, 6].ToString() : " ";
e.email = (arrData[i, 7] != null) ? arrData[i, 7].ToString() : " ";
e.phone = (arrData[i, 8] != null) ? arrData[i, 8].ToString() : " ";
if (arrData[i, 9] != null)
{
e.type_edu_id = Convert.ToInt32(arrData[i, 9]);
}
if (arrData[i, 10] != null)
{
e.kind_edu_id = Convert.ToInt32(arrData[i, 10]);
}
e.OKPO = (arrData[i, 11] != null) ? arrData[i, 11].ToString() : " ";
e.UNP = (arrData[i, 12] != null) ? arrData[i, 12].ToString() : " ";
e.director = (arrData[i, 13] != null) ? arrData[i, 13].ToString() : " ";
e.is_application = 0;
if (arrData[i, 15] != null)
{
e.type_education_institution_id = Convert.ToInt32(arrData[i, 15]);
}
if (arrData[i, 16] != null)
{
e.ownership_type_id = Convert.ToInt32(arrData[i, 16]);
}
if (arrData[i, 17] != null)
{
e.department_subordination_id = Convert.ToInt32(arrData[i, 17]);
}
e.state_id = 1;
e.UNP_superior_management = (arrData[i, 19] != null) ? arrData[i, 19].ToString() : " ";
db.education__institution.Add(e);
db.SaveChanges();
if (!site.Equals(" "))
{
User u = new User();
u.id = id3++;
u.Surname = (arrData[i, 21] != null) ? arrData[i, 21].ToString() : " ";
u.Name = (arrData[i, 22] != null) ? arrData[i, 22].ToString() : " ";
u.Patronumic = (arrData[i, 23] != null) ? arrData[i, 23].ToString() : " ";
u.email = (arrData[i, 25] != null) ? arrData[i, 25].ToString() : " ";
u.phone = (arrData[i, 26] != null) ? arrData[i, 26].ToString().Trim() : " ";
u.position = (arrData[i, 24] != null) ? arrData[i, 24].ToString() : " ";
u.password = Models.User.HashPassword("password");
u.state_id = 1;
u.role_id = (e.type_education_institution_id > 1) ? 3 : 2;
db.User.Add(u);
db.SaveChanges();
curators_and_controlers c = new curators_and_controlers();
c.id = id4++;
c.curator_id = u.id;
c.education_institution_id = e.id;
db.curators_and_controlers.Add(c);
db.SaveChanges();
}
}
return(Redirect("/Institution/Index"));
}
