/// <summary>
/// Update Department
/// </summary>
/// <param name="updateDto">
/// Dto that contains all Department data
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int UpdateData(MS_DepartmentModel updateDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
using (BaseDao context = new BaseDao())
{
ms_departments _departments = context.ms_departments.FirstOrDefault(d => d.ID.Equals(updateDto.ID));
if (_departments != null)
{
_departments.Code = updateDto.Code;
_departments.Name1 = updateDto.Name1;
_departments.Name2 = updateDto.Name2;
_departments.Name3 = updateDto.Name3;
_departments.Remark = updateDto.Remark;
//_departments.Insert_PIC = !CommonMethod.IsNullOrEmpty(updateDto.Insert_PIC) ? updateDto.Insert_PIC : string.Empty;
//_departments.Update_PIC = !CommonMethod.IsNullOrEmpty(updateDto.Update_PIC) ? updateDto.Update_PIC : string.Empty;
//Create insert information
this.CreateUpdateHistory(_departments, CommonData.FunctionGr.MS_Departments);
//Save to database
returnCode = context.Saves(CommonData.FunctionGr.MS_Departments, CommonData.Action.Update,
new
{
_departments.Code,
_departments.Name1,
_departments.Name2,
_departments.Name3,
_departments.Remark,
},
typeof(ms_departments).Name);
}
else
{
returnCode = CommonData.DbReturnCode.DataNotFound;
}
}
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <summary>
/// Insert new Department
/// </summary>
/// <param name="insertDto">
/// Dto that contains all Department data
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int InsertData(MS_DepartmentModel insertDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
ms_departments _departments = new ms_departments();
_departments.Code = insertDto.Code;
_departments.Name1 = insertDto.Name1;
_departments.Name2 = insertDto.Name2;
_departments.Name3 = insertDto.Name3;
_departments.Remark = insertDto.Remark;
//_departments.Insert_PIC = !CommonMethod.IsNullOrEmpty(insertDto.Insert_PIC) ? insertDto.Insert_PIC : string.Empty;
//Create insert information
//this.CreateInsertHistory(_departments, CommonData.FunctionGr.MS_Departments);
//Add Factory
this.ms_departments.AddObject(_departments);
//Save to database
returnCode = this.Saves(CommonData.FunctionGr.MS_Departments, CommonData.Action.Insert,
new
{
_departments.Code,
_departments.Name1,
_departments.Name2,
_departments.Name3,
_departments.Remark,
},
typeof(ms_departments).Name);
}
catch (Exception ex)
{
string error = ex.Message.ToString();
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
