public ActionResult studentPaper(int studentId)
{
Student sx = new Student();
using (var context = new studentEntities())
{
sx = context.Students
.Where(b => b.Id == 1)
.FirstOrDefault();
}
ViewBag.studentId = studentId;
ViewBag.studentName = sx.StudentName;
ViewBag.studentSurName = sx.StudentSurName;
ViewBag.studentAdres = sx.Adres;
ViewBag.studentAdresCity = sx.AdresCity;
ViewBag.studentAdresPLZ = sx.AdresPLZ;
ViewBag.studentBirthDate = sx.StudentBirthDate;
ViewBag.mr = sx.mr_mrs;
ViewBag.studentDate = DateTime.Now.Date.Day + "." + DateTime.Now.Date.Month + "." + DateTime.Now.Date.Year;
if (DateTime.Now.Date.Month > 8)
{
ViewBag.studentJahr = DateTime.Now.Date.Year + "/" + (DateTime.Now.Date.Year + 1);
}
else
{
ViewBag.studentJahr = (DateTime.Now.Date.Year - 1) + "/" + DateTime.Now.Date.Year;
}
return(View());
}
public async Task <ActionResult> save_payment(Student_Payments model, string returnUrl)
{
int studentId = int.Parse(Session["studentId"].ToString());
model.StudentId = studentId;
//check for reportName parameter value now
//to do : Return something
studentEntities ee = new studentEntities();
if (model.Id > 0)
{
ee.Entry(model).State = EntityState.Modified;
}
else
{
ee.Student_Payments.Add(model);
}
ee.SaveChanges();
using (var context = new studentEntities())
{
ViewBag.PaymentsList = context.Student_Payments
.Where(b => b.StudentId == studentId)
.ToList();
}
return(View("General", ViewBag.PaymentsList));
}
public ActionResult studentRechnung(int studentId)
{
string examdate = "";
string discountnumber = "";
string paymentrate = "";
Student sx = new Student();
using (var context = new studentEntities())
{
sx = context.Students
.Where(b => b.Id == studentId)
.FirstOrDefault();
examdate = context.settings
.Where(b => b.value_name == "examdate")
.FirstOrDefault().value_desc;
discountnumber = context.settings
.Where(b => b.value_name == "discountnumber")
.FirstOrDefault().value_desc;
paymentrate = context.settings
.Where(b => b.value_name == "paymentrate")
.FirstOrDefault().value_desc;
}
ViewBag.studentId = studentId;
ViewBag.examdate = examdate;
ViewBag.studentName = sx.StudentName;
ViewBag.studentSurName = sx.StudentSurName;
ViewBag.studentAdres = sx.Adres;
ViewBag.studentAdresCity = sx.AdresCity;
ViewBag.studentAdresPLZ = sx.AdresPLZ;
ViewBag.studentBirthDate = sx.StudentBirthDate;
ViewBag.StudentPrice = sx.StudentPrice;
ViewBag.StudentPriceDiscount = ((sx.StudentPrice / 100) * int.Parse(discountnumber));
ViewBag.StudentPricerest = sx.StudentPrice - ViewBag.StudentPriceDiscount;
ViewBag.StudentPriceRate = ViewBag.StudentPrice / int.Parse(paymentrate);
ViewBag.mr = sx.mr_mrs;
ViewBag.studentDate = DateTime.Now.Date.Day + "." + DateTime.Now.Date.Month + "." + DateTime.Now.Date.Year;
if (DateTime.Now.Date.Month > 8)
{
ViewBag.studentJahr1 = DateTime.Now.Date.Year;
ViewBag.studentJahr2 = DateTime.Now.Date.Year + 1;
ViewBag.studentJahr = DateTime.Now.Date.Year + "/" + (DateTime.Now.Date.Year + 1);
}
else
{
ViewBag.studentJahr1 = DateTime.Now.Date.Year - 1;
ViewBag.studentJahr2 = DateTime.Now.Date.Year;
ViewBag.studentJahr = (DateTime.Now.Date.Year - 1) + "/" + DateTime.Now.Date.Year;
}
return(View());
}
public ActionResult studentFileUpload(HttpPostedFileBase file)
{
if (file != null && file.ContentLength > 0)
{
try
{
string path = Path.Combine(Server.MapPath("~/files"),
Path.GetFileName(file.FileName));
int id = int.Parse(Session["studentId"].ToString());
studentEntities ctx = new studentEntities();
student_files sf = new student_files();
sf.create_date = DateTime.Now;
sf.filepath = path;
sf.studentId = id;
sf.fileNameOld = file.FileName;
ctx.student_files.Add(sf);
ctx.SaveChanges();
string extension = Path.GetExtension(file.FileName);
sf.fileName = sf.id.ToString() + extension;
path = path.Replace(file.FileName, sf.id.ToString() + extension);
ctx.Entry(sf).State = EntityState.Modified;
sf.filepath = path;
ctx.SaveChanges();
file.SaveAs(path);
ViewBag.Message = "Dosya yüklendi.";
using (var context = new studentEntities())
{
ViewBag.PaymentsList = context.Student_Payments
.Where(b => b.StudentId == id)
.ToList();
}
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
else
{
ViewBag.Message = "You have not specified a file.";
}
return(View("General"));
}
public PartialViewResult StudentCreateView()
{
Student sx = new Student();
int id = 0;
if (Session["studentId"] != null)
{
id = int.Parse(Session["studentId"].ToString());
}
using (var context = new studentEntities())
{
sx = (from b in context.Students
where b.Id == id
select b).FirstOrDefault();
}
return(PartialView("StudentCreateView", sx));
}
public PartialViewResult studentFileListView()
{
int id = 0;
if (Session["studentId"] != null)
{
id = int.Parse(Session["studentId"].ToString());
}
using (var context = new studentEntities())
{
var filelist = (from b in context.student_files
where b.studentId == id
select b).ToList();
return(PartialView("studentFileListView", filelist));
}
}
public async Task <ActionResult> save(Student model, string returnUrl)
{
//check for reportName parameter value now
//to do : Return something
studentEntities ee = new studentEntities();
if (model.Id > 0)
{
ee.Entry(model).State = EntityState.Modified;
}
else
{
ee.Students.Add(model);
Session["studentId"] = model.Id;
}
ee.SaveChanges();
General(model.Id);
return(View("General"));
}
public ActionResult DashboardV1()
{
using (var context = new studentEntities())
{
var sx = (from b in context.Students
select b)
.ToList();
ViewBag.activeStudent = (from b in context.Students
.Where(b => b.Active == true)
select b)
.ToList().Count();
ViewBag.allStudent = (from b in context.Students
.Where(b => b.Active == false)
select b)
.ToList().Count();
return(View(sx));
}
}
public ActionResult General(int studentId)
{
Session["studentId"] = studentId;
/* Entities1 ee = new Entities1();
* Student ss = new Student
* {
* Id = 1,
* Active = true,
* StudentName = "test",
* StudentSurName = "testSurname",
* Adres="",
* StudentPapier=true,
* StudentPrice=0,
* StudentRestPrice=0,
* StudentExtraInfo="",
* StudentBirthDate=""
* };
* ee.Students.Add(ss);
* ee.SaveChanges();
* var std = ee.Students.Find();
*/
/*
* var std = new Models.Student { Id = 1, Email = "*****@*****.**", studentName = "STEFFY 1", studentSurName = "XYZ1" };
* var pymts = new List<Models.Student_Payments>();
* pymts.Add(new Models.Student_Payments { Id=1,Payment=100, date="1.1.2001"});
* pymts.Add(new Models.Student_Payments { Id = 2, Payment = 102, date = "1.1.2001" });
* pymts.Add(new Models.Student_Payments { Id = 3, Payment = 103, date = "1.1.2001" });
* std.payments=pymts.ToArray();
*/
studentEntities ee = new studentEntities();
/*
* ee.Students.Add( new Student {
* Id=1,
* StudentName ="test",
* StudentSurName ="test",
* StudentPrice=100,
* PhoneNumber="12345678"
* });
* ee.Students.Add(new Student
* {
* Id = 2,
* StudentName = "test",
* StudentSurName = "test2",
* StudentPrice = 200,
* PhoneNumber = "22345678"
* });
* ee.Students.Add(new Student
* {
* Id = 3,
* StudentName = "test2",
* StudentSurName = "test2x",
* StudentPrice = 300,
* PhoneNumber = "xx345678"
* });
* ee.Students.Add(new Student
* {
* Id = 4,
* StudentName = "test2",
* StudentSurName = "testy",
* StudentPrice = 500,
* PhoneNumber = "1R3T5Z78"
* });
* ee.Student_Payments.Add(new Student_Payments { Payment = 100, StudentId = 1 });
* ee.Student_Payments.Add(new Student_Payments { Payment = 200, StudentId = 1 });
* ee.Student_Payments.Add(new Student_Payments { Payment = 300, StudentId = 3 });
* ee.Student_Payments.Add(new Student_Payments { Payment = 400, StudentId = 3 });
* ee.Student_Payments.Add(new Student_Payments { Payment = 500, StudentId = 2 });
* ee.Student_Payments.Add(new Student_Payments { Payment = 600, StudentId = 2 });
*/
ee.SaveChanges();
Student sx = new Student();
using (var context = new studentEntities())
{
/*
* var ss = from b in context.Students
* where b.Id == 1
* select b;
*/
// Query for the Blog named ADO.NET Blog
sx = context.Students
.Where(b => b.Id == 1)
.FirstOrDefault();
ViewBag.PaymentsList = context.Student_Payments
.Where(b => b.StudentId == studentId)
.ToList();
}
/* svm.Payments = new List<Student_Payments>();
* foreach (var item in ee.Student_Payments)
* {
* svm.Payments.Add( new Student_Payments { Id=item.Id, Payment=item.Payment, StudentId=item.StudentId} );
* }
*/
ViewBag.studentId = studentId;
return(View());
}
