public static bool IsUserOfType(string aspUserName, bool isTypeClient = false, bool isTypeEndUser = false)
{
try {
//get aspUserID
Guid aspUserID = (Guid)AppSettings.GetUserIDByUserName(aspUserName);
var curUser = ClientBLL.GetPersonByASPuserID(aspUserID);
byte curUserRole = 0;
// get curUser ROLE
if (curUser != null)
{
curUserRole = (byte)curUser.Rows[0].ItemArray[5];
}
//check parameters condition which applys
if (isTypeClient)
{
if (curUserRole == (byte)RolesEnum.CLIENT)
{
return(true);
}
}
if (isTypeEndUser)
{
if (curUserRole == (byte)RolesEnum.END_USER)
{
return(true);
}
}
//for now 18/7/16 --- anything else return false
return(false);
}
catch (Exception ex) {
ExceptionHandling.LogException(ref ex);
return(false);
}
}
}//end SaveInstallationToDB2
public static void SaveInstallationToDB(ref Installation i, string iSumXMLfileName)
{
try {
// System.Diagnostics.Debug.Print(i.ToString());
//save CLient contact Details
var _with1 = i.Company.mainClientContact.contactDetail;
int?contDetID = ContactDetailsBLL.AddContactDetails(_with1.email);
_with1.ID = contDetID;
//save CLient
var _with2 = i.Company.mainClientContact;
int?clientID = ClientBLL.AddClient(_with2.title, _with2.firstName, _with2.lastName, (int)contDetID, _with2.aspnetUserID);
_with2.ID = clientID;
//save Company address/phone numb
var _with3 = i.Company.businessAddress;
int?compContDetID = ContactDetailsBLL.AddContactDetails(null, null, null, null, _with3.landline, null, null);
_with3.ID = compContDetID;
//save Company
var _with4 = i.Company;
int?compID = CompanyBLL.AddCompany(_with4.domain, _with4.industry, _with4.natureOfBusiness, (int)clientID, (int)compContDetID);
_with4.ID = compID;
//save Employees
int? tempStaffContDetID, tempStaffID;
short?tempStaffAgendaID;
foreach (EmployeeBLL staff in i.Employees)
{
//save staff contact details
tempStaffContDetID = ContactDetailsBLL.AddContactDetails(staff.contactDetail.email);
//save ID to Installation
staff.contactDetail.ID = tempStaffContDetID;
//save staff agenda
tempStaffAgendaID = AgendaBLL.AddAgenda(false, false);
staff.agenda.ID = tempStaffAgendaID;
//save employee
tempStaffID = EmployeeBLL.AddEmployee(staff.title, staff.firstName, staff.lastName, (int)tempStaffContDetID, staff.aspnetUserID, null, null, tempStaffAgendaID);
staff.ID = tempStaffID;
}
//save services
int?tempServID;
foreach (ServicesBLL service in i.Services)
{
//save service
tempServID = ServicesBLL.AddService(service.name, service.isCertifReq, service.isInsuranceReq, service.description, service.duration, service.durationUnit, service.price);
service.ID = tempServID;
}
//save Provide
//FINK!! FINK18/7//16
//return i //?? Installation if IDs not added byRef
//------- create and save summary installation xml file ------------
XmlDocument iXmlDoc = AppSettings.GetInstallationSummaryXML(i, iSumXMLfileName);
iXmlDoc.Save(iSumXMLfileName);
//save intall XML SUMMARY TO DB AND SESSION
int?NumbXmlAdded = CompanyBLL.AddCompanyInstallationSummaryXMLByID((short)i.Company.ID, iXmlDoc);
i.Company.iSummaryXML = iXmlDoc;
}
catch (Exception ex) {
ExceptionHandling.LogException(ref ex);
}
}
/// <summary>
/// MUST review 11/7/16
/// </summary>
/// <param name="i"></param>
/// <param name="company"></param>
public static Installation PopulateInstalationObjFromDB(ref Installation i, int?companyID, string iSumXMLfileName)
{
try {
if (i == null)
{
i = new Installation();
//timestamp
i.Timestamp = Utils.GetDatetimeNOW();
}
//------ company ---------
//get company dataTable
var company = CompanyBLL.GetCompanyByID(companyID); //.GetAllCompanies();??
if (company.Count > 0) //==1
//get ----summary installation xml-----
{
XmlDocument iXmlDoc = CompanyBLL.GetInstallSummanyXMLDoc(companyID, iSumXMLfileName);
//get ----company contact Details ----- dataTable
int coContactDetID = company.Rows[0].Field <int>(8);
var coContactDet = ContactDetailsBLL.GetContactDetailByID(coContactDetID);
//populate an instance of contactDetBLL
var _with11 = coContactDet.Rows[0];
ContactDetailsBLL coContactBLL = new ContactDetailsBLL(_with11.Field <string>(1), _with11.Field <string>(3), _with11.Field <string>(2), _with11.Field <string>(4), _with11.Field <string>(5), _with11.Field <string>(6), _with11.Field <string>(7));
coContactBLL.ID = _with11.Field <int>(0);
//polulate an instance of companyBLL
var _with1 = company.Rows[0];
CompanyBLL coBLL = new CompanyBLL(_with1.Field <string>(1), _with1.Field <string>(2), _with1.Field <int?>(3), _with1.Field <string>(4), _with1.Field <DateTime?>(5), _with1.Field <string>(6), _with1.Field <bool?>(9), _with1.Field <string>(10));
coBLL.ID = _with1.Field <int>(0);//same as companyID
//add contact details to coBLL
coBLL.businessAddress = coContactBLL;
//------- SAVE INSTALLATION XML SUMMARY TO SESSION ------------
i.Company.iSummaryXML = iXmlDoc;
//foreign keys
int clientID = _with1.Field <int>(7);
//------ Client ---------
//get client dataTable
var client = ClientBLL.GetClientByID(clientID);//GetAllClients();
//get ---- client contact ------dataTable
int cltContactDetID = client.Rows[0].Field <int>(4);
var cltContactDet = ContactDetailsBLL.GetContactDetailByID(cltContactDetID);
//populate an instance of contactDetBLL
var _with21 = cltContactDet.Rows[0];
ContactDetailsBLL clientContactBLL = new ContactDetailsBLL(_with21.Field <string>(1), _with21.Field <string>(3), _with21.Field <string>(2), _with21.Field <string>(4), _with21.Field <string>(5), _with21.Field <string>(6), _with21.Field <string>(7));
clientContactBLL.ID = _with21.Field <int>(0);
//Populate clientBLL
var _with2 = client.Rows[0];
ClientBLL clientBLL = new ClientBLL(_with2.Field <string>(1), _with2.Field <string>(2), _with2.Field <string>(3), clientContactBLL, _with2.Field <Guid>(9));
clientBLL.ID = _with2.Field <int>(0);
//add client to company
coBLL.mainClientContact = clientBLL;
//add to installation
i.Company = coBLL;
//----------------------------------------------end of company---------------------------------------------------------------------
//------------ Employees --------------
List <int> thisCoEmployees = AppSettings.GetIDsList(iSumXmlDoc: iXmlDoc, perform: AppSettings.iEmpID);
//loop through all employees registered to this company
foreach (int staffID in thisCoEmployees)
{
//get employee dataTable
var employees = EmployeeBLL.GetEmployeeByID(staffID);
// Loop through all employees
foreach (DataRow employee in employees.Rows)
{
//get ---- employee agenda ------dataTable
short staffAgendaID = employee.Field <short>(8);
var staffAgenda = AgendaBLL.GetAgendaByID(staffAgendaID);
//populate an instance of agendaBLL
var _with41 = staffAgenda.Rows[0];
//System.Diagnostics.Debug.Print("staffAgendaID from employee Table is: " + staffAgendaID.ToString() + "staffAgendaID from AGENDA Table is: " + _with41.Field<short>(0).ToString());
AgendaBLL staffAgendaBLL = new AgendaBLL(staffAgendaID, _with41.Field <bool?>(1), _with41.Field <bool?>(2));
staffAgendaBLL.ID = _with41.Field <short>(0);
//get ---- employee contact ------dataTable
int staffContDetID = employee.Field <int>(4);
var staffContDet = ContactDetailsBLL.GetContactDetailByID(staffContDetID);
//populate an instance of contactDetBLL
var _with31 = cltContactDet.Rows[0];
ContactDetailsBLL staffContactBLL = new ContactDetailsBLL(_with31.Field <string>(1), _with31.Field <string>(3), _with31.Field <string>(2), _with31.Field <string>(4), _with31.Field <string>(5), _with31.Field <string>(6), _with31.Field <string>(7));
staffContactBLL.ID = _with31.Field <int>(0);
//Populate staffBLL
var _with3 = employee;
EmployeeBLL staffBLL = new EmployeeBLL(_with3.Field <string>(1), _with3.Field <string>(2), _with3.Field <string>(3), staffContactBLL, _with3.Field <string>(6), _with3.Field <string>(7), staffAgendaBLL, _with3.Field <Guid>(9));
staffBLL.ID = _with3.Field <int>(0);
//add contact detail & agenda to staff
// staffBLL.contactDetail = staffContactBLL;//already added on constructor
staffBLL.agenda = staffAgendaBLL;
//get ---- DailyShedules foreach agenda ------dataTable
var curStaffCalendar = staffBLL.agenda.staffCalendar;
List <int> bookingTimes = new List <int>();
//get data stored on db
var staffAgendaDailyShedules = DailySchedule.GetDailySchedulesByAgendaID(staffAgendaID);
// Loop through each dailySchedule on staff's agenda
foreach (DataRow dailySchedule in staffAgendaDailyShedules.Rows)
{
//create a new DayScheduleBLL
DaySchedule daySchedBLL = new DaySchedule();
DateTime date = dailySchedule.Field <DateTime>(2);
XDocument xDoc = XDocument.Parse(dailySchedule.Field <System.String>(3));
//loopthrough db xml and get a list of "busy times"
bookingTimes = DayScheduleXML.GetTimesFromDayScheduleXML(xDoc);
//add appts to daySchedBLL
foreach (int time in bookingTimes)
{
//add appts to daySchedBLL
bool added = AgendaBLL.AddBooking(ref curStaffCalendar, date, time);
System.Diagnostics.Debug.Print("ADDED?\t " + added.ToString());
} //
} //end loop daySchedule
//add employee to installation
i.Employees.Add(staffBLL);
} //// endLoop emploee dataTable
} // endLoop through all employees
//----------------------------------------------end of employees---------------------------------------------------------------------
//------------ services --------------
List <int> thisCoServices = AppSettings.GetIDsList(iSumXmlDoc: iXmlDoc, perform: AppSettings.iServID);
//loop through all employees registered to this company
foreach (int serviceID in thisCoServices)
{
//get services dataTable
var services = ServicesBLL.GetServiceByID(serviceID);
// Loop through all services
foreach (DataRow service in services.Rows)
{
//Populate serviceBLL
var _with4 = service;
ServicesBLL serviceBLL = new ServicesBLL(_with4.Field <string>(1), _with4.Field <bool?>(2), _with4.Field <bool?>(3), _with4.Field <string>(4), _with4.Field <byte?>(5), _with4.Field <string>(6), _with4.Field <decimal?>(8));
serviceBLL.ID = _with4.Field <int>(0);
//add service to installation
i.Services.Add(serviceBLL);
}
}
//----------------------------------------------end of services---------------------------------------------------------------------
//------------ End-Users --------------
List <int> thisCoEndUsers = AppSettings.GetIDsList(iSumXmlDoc: iXmlDoc, perform: AppSettings.iuserID);
//loop through all employees registered to this company
foreach (int endUserID in thisCoEndUsers)
{
//get staff dataTable
var endUsers = EndUserBLL.GetEndUserByID(endUserID);
// Loop through all endUsers
foreach (DataRow endUser in endUsers.Rows)
{
//get ---- endUser contact ------dataTable
int endUserContDetID = endUser.Field <int>(4);
var endUserContDet = ContactDetailsBLL.GetContactDetailByID(endUserContDetID);
//populate an instance of contactDetBLL
var _with51 = cltContactDet.Rows[0];
ContactDetailsBLL endUserContactBLL = new ContactDetailsBLL(_with51.Field <string>(1), _with51.Field <string>(3), _with51.Field <string>(2), _with51.Field <string>(4), _with51.Field <string>(5), _with51.Field <string>(6), _with51.Field <string>(7));
endUserContactBLL.ID = _with51.Field <int>(0);
//Populate endUserBLL
var _with5 = endUser;
EndUserBLL endUserBLL = new EndUserBLL(_with5.Field <string>(1), _with5.Field <string>(2), _with5.Field <string>(3), endUserContactBLL, _with5.Field <Guid>(9));
endUserBLL.ID = _with5.Field <int>(0);
//add service to installation
i.EndUsers.Add(endUserBLL);
}
}
//----------------------------------------------end of End-Users---------------------------------------------------------------------
//------------ Appointments --------------
List <int> thisCoAppts = AppSettings.GetIDsList(iSumXmlDoc: iXmlDoc, perform: AppSettings.iApptID);
//loop through all employees registered to this company
foreach (int apptID in thisCoAppts)
{
//get appts dataTable
var appts = ApptBLL.GetAppointmentByID(apptID);
// Loop through all appts
foreach (DataRow appt in appts.Rows)
{
//Populate apptBLL
var _with6 = appt;
ApptBLL apptBLL = new ApptBLL(_with6.Field <DateTime>(1), _with6.Field <TimeSpan>(2), _with6.Field <int>(3), _with6.Field <int>(4), _with6.Field <string>(5), _with6.Field <string>(6));
apptBLL.ID = _with6.Field <int>(0);
//add appt to installation
i.Appointments.Add(apptBLL);
}
}
//----------------------------------------------end of Appointments---------------------------------------------------------------------
}
return(i);
}
catch (Exception ex) {
ExceptionHandling.LogException(ref ex);
return(null);
}
}