public bool InitializeCompanyInfo(int mCompanySerial)
{
companySerial = mCompanySerial;
String sqlQueryPart1 = @"select generic_work_fields.id,
specific_work_fields.id,
employees_info.employee_id,
company_name.company_name,
generic_work_fields.generic_work_field,
specific_work_fields.specific_work_field,
employees_info.name
from erp_system.dbo.company_name
inner join erp_system.dbo.employees_info
on company_name.added_by = employees_info.employee_id
inner join erp_system.dbo.company_field_of_work
on company_name.company_serial = company_field_of_work.company_serial
inner join erp_system.dbo.specific_work_fields
on company_field_of_work.work_field = specific_work_fields.id
inner join erp_system.dbo.generic_work_fields
on specific_work_fields.generic_work_field = generic_work_fields.id
where company_name.company_serial = " ;
String sqlQueryPart2 = ";";
sqlQuery = String.Empty;
sqlQuery += sqlQueryPart1;
sqlQuery += companySerial;
sqlQuery += sqlQueryPart2;
BASIC_STRUCTS.SQL_COLUMN_COUNT_STRUCT queryColumns = new BASIC_STRUCTS.SQL_COLUMN_COUNT_STRUCT();
queryColumns.sql_int = 3;
queryColumns.sql_string = 4;
if (!initializationObject.GetRows(sqlQuery, queryColumns, BASIC_MACROS.SEVERITY_HIGH))
{
return(false);
}
primaryFieldId = initializationObject.rows[0].sql_int[0];
secondaryFieldId = initializationObject.rows[1].sql_int[0];
ownerUserId = initializationObject.rows[2].sql_int[0];
companyName = initializationObject.rows[0].sql_string[0];
primaryField = initializationObject.rows[1].sql_string[0];
secondaryField = initializationObject.rows[2].sql_string[0];
ownerUser = initializationObject.rows[3].sql_string[0];
addressKnown = false;
return(true);
}
public bool InitializeEmployeeInfo(String mBusinessEmail)
{
businessEmail = mBusinessEmail;
String sqlQueryPart1 = @"select employees_info.employee_id,
employees_info.employee_department,
employees_info.employee_team,
employees_info.employee_position,
employees_educational_qualifications.graduation_year,
employees_educational_qualifications.certificate,
employees_educational_qualifications.major,
banks_names.id,
employees_payroll_info.payroll_id,
employees_payroll_info.account_id,
employees_salaries.salary,
employees_info.birth_date,
employees_info.join_date,
employees_info.name,
employees_info.gender,
departments_type.department,
teams_type.team,
positions_type.position,
employees_personal_emails.email,
employees_business_phones.phone,
employees_personal_phones.phone,
educational_degrees.educational_degree,
educational_majors.educational_major,
employees_initials.employee_initial,
banks_names.bank_name
from erp_system.dbo.employees_info
inner join erp_system.dbo.departments_type
on employees_info.employee_department = departments_type.id
inner join erp_system.dbo.teams_type
on employees_info.employee_team = teams_type.id
inner join erp_system.dbo.positions_type
on employees_info.employee_position = positions_type.id
inner join erp_system.dbo.employees_business_emails
on employees_info.employee_id = employees_business_emails.id
left join erp_system.dbo.employees_personal_emails
on employees_info.employee_id = employees_personal_emails.id
left join erp_system.dbo.employees_business_phones
on employees_info.employee_id = employees_business_phones.id
left join erp_system.dbo.employees_personal_phones
on employees_info.employee_id = employees_personal_phones.id
left join erp_system.dbo.employees_initials
on employees_info.employee_id = employees_initials.id
left join erp_system.dbo.employees_educational_qualifications
on employees_info.employee_id = employees_educational_qualifications.employee_id
left join erp_system.dbo.educational_degrees
on employees_educational_qualifications.certificate = educational_degrees.id
left join erp_system.dbo.educational_majors
on employees_educational_qualifications.major = educational_majors.id
left join erp_system.dbo.employees_salaries
on employees_info.employee_id = employees_salaries.id
left join erp_system.dbo.employees_payroll_info
on employees_info.employee_id = employees_payroll_info.employee_id
left join erp_system.dbo.banks_names
on employees_payroll_info.bank_id = banks_names.id
where employees_business_emails.email = '" ;
String sqlQueryPart2 = "';";
sqlQuery = string.Empty;
sqlQuery += sqlQueryPart1;
sqlQuery += businessEmail;
sqlQuery += sqlQueryPart2;
BASIC_STRUCTS.SQL_COLUMN_COUNT_STRUCT queryColumns = new BASIC_STRUCTS.SQL_COLUMN_COUNT_STRUCT();
queryColumns.sql_int = 9;
queryColumns.sql_bigint = 1;
queryColumns.sql_money = 1;
queryColumns.sql_datetime = 2;
queryColumns.sql_string = 12;
if (!initializationObject.GetRows(sqlQuery, queryColumns, BASIC_MACROS.SEVERITY_HIGH))
{
return(false);
}
employeeId = initializationObject.rows[0].sql_int[0];
departmentId = initializationObject.rows[0].sql_int[1];
teamId = initializationObject.rows[0].sql_int[2];
positionId = initializationObject.rows[0].sql_int[3];
graduationYear = initializationObject.rows[0].sql_int[4];
educationalQualificationId = initializationObject.rows[0].sql_int[5];
majorId = initializationObject.rows[0].sql_int[6];
salary = initializationObject.rows[0].sql_money[0];
birthDateStruct = initializationObject.rows[0].sql_datetime[0];
joinDateStruct = initializationObject.rows[0].sql_datetime[1];
joinDate = joinDateStruct.ToString();
birthDate = birthDateStruct.ToString();
name = initializationObject.rows[0].sql_string[0];
gender = initializationObject.rows[0].sql_string[1];
department = initializationObject.rows[0].sql_string[2];
team = initializationObject.rows[0].sql_string[3];
position = initializationObject.rows[0].sql_string[4];
personalEmail = initializationObject.rows[0].sql_string[5];
businessPhone = initializationObject.rows[0].sql_string[6];
personalPhone = initializationObject.rows[0].sql_string[7];
educationalQualification = initializationObject.rows[0].sql_string[8];
major = initializationObject.rows[0].sql_string[9];
initials = initializationObject.rows[0].sql_string[10];
payrollInfo = new List <COMPANY_ORGANISATION_MACROS.BANK_STRUCT>();
for (int i = 0; i < initializationObject.rows.Count; i++)
{
COMPANY_ORGANISATION_MACROS.BANK_STRUCT tempItem = new COMPANY_ORGANISATION_MACROS.BANK_STRUCT();
tempItem.bank_id = initializationObject.rows[i].sql_int[7];
tempItem.payroll_id = initializationObject.rows[i].sql_int[8];
tempItem.account_id = (ulong)initializationObject.rows[i].sql_bigint[0];
tempItem.bank_name = initializationObject.rows[i].sql_string[11];
payrollInfo.Add(tempItem);
}
return(true);
}