public ActionResult Insert(MDepartment viewModel, FormCollection formCollection)
{
MDepartment mCompanyToInsert = new MDepartment();
TransferFormValuesTo(mCompanyToInsert, viewModel);
mCompanyToInsert.SetAssignedIdTo(viewModel.Id);
mCompanyToInsert.CreatedDate = DateTime.Now;
mCompanyToInsert.CreatedBy = User.Identity.Name;
mCompanyToInsert.DataStatus = EnumDataStatus.New.ToString();
_mDepartmentRepository.Save(mCompanyToInsert);
try
{
_mDepartmentRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mDepartmentRepository.DbContext.RollbackTransaction();
//throw e.GetBaseException();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
public ActionResult Insert(MDepartment viewModel, FormCollection formCollection)
{
bool isSave = true;
MDepartment mCompanyToInsert = new MDepartment();
//if (formCollection["oper"].Equals("edit"))
//{
// isSave = false;
// mCompanyToInsert = _mDepartmentRepository.Get(viewModel.Id);
//}
TransferFormValuesTo(mCompanyToInsert, viewModel);
mCompanyToInsert.SetAssignedIdTo(viewModel.Id);
mCompanyToInsert.CreatedDate = DateTime.Now;
mCompanyToInsert.CreatedBy = User.Identity.Name;
mCompanyToInsert.DataStatus = EnumDataStatus.New.ToString();
//if (isSave)
_mDepartmentRepository.Save(mCompanyToInsert);
//else
// _mDepartmentRepository.Update(mCompanyToInsert);
try
{
_mDepartmentRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mDepartmentRepository.DbContext.RollbackTransaction();
//throw e.GetBaseException();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
public void DeleteDepartmentByID(MDepartment objdept)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from tb_department where ID=@ID");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@ID", OleDbType.Integer, 4, "ID", objdept.ID)
};
OleDbHelper.ExecuteSql(sb.ToString(), param);
}
public void MDepartment_4()
{
try
{
MDepartment D = new MDepartment("ИД", "Информационные технологии в дизайне", "Киприна Людмила Юрьевна", "Институт автоматизированных систем и техногий");
Assert.AreEqual(typeof(String), D.Institute.GetType(), "Ожидался тип поля string");
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
}
public ActionResult InsertOrUpdate(MDepartment viewModel, FormCollection formCollection)
{
if (formCollection["oper"].Equals("add"))
{
return(Insert(viewModel, formCollection));
}
else if (formCollection["oper"].Equals("edit"))
{
return(Update(viewModel, formCollection));
}
return(View());
}
public DataTable SelectDepartmentByID(MDepartment objdept)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from tb_department where ID=@ID");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@ID", OleDbType.Integer, 4, "ID", objdept.ID)
};
DataTable dt = OleDbHelper.ExecuteDt(sb.ToString(), param);
return(dt);
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
department dept = new department();
MDepartment objdept = new MDepartment();
objdept.Name = txtName.Text.Trim().ToString();
objdept.Duty_description = txtContent.Text.Trim().ToString();
bool bl = dept.InsertIntoDepartment(objdept);
if (bl)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('新建部门成功!');</script>");
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('新建部门失败!');</script>");
}
}
public bool InsertIntoDepartment(MDepartment objdepartment)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into tb_department (name,duty_description) values(@DeptName,@Duty)");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@DeptName", OleDbType.VarWChar, 50, "name", objdepartment.Name),
OleDbHelper.GetParameter("@Duty", OleDbType.LongVarWChar, "duty_description", objdepartment.Duty_description)
};
bool is_succeed = OleDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Delete(MDepartment viewModel, FormCollection formCollection)
{
MDepartment mCompanyToDelete = _mDepartmentRepository.Get(viewModel.Id);
if (mCompanyToDelete != null)
{
_mDepartmentRepository.Delete(mCompanyToDelete);
}
try
{
_mDepartmentRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mDepartmentRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
/// <summary>
/// Добавление новой кафедры в список
/// </summary>
/// <param name="s"></param>
/// <param name="e"></param>
private void CreateAndCloseClick(object s, EventArgs e)
{
if (!this.shortTitleValidated || !this.fullTitleValidated || !this.departmentHeadValidated || !this.instituteValidated)
{
MessageBox.Show("Пожалуйста корректно заполните поля формы.", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
MDepartment mDepartment = new MDepartment(
this.shortTitle.Text,
this.fullTitle.Text,
this.departmentHead.Text,
this.institute.Text
);
MessageBox.Show("Форма успешно заполнена!\nНа данный момент функционал добавления кафедры в список еще не реализован.", "Успешно!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Пожалуйста корректно заполните поля формы.", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool UpdateDepartmentByID(MDepartment objdept)
{
StringBuilder sb = new StringBuilder();
sb.Append("update tb_department set Name=@DeptName,duty_description=@Duty where ID=@ID");
OleDbParameter[] param =
{
OleDbHelper.GetParameter("@DeptName", OleDbType.VarWChar, 50, "name", objdept.Name),
OleDbHelper.GetParameter("@Duty", OleDbType.LongVarWChar, "duty_description", objdept.Duty_description),
OleDbHelper.GetParameter("@ID", OleDbType.Integer, 4, "ID", objdept.ID)
};
bool is_succeed = OleDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Update(MDepartment viewModel, FormCollection formCollection)
{
MDepartment mCompanyToUpdate = _mDepartmentRepository.Get(viewModel.Id);
TransferFormValuesTo(mCompanyToUpdate, viewModel);
mCompanyToUpdate.ModifiedDate = DateTime.Now;
mCompanyToUpdate.ModifiedBy = User.Identity.Name;
mCompanyToUpdate.DataStatus = EnumDataStatus.Updated.ToString();
_mDepartmentRepository.Update(mCompanyToUpdate);
try
{
_mDepartmentRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mDepartmentRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
public bool UpdateDepartmentByID(MDepartment objdept)
{
return(dept.UpdateDepartmentByID(objdept));
}
private void TransferFormValuesTo(MDepartment mCompanyToUpdate, MDepartment mCompanyFromForm)
{
mCompanyToUpdate.DepartmentName = mCompanyFromForm.DepartmentName;
mCompanyToUpdate.DepartmentDesc = mCompanyFromForm.DepartmentDesc;
mCompanyToUpdate.DepartmentStatus = mCompanyFromForm.DepartmentStatus;
}
/// <summary>
/// Обработка события изменения полного названия кафедры
/// </summary>
/// <param name="s"></param>
/// <param name="e"></param>
private void FullTitleTextChanged(object s, EventArgs e)
{
bool v = ValidateHandler(MDepartment.ValidateFullTitle((s as TextBox).Text, shortTitle.Text, out string[] res), res, s, this.fullTitleTooltip);
this.fullTitleValidated = v;
}
/// <summary>
/// Обработка события изменения названия института
/// </summary>
/// <param name="s"></param>
/// <param name="e"></param>
private void InstituteTextChanged(object s, EventArgs e)
{
bool v = ValidateHandler(MDepartment.ValidateInstitute((s as TextBox).Text, out string[] res), res, s, this.instituteTooltip);
this.instituteValidated = v;
}
public DataTable SelectDepartmentByID(MDepartment objdept)
{
return(dept.SelectDepartmentByID(objdept));
}
public void DeleteDepartmentByID(MDepartment objdept)
{
dept.DeleteDepartmentByID(objdept);
}
public bool InsertIntoDepartment(MDepartment objdepartment)
{
return(dept.InsertIntoDepartment(objdepartment));
}
/// <summary>
/// Обработка события изменения завудующего кафедрой
/// </summary>
/// <param name="s"></param>
/// <param name="e"></param>
private void DepartmentHeadTextChanged(object s, EventArgs e)
{
bool v = ValidateHandler(MDepartment.ValidateDepartmentHead((s as TextBox).Text, out string[] res), res, s, this.departmentHeadTooltip);
this.departmentHeadValidated = v;
}
