/// <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_ItemDao dao = new MS_ItemDao();
MS_ItemModel dto = (MS_ItemModel)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_ItemDao dao = new MS_ItemDao();
MS_ItemModel dto = (MS_ItemModel)updateDto;
return(dao.UpdateData(dto));
}
/// <summary>
/// Search Data in MS_Item 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_ItemDao dao = new MS_ItemDao();
MS_ItemModel dto = (MS_ItemModel)searchDto;
return(dao.SelectData(dto, out lstResult));
}
/// <summary>
/// Delete Department data from Database
/// </summary>
/// <param name="ListDto">
/// list object that contains data to delete
/// </param>
/// <returns>
/// 0: insert successful
/// others: Sql Exception
/// </returns>
public int DeleteData(List <int> listDto)
{
MS_ItemDao dao = new MS_ItemDao();
return(dao.DeleteData(listDto));
}
public int SearchData(int id, out IModel modelResult)
{
MS_ItemDao dao = new MS_ItemDao();
return(dao.SelectData(id, out modelResult));
}
public int SelectInvUnitData(out List <MS_ItemGroupModel> lstInvUnit)
{
MS_ItemDao dao = new MS_ItemDao();
return(dao.SelectInvUnitData(out lstInvUnit));
}
public int SelectItemGrpData(out List <MS_ItemGroupModel> result)
{
MS_ItemDao dao = new MS_ItemDao();
return(dao.SelectItemGrpData(out result));
}
