public List <DtoBusiness> ListBraBusiness(DtoBusiness bus)
{
Entities_Visit ctx;
List <DtoBusiness> listBranchOffice = null;
try
{
using (ctx = new Entities_Visit())
{
listBranchOffice = (from bra in ctx.BRANCH_COMPANY
where bra.BUS_ID == bus.iBus_id
select new DtoBusiness()
{
iBra_buis_id = bra.BRA_BUIS_ID,
sBra_buis_name = bra.BRA_BUIS_NAME
}
).ToList();
return(listBranchOffice);
}
}
catch (Exception e)
{
}
return(listBranchOffice);
}
public DtoBusiness AddBusinessToBLL(DtoBusiness b)
{
DalBusiness bb = new DalBusiness();
return(Converters.Converters.ConvertBusinessToDTO
(bb.addBusinessToSQL(Converters.Converters.ConvertBusinessToDAL(b))));
}
public DtoBusiness AddBusiness(DtoBusiness myyy)
{
if (GetIfBusinessExist(Convert.ToString(myyy.businessID)) == null)
{
myBllBusiness.AddBusinessToBLL(myyy);
return(myyy);
}
else
{
return(null);
}
}
public static Business ConvertBusinessToDAL(DtoBusiness buss)
{
Business business = new Business()
{
businessAddress = buss.businessAddress,
businessCity = buss.businessCity,
businessID = buss.businessID,
businessName = buss.businessName,
businessOwnerID = buss.businessOwnerID,
businessPhoneNo = buss.businessPhoneNo,
businessSpace = buss.businessSpace,
noOfRegisters = buss.noOfRegisters
};
return(business);
}
public static DtoBusiness ConvertBusinessToDTO(Business buss)
{
DtoBusiness business = new DtoBusiness()
{
businessAddress = buss.businessAddress,
businessCity = buss.businessCity,
businessID = buss.businessID,
businessName = buss.businessName,
businessOwnerID = buss.businessOwnerID,
businessPhoneNo = buss.businessPhoneNo,
businessSpace = Convert.ToBoolean(buss.businessSpace),
noOfRegisters = Convert.ToInt32(buss.noOfRegisters)
};
return(business);
}
public List <DtoBusiness> ListBusinessSelect(DtoBusiness bus)
{
throw new NotImplementedException();
}
public bool InsertUpdateBusiness(DtoBusiness bus)
{
throw new NotImplementedException();
}
/*
* public bool InsertUpdateEmployee(DtoEmployee emp)
* {
* Entities_Visit ctx;
* bool bResult = false;
* using (ctx = new Entities_Visit())
* {
*
* try
* {
* var query = ctx.PR_INSET_UPDATE_EMPLOYEE
* (
* emp.iRol_id,emp.iBra_buis_id,emp.sEmp_document,emp.sEmp_name,emp.sEmp_surname,
* emp.sEmp_phone,emp.sEmp_phone2,emp.sEmp_cell_phone,emp.sEmp_cell_phone,emp.sEmp_addres,
* emp.sEmp_mail,emp.sEmp_mail2,emp.sEmp_password,emp.bemp_state,emp.sEmp_permission,emp.sEmp_photo
* );
* int result =Int32.Parse(query.ToString());
* bResult =true;
* }
* catch (Exception e)
* {
*
*
* }
* }
* return bResult;
* }
* public bool DeleteEmployee(DtoEmployee emp)
* {
* Entities_Visit ctx = new Entities_Visit();
* bool bResult = false;
* using (ctx = new Entities_Visit())
* {
*
* try
* {
* var query = ctx.PR_DELETE_EMPLOYEE
* (
* emp.iEmp_id, emp.sEmp_document
* );
* int result = Int32.Parse(query.ToString());
* bResult = true;
* }
* catch (Exception e)
* {
*
*
* }
* }
* return bResult;
*
* }
*
* public List<DtoEmployee> ListEmployee(DtoEmployee emp) {
* Entities_Visit ctx;
* using (ctx = new Entities_Visit()) {
* List<DtoEmployee> list = new List<DtoEmployee>();
* DtoEmployee objEmployee;
* try
* {
* var query = ctx.PR_SEARCH_EMPLOYEE(emp.bemp_state, emp.iBra_buis_id);
* foreach (var employee in query) {
* objEmployee = new DtoEmployee();
* objEmployee.iEmp_id = (int)employee.EMP_ID;
* objEmployee.iRol_id = (int)employee.ROL_ID;
* objEmployee.sRol_name = employee.ROL_NAME;
* objEmployee.sEmp_document = employee.EMP_DOCUMENT;
* objEmployee.sEmp_name = employee.EMP_NAME;
* objEmployee.sEmp_surname = employee.EMP_SURNAME;
* objEmployee.sEmp_phone = employee.EMP_PHONE;
* objEmployee.sEmp_phone2 = employee.EMP_PHONE;
* objEmployee.sEmp_cell_phone = employee.EMP_CELL_PHONE;
* objEmployee.sEmp_cell_phone2 = employee.EMP_CELL_PHONE2;
* objEmployee.sEmp_addres = employee.EMP_ADDRES;
* objEmployee.sEmp_mail = employee.EMP_MAIL;
* objEmployee.sEmp_mail2 = employee.EMP_MAIL2;
* list.Add(objEmployee);
* }
* list.ToList();
* }
* catch (Exception e) {
* }
* return list;
* }
* }
* public List<DtoEmployee> ListEmployeeSelect(DtoEmployee emp)
* {
* Entities_Visit ctx;
* using (ctx = new Entities_Visit())
* {
* List<DtoEmployee> list = new List<DtoEmployee>();
* DtoEmployee objEmployee;
* try
* {
* var query = ctx.PR_SEARCH_EMPLOYEE_SELECTION(emp.bemp_state, emp.iBra_buis_id,emp.sEmp_name,emp.sEmp_surname,emp.sEmp_document,emp.sEmp_mail,emp.sRol_name);
* foreach (var employee in query)
* {
* objEmployee = new DtoEmployee();
* objEmployee.iEmp_id = (int)employee.EMP_ID;
* objEmployee.iRol_id = (int)employee.ROL_ID;
* objEmployee.sRol_name = employee.ROL_NAME;
* objEmployee.sEmp_document = employee.EMP_DOCUMENT;
* objEmployee.sEmp_name = employee.EMP_NAME;
* objEmployee.sEmp_surname = employee.EMP_SURNAME;
* objEmployee.sEmp_phone = employee.EMP_PHONE;
* objEmployee.sEmp_phone2 = employee.EMP_PHONE;
* objEmployee.sEmp_cell_phone = employee.EMP_CELL_PHONE;
* objEmployee.sEmp_cell_phone2 = employee.EMP_CELL_PHONE2;
* objEmployee.sEmp_addres = employee.EMP_ADDRES;
* objEmployee.sEmp_mail = employee.EMP_MAIL;
* objEmployee.sEmp_mail2 = employee.EMP_MAIL2;
* list.Add(objEmployee);
* }
* list.ToList();
* }
* catch (Exception e)
* {
* }
* return list;
* }
* }
*
* public List<DtoEmployee> ListRole()
* {
* Entities_Visit ctx;
* using (ctx = new Entities_Visit())
* {
*
* var listRole= (from rol in ctx.ROLE
*
* select new DtoEmployee()
* {
*
*
* iRol_id = rol.ROL_ID,
* sRol_name = rol.ROL_NAME
*
* }
* ).ToList();
*
* return listRole;
* }
*
* }*/
public bool DeleteBusiness(DtoBusiness bus)
{
throw new NotImplementedException();
}
