public async Task <IActionResult> Edit([Bind("DeptCode,DeptName,DeptDesc,CompanyCode,Id,Is_Active,Created_Date,Created_By,Updated_Date,Updated_By")] M_Department m_Department)
{
if (ModelState.IsValid)
{
m_Department.Updated_By = await base.CurrentUserId();
ResultObject resultObj;
try
{
using (var deptBll = new DepartmentBLL())
{
resultObj = await deptBll.UpdateDepartment(m_Department);
_cache.Remove("CACHE_MASTER_DEPARTMENT");
}
return(Json(new { success = true, data = (M_Department)resultObj.ObjectValue, message = "Department Update." }));
}
catch (Exception ex)
{
return(Json(new { success = false, data = m_Department, message = ex.Message }));
}
}
var err = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList();
return(Json(new { success = false, errors = err, data = m_Department, message = "Update Failed" }));
}
public ActionResult UpdateDepartment(M_Department data)
{
try
{
data.CreateID = user.EmployeeNo;
data.CreateDate = DateTime.Now;
data.UpdateID = user.EmployeeNo;
data.UpdateDate = DateTime.Now;
string Query = "";
Query += "UPDATE [dbo].[M_Department] SET " +
" [DepartmentName] = '" + data.DepartmentName + "'" +
" ,[DivisionID] = '" + data.DivisionID + "'" +
" ,[UpdateID]= '" + data.UpdateID + "'" +
" ,[UpdateDate]= '" + data.UpdateDate + "'" +
" WHERE [ID] = '" + data.ID + "'";
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandText = Query;
conn.Open();
cmdSql.ExecuteNonQuery();
conn.Close();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
public List <M_Department> GetDeparmentList(long DivisionID)
{
List <M_Department> list = new List <M_Department>();
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandText = "SELECT * FROM M_Department WHERE IsDeleted <> 1 AND DivisionID ='" + DivisionID + "'";
cmdSql.CommandTimeout = 0;
conn.Open();
//cmdSql.ExecuteNonQuery();
using (SqlDataReader rdr = cmdSql.ExecuteReader())
{
while (rdr.Read())
{
M_Department getter = new M_Department();
getter.ID = Convert.ToInt32(rdr["ID"]); //.ToString();
getter.DivisionID = Convert.ToInt32(rdr["DivisionID"]); //.ToString();
getter.DepartmentName = rdr["DepartmentName"].ToString();
list.Add(getter);
}
}
conn.Close();
foreach (M_Department m in list)
{
m.SectionList = GetSectionList(m.ID);
}
return(list);
}
// GET: Department/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
M_Department editableDepartment = _repositoriyDepartment.FindById(id.Value);
if (editableDepartment == null)
{
return(HttpNotFound());
}
DepartmentViewModel departmentVM = new DepartmentViewModel(editableDepartment);
var listDir = ViewModelFactory.GetSelectedListEmployersName(_employers);
if (listDir.Count() != 0)
{
listDir.Where(li => li.Value == departmentVM.NameDirector)
.FirstOrDefault()
.Selected = true;
}
ViewBag.DirectorName = listDir;
return(View(departmentVM));
}
public async Task <ResultObject> DeleteDepartment(M_Department dept)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = dept
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strId", dept.Id),
new MySqlParameter("strDelete_By", dept.Updated_By)
};
//Output Parameter no need to define. @`strId`
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_department_delete( ?, ?)", parameters : sqlParams);
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public ActionResult Delete(int id)
{
M_Department deletedDepartment = _repositoriyDepartment.FindById(id);
_repositoriyDepartment.Remove(deletedDepartment);
return(RedirectToAction("Index"));
}
public override void SetModel(M_Base modelBase)
{
M_Department modelEntity = modelBase as M_Department;
_model = modelEntity;
Id = modelEntity.Id;
DepartmentName = modelEntity.DepartmentName;
Director = modelEntity.Director;
Employers = modelEntity.Employee;
}
public ActionResult Create(DepartmentViewModel createdDepartment)
{
if (ModelState.IsValid)
{
M_Department departmentModel = createdDepartment.GetModel() as M_Department;
_repositoriyDepartment.Create(departmentModel);
return(RedirectToAction("Index"));
}
return(View(createdDepartment));
}
public ActionResult Edit(DepartmentViewModel departmentVM)
{
M_Department departmentModel = departmentVM.GetModel() as M_Department;
if (ModelState.IsValid)
{
_repositoriyDepartment.Update(departmentModel);
return(RedirectToAction("Index"));
}
return(View(departmentVM));
}
// GET: Department/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
M_Department departmentModel = _repositoriyDepartment.FindById(id.Value);
if (departmentModel == null)
{
return(HttpNotFound());
}
DepartmentViewModel departmentVM = new DepartmentViewModel(departmentModel);
return(View(departmentVM));
}
public ActionResult CreateDepartment(M_Department data)
{
try
{
data.CreateID = user.EmployeeNo;
data.CreateDate = DateTime.Now;
data.UpdateID = user.EmployeeNo;
data.UpdateDate = DateTime.Now;
string Query = "";
Query += "INSERT INTO [dbo].[M_Department]" +
" ([DepartmentName]" +
" ,[DivisionID]" +
" ,[IsDeleted]" +
" ,[CreateID]" +
" ,[CreateDate]" +
" ,[UpdateID]" +
" ,[UpdateDate])" +
"VALUES" +
" ('" + data.DepartmentName + "'," +
" '" + data.DivisionID + "'," +
" '" + 0 + "'," +
" '" + data.CreateID + "'," +
" '" + data.CreateDate + "'," +
" '" + data.UpdateID + "'," +
" '" + data.UpdateDate + "')";
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandText = Query;
conn.Open();
cmdSql.ExecuteNonQuery();
conn.Close();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
//public int InsertDepartment(ref M_Department dept)
//{
// //newId = null;
// int rowaffected = -1;
// using (var context = new MasterDbContext(contextOptions))
// {
// using (var transaction = context.Database.BeginTransaction())
// {
// try
// {
// MySqlParameter[] sqlParams = new MySqlParameter[] {
// new MySqlParameter("strDeptCode", dept.DeptCode),
// new MySqlParameter("strDeptName", dept.DeptName),
// new MySqlParameter("strDeptDesc", dept.DeptDesc),
// new MySqlParameter("strCompanyCode", dept.CompanyCode),
// new MySqlParameter("strIs_Active", dept.Is_Active),
// new MySqlParameter("strCreated_By", dept.Created_By)
// };
// rowaffected = context.Database.ExecuteSqlCommand("call sp_department_insert(@`strId`, ?, ?, ?, ?, ?, ?)", parameters: sqlParams);
// //new department after insert.
// var newDept = context.Department.FromSql("SELECT * FROM m_department WHERE Id = @`strId`;").ToListAsync();
// dept = newDept.Result[0];
// transaction.Commit();
// return rowaffected;
// }
// catch (Exception ex)
// {
// transaction.Rollback();
// throw ex;
// }
// }
// }
//}
public async Task <ResultObject> InsertDepartment(M_Department dept)
{
//newId = null;
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = dept
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strDeptCode", dept.DeptCode),
new MySqlParameter("strDeptName", dept.DeptName),
new MySqlParameter("strDeptDesc", dept.DeptDesc),
new MySqlParameter("strCompanyCode", dept.CompanyCode),
new MySqlParameter("strIs_Active", dept.Is_Active),
new MySqlParameter("strCreated_By", dept.Created_By)
};
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_department_insert(@`strId`, ?, ?, ?, ?, ?, ?)", parameters : sqlParams);
//new department after insert.
var newDept = context.Department.FromSql("SELECT * FROM m_department WHERE Id = @`strId`;").ToListAsync();
resultObj.ObjectValue = newDept.Result[0];
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public async Task <ResultObject> UpdateDepartment(M_Department dept)
{
var resultObj = new ResultObject {
RowAffected = -1, ObjectValue = dept
};
using (var context = new MasterDbContext(contextOptions))
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.Entry(dept).State = EntityState.Modified;
MySqlParameter[] sqlParams = new MySqlParameter[] {
new MySqlParameter("strId", dept.Id),
new MySqlParameter("strDeptCode", dept.DeptCode),
new MySqlParameter("strDeptName", dept.DeptName),
new MySqlParameter("strDeptDesc", dept.DeptDesc),
new MySqlParameter("strCompanyCode", dept.CompanyCode),
new MySqlParameter("strIs_Active", dept.Is_Active),
new MySqlParameter("strCreated_By", dept.Updated_By)
};
//Output Parameter no need to define. @`strId`
resultObj.RowAffected = await context.Database.ExecuteSqlCommandAsync("call sp_department_update(?, ?, ?, ?, ?, ?, ?)", parameters : sqlParams);
transaction.Commit();
return(resultObj);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public DepartmentViewModel(M_Department model) : base(model)
{
}