/// <summary>
/// Insert Department data to Database
/// </summary>
/// <param name="insertDto">
/// object that contains data to insert
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int InsertData(IModel insertDto)
{
MS_DepartmentDao dao = new MS_DepartmentDao();
MS_DepartmentModel dto = (MS_DepartmentModel)insertDto;
return(dao.InsertData(dto));
}
/// <summary>
/// Update Department data to Database
/// </summary>
/// <param name="updateDto">
/// object that contains data to update
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int UpdateData(IModel updateDto)
{
MS_DepartmentDao dao = new MS_DepartmentDao();
MS_DepartmentModel dto = (MS_DepartmentModel)updateDto;
return(dao.UpdateData(dto));
}
/// <summary>
/// Search Data in MS_Department table
/// </summary>
/// <param name="IModel">
/// Dto of Department form
/// </param>
/// <param name="dtResult">
/// Out a Datatable that contains search result(all columns) in Department table
/// </param>
/// <returns>
/// 0: Update successful
/// 1: Access denied, login to database fail(invalid username, invalid password)
/// 2: Invalid host, cannot find server(host) that set in app config file
/// 3: Invalid database, cannot find database that set in DbConfig file
/// 4: Lost connection, cannot connect to database because lost connection
/// 5: Duplicate key: insert Primary Key or Unique Key that already exist in database
/// 6: Forgeign key not exist: insert a foreign key that not exist in primary key
/// 7: Foreign Key Violation: Foreign Key Violation (delete primary key that is foreign key in other table)
/// 8: Data not found: Delete or Update data that not exist in database
/// 9: Exception occured: other exception
/// </returns>
public int SearchData(IModel searchDto, out List <IModel> lstResult)
{
MS_DepartmentDao dao = new MS_DepartmentDao();
MS_DepartmentModel dto = (MS_DepartmentModel)searchDto;
return(dao.SelectData(dto, out lstResult));
}
/// <summary>
/// Search Data in ms_item table
/// </summary>
/// <param name="selectDto">
/// Dto that contains conditions: Code, Name(VN), Name(EN), Name(JP), GroupCode
/// </param>
/// <param name="dtResult">
/// Out a Datatable that contains search result(all columns) in ms_item table
/// </param>
/// <returns>
/// 0: Search successful
/// others: Sql Exception
/// </returns>
public int SelectData(MS_DepartmentModel selectDto, out List <IModel> lstResult)
{
int returnCode = CommonData.DbReturnCode.Succeed;
lstResult = new List <IModel>();
try
{
IQueryable <ms_departments> query = this.ms_departments.AsQueryable();
#region Search Condition
//Filter by Department Code
if (!CommonMethod.IsNullOrEmpty(selectDto.Code))
{
query = query.Where(d => d.Code.Contains(selectDto.Code));
}
//Filter by Department Name
if (!CommonMethod.IsNullOrEmpty(selectDto.Name1))
{
query = query.Where(d => d.Name1.Contains(selectDto.Name1));
}
if (!CommonMethod.IsNullOrEmpty(selectDto.Name2))
{
query = query.Where(d => d.Name2.Contains(selectDto.Name2));
}
#endregion
#region Search data
lstResult = query.Select(ss => new MS_DepartmentModel
{
ID = ss.ID,
Code = ss.Code,
Name1 = ss.Name1,
Name2 = ss.Name2,
Name3 = ss.Name3,
Remark = ss.Remark,
})
.ToList()
.Cast <IModel>()
.ToList();
#endregion
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <summary>
/// Search Data in ms_item table
/// </summary>
/// <param name="selectDto">
/// Dto that contains conditions: Code, Name(VN), Name(EN), Name(JP), GroupCode
/// </param>
/// <param name="dtResult">
/// Out a Datatable that contains search result(all columns) in ms_item table
/// </param>
/// <returns>
/// 0: Search successful
/// others: Sql Exception
/// </returns>
public int SelectData(MS_DepartmentModel selectDto, out DataTable dtResult)
{
int returnCode = CommonData.DbReturnCode.Succeed;
dtResult = new DataTable();
try
{
IQueryable <ms_departments> query = this.ms_departments.AsQueryable();
#region Search Condition
//Filter by Department Code
if (!CommonMethod.IsNullOrEmpty(selectDto.Code))
{
query = query.Where(d => d.Code.Contains(selectDto.Code));
}
//Filter by Department Name
if (!CommonMethod.IsNullOrEmpty(selectDto.Name1))
{
query = query.Where(d => d.Name1.Contains(selectDto.Name1));
}
if (!CommonMethod.IsNullOrEmpty(selectDto.Name2))
{
query = query.Where(d => d.Name2.Contains(selectDto.Name2));
}
#endregion
#region Search data
var queryResult = from d in query
select new MS_DepartmentModel
{
ID = d.ID,
Code = d.Code,
Name1 = d.Name1,
Name2 = d.Name2,
Name3 = d.Name3,
Remark = d.Remark,
};
dtResult = base.ToDataTable(queryResult);
#endregion
}
catch (Exception ex)
{
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <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);
}
