/// <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_ItemModel updateDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
using (BaseDao context = new BaseDao())
{
ms_items _departments = context.ms_items.FirstOrDefault(d => d.ID.Equals(updateDto.ID));
if (_departments != null)
{
_departments.Code = updateDto.Code;
_departments.Name1 = updateDto.Name1;
_departments.Name2 = updateDto.Name2;
_departments.GroupCode = updateDto.GroupCode;
_departments.InvUnitCode = updateDto.InvUnitCode;
//_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_Items);
//Save to database
returnCode = context.Saves(CommonData.FunctionGr.MS_Items, CommonData.Action.Update,
new
{
_departments.Code,
_departments.Name1,
_departments.Name2,
_departments.Name3,
_departments.Remark,
},
typeof(ms_items).Name);
}
else
{
returnCode = CommonData.DbReturnCode.DataNotFound;
}
}
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <summary>
/// Delete Department list
/// </summary>
/// <param name="listDeleteData">
/// List that contains Department ID
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int DeleteData(List <int> listDeleteData)
{
int returnCode = CommonData.DbReturnCode.Succeed;
List <object> lstHis = new List <object>();
try
{
using (BaseDao context = new BaseDao())
{
foreach (int id in listDeleteData)
{
ms_items _departments = context.ms_items.FirstOrDefault(d => d.ID.Equals(id));
if (_departments != null)
{
//Delete object
context.ms_items.DeleteObject(_departments);
lstHis.Add(new
{
_departments.Code,
_departments.Name1,
_departments.Name2,
_departments.Name3,
_departments.Remark,
});
}
else
{
return(CommonData.DbReturnCode.DataNotFound);
}
}
//returnCode = context.Saves();
returnCode = context.Saves(CommonData.FunctionGr.MS_Items, CommonData.Action.Delete, lstHis, typeof(ms_items).Name);
}
}
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_ItemModel insertDto)
{
int returnCode = CommonData.DbReturnCode.Succeed;
try
{
ms_items _departments = new ms_items();
_departments.Code = insertDto.Code;
_departments.Name1 = insertDto.Name1;
_departments.Name2 = insertDto.Name2;
_departments.GroupCode = insertDto.GroupCode;
_departments.InvUnitCode = insertDto.InvUnitCode;
//_departments.Insert_PIC = !CommonMethod.IsNullOrEmpty(insertDto.Insert_PIC) ? insertDto.Insert_PIC : string.Empty;
//Create insert information
//this.CreateInsertHistory(_departments, CommonData.FunctionGr.ms_items);
//Add Factory
this.ms_items.AddObject(_departments);
//Save to database
returnCode = this.Saves(CommonData.FunctionGr.MS_Items, CommonData.Action.Insert,
new
{
_departments.Code,
_departments.Name1,
_departments.Name2,
_departments.Name3,
_departments.Remark,
},
typeof(ms_items).Name);
}
catch (Exception ex)
{
string error = ex.Message.ToString();
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
