public ActionResult Create(tblTeacher tblTeacher, HttpPostedFileBase FileUpload)
{
if (ModelState.IsValid)
{
//Save image in folder
string FileName = Path.GetFileName(FileUpload.FileName);
string SaveLocation = Server.MapPath("~/Upload/" + FileName);
FileUpload.SaveAs(SaveLocation);
//save image name in database
tblTeacher.teacherPicName = "~/Upload/" + FileName;
// byte image Save
tblTeacher.teacherPicture = new byte [FileUpload.ContentLength];
ViewBag.TeacherPicture = FileUpload.InputStream.Read(tblTeacher.teacherPicture, 0, FileUpload.ContentLength);
db.tblTeachers.Add(tblTeacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblTeacher));
}
private static void update(TeacherContext ctx, Teacher teach)
{
teach.FirstName = "نیکا";
ctx.SaveChanges();
teach.LastName = "After Update";
ctx.SaveChanges();
teach.FirstName = "پریسا";
ctx.SaveChanges();
}
private static void TestChangeTracker(TeacherContext teacherContext)
{
var person = teacherContext.Teachers.FirstOrDefault();
//teacherContext.Teachers.Add(new
// Entities.Teacher
//{
// FirstName = "Alireza",
// LastName = "Oroumand",
//});
person.FirstName = "Ali reza";
teacherContext.SaveChanges();
person.LastName = "Oroumand AfterUpdate";
teacherContext.SaveChanges();
person.FirstName = "Alireza";
teacherContext.SaveChanges();
}
public ActionResult Edit(Teacher teacher)
{
Teacher newTeacher = db.Teachers.Find(teacher.ID);
newTeacher.FirstName = teacher.FirstName;
newTeacher.LastName = teacher.LastName;
newTeacher.CathedraID = teacher.CathedraID;
db.SaveChanges();
return(RedirectToAction("Index"));
}
private static void Tracker()
{
TeacherContext teacherContext = new TeacherContext();
//teacherContext.Teachers.Add(new Entites.Teacher
//{
// FirstName = "Omid",
// LastName = "Khaleghi"
//});
var a = teacherContext.Teachers.FirstOrDefault();
a.LastName = "nouri arejani";
teacherContext.SaveChanges();
a.FirstName = "ALi";
teacherContext.SaveChanges();
System.Console.WriteLine("W");
Console.ReadLine();
}
private static void add(TeacherContext ctx)
{
ctx.Teacher.Add(new Teacher
{
FirstName = "نیکا",
LastName = "نیکا"
});
ctx.Teacher.Add(new Teacher
{
FirstName = "پرکیا",
LastName = "پریکا"
});
ctx.SaveChanges();
}
public async Task <IActionResult> RequestRegister(RequestIn request)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
foreach (var item in request.items)
{
if (item.id_item == null)
{
return(BadRequest(new { errorText = "Empty item field!" }));
}
}
// TO DO count sum of items
double sum = 0;
var items = await _context.Items.FromSqlRaw("SELECT id_item, cost, prov_name, name FROM Items").ToListAsync();
foreach (ItemForRequestIn item in request.items)
{
sum += items.Where(i => i.id_item == item.id_item).First().cost *item.amount;
}
Requests requests = new Requests();
requests.date = DateTime.Now;
requests.sum = sum;
requests.id_teacher = get_teacherId_from_TeacherEmail(User.Identity.Name);
requests.id_manager = get_managerId_from_TeacherEmail(User.Identity.Name);
_context.Requests.Add(requests);
_context.SaveChanges();
foreach (ItemForRequestIn ifr in request.items)
{
await _context.Database.ExecuteSqlInterpolatedAsync($"INSERT INTO Request_items VALUES ({null}, {requests.id_request}, {ifr.id_item}, {ifr.amount} );");
}
return(Ok());
}
public int Create(Teacher teacher)
{
_teacherContext.Teachers.Add(teacher);
return(_teacherContext.SaveChanges());
}
public static void Test()
{
Database.SetInitializer <TestContext>(null);
Database.SetInitializer <TeacherContext>(null);
using (var context = new TestContext())
{
context.Database.Log = Console.WriteLine;
var sGuid1 = Guid.NewGuid().ToString();
var sGuid2 = Guid.NewGuid().ToString();
var tGuid1 = Guid.NewGuid().ToString();
var tGuid2 = Guid.NewGuid().ToString();
using (var transaction = context.Database.BeginTransaction())
{
try
{
Student s1 = new Student()
{
ID = sGuid1,
Name = "张萨姆",
StudentNumber = 1,
IsMale = true
};
Student s2 = new Student()
{
ID = sGuid2,
Name = "张市长",
StudentNumber = 2,
IsMale = false
};
Teacher t1 = new Teacher()
{
ID = tGuid1,
Name = "张巨鹿"
};
Teacher t2 = new Teacher()
{
ID = tGuid2,
Name = "老黄"
};
t1.Students.Add(s1);
t1.Students.Add(s2);
t2.Students.Add(s1);
t2.Students.Add(s2);
context.Entry(s1).State = EntityState.Added;
context.Entry(s2).State = EntityState.Added;
context.Entry(t1).State = EntityState.Added;
context.Entry(t2).State = EntityState.Added;
TeacherContext thContext = new TeacherContext(
context.Database.Connection,
contextOwnsConnection: false);
thContext.Database.UseTransaction(transaction.UnderlyingTransaction);
int c = context.SaveChanges();
Console.WriteLine("SaveChanges影响的行数:{0}", c);
//c = thContext.Database.ExecuteSqlCommand(" UPDATE STUDENT SET NAME=:NAME WHERE ID=:ID", new OracleParameter[]{
// new OracleParameter("@NAME","东源"),
// new OracleParameter("@ID",sGuid1),
//});
//Console.WriteLine("ExecuteSqlCommand影响的行数:{0}", c);
t1.Name = "落月";
//thContext.Entry(t1).Property(p => p.Name).IsModified = true;
thContext.Entry(t1).State = EntityState.Modified;
c = thContext.SaveChanges();
Console.WriteLine("thContext的SaveChanges影响的行数:{0}", c);
transaction.Commit();
try
{
Console.WriteLine("----------------------------学生信息-------------------------------------");
context.Entry(s1).Reload();
var studentLst = context.Students.Local;
Console.WriteLine(string.Format("学生的数量:{0}", studentLst.Count));
foreach (var s in studentLst)
{
Console.WriteLine(string.Format("ID:{0},Name:{1},Sex:{2}", s.ID, s.Name, s.IsMale));
foreach (Teacher tc in s.Teachers)
{
Console.WriteLine(string.Format("学生对应的老师( -- ID:{0},姓名:{1} -- )", tc.ID, tc.Name));
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
transaction.Rollback();
}
}
}
}
