public EditDepartmentsPage(Models.Departments _departments)
{
var EditViewModel = new EditDepartmentsViewModel();
EditViewModel.TheSelectedDepartments = _departments;
BindingContext = EditViewModel;
InitializeComponent();
}
public ActionResult EditIndex(int id)
{
//在控制器中获取到的name，如何送到view
//string name = tdb.Departments.First(t => t.ID == id).Name;
//ViewBag.DepartmentName = name; //ViewBag对象是mvc里的内置对象，可以灵活的添加动态属性
//return View();
//使用model传递数据：把数据库中得到的对象，完成的传递给视图
Models.Departments dep = tdb.Departments.First(t => t.ID == id);
return(View(dep));
}
public ActionResult AddDepartment(string name, int status)
{
try{
var dep = new Models.Departments();
dep.Name = name;
dep.Status = status;
tdb.Departments.Add(dep);
tdb.SaveChanges();//所有被标记的状态将被更行到数据库中
return(Content("ok"));
}
catch { return(Content("err")); }
}
public ActionResult Delete(int Id)
{
Models.Departments foundDepartment = db.Departments.FirstOrDefault(d => d.Id == Id);
if (foundDepartment != null)
{
db.Departments.Remove(foundDepartment);
db.SaveChanges();
}
else
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
public ActionResult add(string name, int Status)
{
try
{
var dep = new Models.Departments();
dep.Name = name;
dep.Status = Status;
tdb.Departments.Add(dep);
tdb.SaveChanges();
return(Content("ok"));
}
catch
{
return(Content("err"));
}
}
public ActionResult createOrEditDepartment(Models.Departments depart)
{
string query = "insert into Departments (DepartmentName,CreatedTimestamp,CreatedBy) values (@DepartmentName,@CreatedTimestamp,@CreatedBy)";
using (SqlConnection sqlCon = new SqlConnection(constrs))
{
if (ModelState.IsValid)
{
if (depart.DepartmentId == 0)
{
SqlCommand cmd = new SqlCommand(query, sqlCon);
sqlCon.Open();
cmd.Parameters.AddWithValue("@DepartmentName", depart.DepartmentName);
cmd.Parameters.AddWithValue("@CreatedTimestamp", DateTime.Now);
cmd.Parameters.AddWithValue("@CreatedBy", Session["UserName"]);
cmd.ExecuteNonQuery();
sqlCon.Close();
return(RedirectToAction("departIndexpage"));
}
else
{
query = "update Departments set DepartmentName=@DepartmentName,UpdatedBy=@UpdatedBy,UpdatedTimestamp=@UpdatedTimestamp where DepartmentId=@DepartmentId;";
SqlCommand cmd = new SqlCommand(query, sqlCon);
sqlCon.Open();
cmd.Parameters.AddWithValue("@DepartmentName", depart.DepartmentName);
cmd.Parameters.AddWithValue("@UpdatedTimestamp", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdatedBy", Session["UserName"]);
cmd.Parameters.AddWithValue("@DepartmentId", depart.DepartmentId);
cmd.ExecuteNonQuery();
sqlCon.Close();
return(RedirectToAction("departIndexpage"));
}
}
return(View());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var departmentsID = Request.QueryString["ID"];
if (departmentsID == null)
{
Contoso.Models.Departments departments = new Contoso.Models.Departments();
departments.Name = txtName.Text;
departments.Budget = Convert.ToDouble(txtBudget.Text);
departments.StartDate = Convert.ToDateTime(txtStartDate.Text);
departments.InstructorID = Convert.ToInt32(ddlInstructorID.SelectedValue);
departments.RowVersion = Convert.ToInt32(txtRowVersion.Text);
departments.CreatedDate = Convert.ToDateTime(txtCreatedDate.Text);
departments.CreatedBy = txtCreatedBy.Text;
departments.UpdatedDate = Convert.ToDateTime(txtUpdatedDate.Text);
departments.UpdatedBy = txtUpdatedBy.Text;
DepartmentsService departmentsService = new DepartmentsService();
departmentsService.AddDepartments(departments);
}
if (departmentsID != null)
{
Contoso.Models.Departments departments = new Models.Departments();
departments.ID = Convert.ToInt32(departmentsID);
departments.Name = txtName.Text;
departments.Budget = Convert.ToDouble(txtBudget.Text);
departments.StartDate = Convert.ToDateTime(txtStartDate.Text);
departments.InstructorID = Convert.ToInt32(ddlInstructorID.SelectedValue);
departments.RowVersion = Convert.ToInt32(txtRowVersion.Text);
departments.CreatedDate = Convert.ToDateTime(txtCreatedDate.Text);
departments.CreatedBy = txtCreatedBy.Text;
departments.UpdatedDate = Convert.ToDateTime(txtUpdatedDate.Text);
departments.UpdatedBy = txtUpdatedBy.Text;
DepartmentsService departmentsService = new DepartmentsService();
departmentsService.UpdateDepartments(departments);
}
}
public ActionResult getchange(int id)
{
Models.Departments dep = tdb.Departments.First(t => t.ID == id);
return(View(dep));
}
