// GET: PostOffices
public ActionResult Index()
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
List <PostOffices> model = new List <PostOffices>();
JohaMeriSQL1Entities entities = new JohaMeriSQL1Entities();
try
{
List <PostOffices> postoff = entities.PostOffices.ToList();
// muodostetaan näkymämalli tietokannan rivien pohjalta
foreach (PostOffices post in postoff)
{
PostOffices view = new PostOffices();
view.Post_id = post.Post_id;
view.PostalCode = post.PostalCode;
view.PostOffice = post.PostOffice;
model.Add(view);
}
}
finally
{
entities.Dispose();
}
return(View(model));
}//Index
// GET: PostOffices/Edit/5
public ActionResult Edit(int?id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PostOffices postOffices = db.PostOffices.Find(id);
if (postOffices == null)
{
return(HttpNotFound());
}
ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id);
ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id);
return(View(postOffices));
}
public ActionResult DeleteConfirmed(int id)
{
PostOffices postOffices = db.PostOffices.Find(id);
db.PostOffices.Remove(postOffices);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(CustomerViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
Customer cus = new Customer();
cus.FirstName = model.FirstNameA;
cus.LastName = model.LastNameA;
cus.Identity = model.Identity;
cus.Address = model.Address;
cus.Email = model.Email;
cus.Notes = model.Notes;
cus.CreatedAt = DateTime.Now;
cus.LastModifiedAt = DateTime.Now;
cus.DeletedAt = model.DeletedAt;
cus.Active = model.Active;
cus.Permission = model.Permission;
db.Customer.Add(cus);
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Customer = cus;
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
db.User.Add(usr);
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Customer = cus;
db.Phone.Add(pho);
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Customer = cus;
db.PostOffices.Add(pos);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
public ActionResult DeleteConfirmed(int id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
PostOffices postOffices = db.PostOffices.Find(id);
db.PostOffices.Remove(postOffices);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(PersonnelViewModel model)
{
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
Personnel per = new Personnel();
per.FirstName = model.FirstNameP;
per.LastName = model.LastNameP;
per.Identity = model.Identity;
per.Email = model.Email;
per.Notes = model.Notes;
per.CreatedAt = DateTime.Now;
per.LastModifiedAt = DateTime.Now;
per.DeletedAt = model.DeletedAt;
per.Active = model.Active;
db.Personnel.Add(per);
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Personnel = per;
db.User.Add(usr);
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Personnel = per;
db.Phone.Add(pho);
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Personnel = per;
db.PostOffices.Add(pos);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
public ActionResult Edit(TreatmentOfficeViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
TreatmentOffice trmoff = db.TreatmentOffice.Find(model.TreatmentOffice_id);
trmoff.TreatmentOfficeName = model.TreatmentOfficeName;
trmoff.Address = model.Address;
trmoff.Note = model.Note;
//trmoff.MapPlace = model.MapPlace;
if (trmoff.Phone == null)
{
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.TreatmentOffice = trmoff;
db.Phone.Add(pho);
}
else
{
Phone phone = trmoff.Phone.FirstOrDefault();
if (phone != null)
{
phone.PhoneNum_1 = model.PhoneNum_1;
}
}
if (trmoff.PostOffices == null)
{
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.TreatmentOffice = trmoff;
db.PostOffices.Add(pos);
}
else
{
PostOffices po = trmoff.PostOffices.FirstOrDefault();
if (po != null)
{
po.PostalCode = model.PostalCode;
po.PostOffice = model.PostOffice;
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}//Edit
}//Index
// GET: PostOffices/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PostOffices postOffices = db.PostOffices.Find(id);
if (postOffices == null)
{
return(HttpNotFound());
}
return(View(postOffices));
}
public ActionResult Edit(TreatmentOfficeViewModel model)
{
TreatmentOffice trmoff = db.TreatmentOffice.Find(model.TreatmentOffice_id);
trmoff.TreatmentOfficeName = model.TreatmentOfficeName;
trmoff.Address = model.Address;
trmoff.Note = model.Note;
//trmoff.MapPlace = model.MapPlace;
if (trmoff.Phone == null)
{
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.TreatmentOffice = trmoff;
db.Phone.Add(pho);
}
else
{
Phone phone = trmoff.Phone.FirstOrDefault();
if (phone != null)
{
phone.PhoneNum_1 = model.PhoneNum_1;
}
}
if (trmoff.PostOffices == null)
{
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.TreatmentOffice = trmoff;
db.PostOffices.Add(pos);
}
else
{
PostOffices po = trmoff.PostOffices.FirstOrDefault();
if (po != null)
{
po.PostalCode = model.PostalCode;
po.PostOffice = model.PostOffice;
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}//Edit
}//Index
// GET: PostOffices/Details/5
public ActionResult Details(int?id)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PostOffices postOffices = db.PostOffices.Find(id);
if (postOffices == null)
{
return(HttpNotFound());
}
return(View(postOffices));
}
public ActionResult Create([Bind(Include = "Post_id,PostalCode,PostOffice,Personnel_id,Phone_id,Customer_id,Reservation_id,Student_id,Treatment_id,TreatmentOffice_id,TreatmentPlace_id,User_id")] PostOffices postOffices)
{
if (ModelState.IsValid)
{
db.PostOffices.Add(postOffices);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id);
ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id);
return(View(postOffices));
}
public ActionResult Create(TreatmentOfficeViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
TreatmentOffice trmoff = new TreatmentOffice();
trmoff.TreatmentOfficeName = model.TreatmentOfficeName;
trmoff.Address = model.Address;
trmoff.Note = model.Note;
trmoff.MapPlace = model.MapPlace;
//byte[] buffer = Encoding.UTF8.GetBytes(csv.ToString());
db.TreatmentOffice.Add(trmoff);
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.TreatmentOffice = trmoff;
db.Phone.Add(pho);
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.TreatmentOffice = trmoff;
db.PostOffices.Add(pos);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
public ActionResult Create([Bind(Include = "Post_id,PostalCode,PostOffice,Personnel_id,Phone_id,Customer_id,Reservation_id,Student_id,Treatment_id,TreatmentOffice_id,TreatmentPlace_id,User_id")] PostOffices postOffices)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
if (ModelState.IsValid)
{
db.PostOffices.Add(postOffices);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id);
ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id);
return(View(postOffices));
}
public ActionResult Create(TreatmentOfficeViewModel model)
{
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
TreatmentOffice trmoff = new TreatmentOffice();
trmoff.TreatmentOfficeName = model.TreatmentOfficeName;
trmoff.Address = model.Address;
trmoff.Note = model.Note;
trmoff.MapPlace = model.MapPlace;
//byte[] buffer = Encoding.UTF8.GetBytes(csv.ToString());
db.TreatmentOffice.Add(trmoff);
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.TreatmentOffice = trmoff;
db.Phone.Add(pho);
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.TreatmentOffice = trmoff;
db.PostOffices.Add(pos);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
// GET: PostOffices/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PostOffices postOffices = db.PostOffices.Find(id);
if (postOffices == null)
{
return(HttpNotFound());
}
ViewBag.Personnel_id = new SelectList(db.Personnel, "Personnel_id", "FirstName", postOffices.Personnel_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Post_id = new SelectList(db.PostOffices, "Post_id", "PostalCode", postOffices.Post_id);
ViewBag.Student_id = new SelectList(db.Studentx, "Student_id", "FirstName", postOffices.Student_id);
ViewBag.TreatmentOffice_id = new SelectList(db.TreatmentOffice, "TreatmentOffice_id", "TreatmentOfficeName", postOffices.TreatmentOffice_id);
return(View(postOffices));
}
public ActionResult Edit(StudentViewModel model)
{
Studentx stu = db.Studentx.Find(model.Student_id);
stu.FirstName = model.FirstNameH;
stu.LastName = model.LastNameH;
stu.Identity = model.Identity;
stu.Address = model.Address;
stu.Email = model.Email;
stu.EnrollmentDateIN = model.EnrollmentDateIN;
stu.EnrollmentDateOUT = model.EnrollmentDateOUT;
stu.EnrollmentDateOFF = model.EnrollmentDateOFF;
stu.Notes = model.Notes;
stu.CreatedAt = model.CreatedAt;
stu.LastModifiedAt = DateTime.Now;
stu.DeletedAt = model.DeletedAt;
stu.Active = model.Active;
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", stu.Student_id);
stu.Information = model.Information;
//ViewBag.User_id = new SelectList(db.User, "User_id", "UserIdentity");
if (stu.User == null)
{
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Studentx = stu;
db.User.Add(usr);
}
else
{
User user = stu.User.FirstOrDefault();
if (user != null)
{
user.UserIdentity = model.UserIdentity;
}
}
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
if (stu.Phone == null)
{
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Studentx = stu;
db.Phone.Add(pho);
}
else
{
Phone pho = stu.Phone.FirstOrDefault();
if (pho != null)
{
pho.PhoneNum_1 = model.PhoneNum_1;
}
}
if (stu.PostOffices == null)
{
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Studentx = stu;
db.PostOffices.Add(pos);
}
else
{
PostOffices po = stu.PostOffices.FirstOrDefault();
if (po != null)
{
po.PostalCode = model.PostalCode;
po.PostOffice = model.PostOffice;
}
}
int studentgroupId = int.Parse(model.StudentGroupName);
if (studentgroupId > 0)
{
StudentGroup stg = db.StudentGroup.Find(studentgroupId);
stu.StudentGroup_id = stg.StudentGroup_id;
}
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
public ActionResult Edit(PersonnelViewModel model)
{
Personnel per = db.Personnel.Find(model.Personnel_id);
per.FirstName = model.FirstNameP;
per.LastName = model.LastNameP;
per.Identity = model.Identity;
per.Email = model.Email;
per.Notes = model.Notes;
per.CreatedAt = model.CreatedAt;
per.LastModifiedAt = model.LastModifiedAt;
per.DeletedAt = model.DeletedAt;
per.Active = model.Active;
if (per.User == null)
{
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Personnel = per;
db.User.Add(usr);
}
else
{
User user = per.User.FirstOrDefault();
if (user != null)
{
user.UserIdentity = model.UserIdentity;
}
}
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
if (per.Phone == null)
{
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Personnel = per;
db.Phone.Add(pho);
}
else
{
Phone phone = per.Phone.FirstOrDefault();
if (phone != null)
{
phone.PhoneNum_1 = model.PhoneNum_1;
}
}
if (per.PostOffices == null)
{
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Personnel = per;
db.PostOffices.Add(pos);
}
else
{
PostOffices po = per.PostOffices.FirstOrDefault();
if (po != null)
{
po.PostalCode = model.PostalCode;
po.PostOffice = model.PostOffice;
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
public ActionResult Create(StudentViewModel model)
{
JohaMeriSQL1Entities db = new JohaMeriSQL1Entities();
Studentx stu = new Studentx();
stu.FirstName = model.FirstNameH;
stu.LastName = model.LastNameH;
stu.Identity = model.Identity;
stu.Address = model.Address;
stu.Email = model.Email;
stu.Notes = model.Notes;
stu.EnrollmentDateIN = model.EnrollmentDateIN;
stu.EnrollmentDateOUT = model.EnrollmentDateOUT;
stu.EnrollmentDateOFF = model.EnrollmentDateOFF;
stu.CreatedAt = DateTime.Now;
stu.LastModifiedAt = DateTime.Now;
stu.DeletedAt = model.DeletedAt;
stu.Active = model.Active;
stu.Information = model.Information;
db.Studentx.Add(stu);
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Studentx = stu;
db.User.Add(usr);
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Studentx = stu;
db.Phone.Add(pho);
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Studentx = stu;
db.PostOffices.Add(pos);
// etsitään StudentGroup-rivi kannasta valitun nimen perusteella
int studentgroupId = int.Parse(model.StudentGroupName);
if (studentgroupId > 0)
{
StudentGroup stg = db.StudentGroup.Find(studentgroupId);
stu.StudentGroup_id = stg.StudentGroup_id;
}
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
ViewBag.StudentGroupName = new SelectList((from s in db.StudentGroup select new { StudentGroup_id = s.StudentGroup_id, StudentGroupName = s.StudentGroupName }), "StudentGroup_id", "StudentGroupName", null);
ViewBag.Active = new SelectList((from a in db.Studentx select new { Student_id = a.Student_id, Active = a.Active }), "Student_id", "Active", null);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
public ActionResult Edit(CustomerViewModel model)
{
string username = User.Identity.Name;
string userid = ((ClaimsPrincipal)User).Claims?.Where(c => c.Type == ClaimTypes.GroupSid).FirstOrDefault()?.Value ?? "";
Customer cus = db.Customer.Find(model.Customer_id);
cus.FirstName = model.FirstNameA;
cus.LastName = model.LastNameA;
cus.Identity = model.Identity;
cus.Address = model.Address;
cus.Email = model.Email;
cus.Notes = model.Notes;
cus.CreatedAt = model.CreatedAt;
cus.LastModifiedAt = DateTime.Now;
cus.DeletedAt = model.DeletedAt;
cus.Active = model.Active;
cus.Permission = model.Permission;
if (cus.User == null)
{
User usr = new User();
usr.UserIdentity = model.UserIdentity;
usr.Password = "******";
usr.Customer = cus;
db.User.Add(usr);
}
else
{
User user = cus.User.FirstOrDefault();
if (user != null)
{
user.UserIdentity = model.UserIdentity;
}
}
if (cus.Phone == null)
{
Phone pho = new Phone();
pho.PhoneNum_1 = model.PhoneNum_1;
pho.Customer = cus;
db.Phone.Add(pho);
}
else
{
Phone phone = cus.Phone.FirstOrDefault();
if (phone != null)
{
phone.PhoneNum_1 = model.PhoneNum_1;
}
}
if (cus.PostOffices == null)
{
PostOffices pos = new PostOffices();
pos.PostalCode = model.PostalCode;
pos.PostOffice = model.PostOffice;
pos.Customer = cus;
db.PostOffices.Add(pos);
}
else
{
PostOffices po = cus.PostOffices.FirstOrDefault();
if (po != null)
{
po.PostalCode = model.PostalCode;
po.PostOffice = model.PostOffice;
}
}
ViewBag.UserIdentity = new SelectList((from u in db.User select new { User_id = u.User_id, UserIdentity = u.UserIdentity }), "User_id", "UserIdentity", null);
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
