protected static FR_DO_GPDD_1700 Execute(DbConnection Connection, DbTransaction Transaction, P_DO_GPDD_1700 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_DO_GPDD_1700(); returnValue.Result = new DO_GPDD_1700(); var practice_details = new DO_GPDD_1700(); var data = cls_Get_Practice_Details_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPDfPID_1432 { PracticeID = Parameter.ID }, securityTicket).Result; foreach (var practice in data) { if (practice.is_company) { practice_details.address = practice.street; practice_details.bank = practice.practice_bank_name; practice_details.bic = practice.practice_bank_BIC; practice_details.bsnr = practice.practice_BSNR; practice_details.No = practice.number; practice_details.email = practice.contact_email; practice_details.fax = practice.contact_fax; practice_details.iban = practice.practice_IBAN; practice_details.id = practice.practiceID.ToString(); practice_details.phone = practice.contact_telephone; practice_details.name = practice.practice_name; practice_details.town = practice.city; practice_details.Zip = practice.zip; practice_details.account_holder = practice.account_holder; practice_details.password = "******"; if (practice.IsValue_Number) { if (practice.PropertyName.Equals("Default Shipping Date Offset")) { practice_details.default_shipping_date_offset = practice.Value_Number; } } if (practice.IsValue_Boolean) { if (practice.PropertyName.Equals("Waive Service Fee")) { practice_details.isWaiveServiceFee = practice.Value_Boolean; } if (practice.PropertyName.Equals("Order Drugs")) { practice_details.IsOrderDrugs = practice.Value_Boolean; } if (practice.PropertyName.Equals("Surgery Practice")) { practice_details.IsSurgeryPractice = practice.Value_Boolean; } if (practice.PropertyName.Equals("Only Label Required")) { practice_details.IsOnlyLabelRequired = practice.Value_Boolean; } if (practice.PropertyName.Equals("Quick order")) { practice_details.IsQuickOrderActive = practice.Value_Boolean; } } } else { practice_details.contact_email = practice.contact_email; practice_details.contact_person_name = practice.contact_person_name; practice_details.contact_telephone = practice.contact_telephone; } var accountID = cls_Get_Practice_AccountID_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPAIDfPID_1351() { PracticeID = Parameter.ID }, securityTicket).Result.accountID; practice_details.login_email = data.First().sign_in_email; } var shouldDownloadReportProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Download Report Upon Submission" }, securityTicket).Result; if (shouldDownloadReportProperty != null) { practice_details.ShouldDownloadReportUponSubmission = shouldDownloadReportProperty.BooleanValue; } var pressEnterToSearchProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Press enter to search" }, securityTicket).Result; if (pressEnterToSearchProperty != null) { practice_details.PressEnterToSearch = pressEnterToSearchProperty.BooleanValue; } var practiceHasOctDeviceProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Practice has OCT device" }, securityTicket).Result; if (practiceHasOctDeviceProperty != null) { practice_details.PracticeHasOctDevice = practiceHasOctDeviceProperty.BooleanValue; } var defaultPharmacyProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Default pharmacy" }, securityTicket).Result; if (defaultPharmacyProperty != null) { practice_details.DefaultPharmacy = String.IsNullOrEmpty(defaultPharmacyProperty.TextValue) ? Guid.Empty.ToString() : defaultPharmacyProperty.TextValue; } else { practice_details.DefaultPharmacy = null; } var quickOrderProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Quick order" }, securityTicket).Result; if (quickOrderProperty != null) { practice_details.IsQuickOrderActive = quickOrderProperty.BooleanValue; } var deliveryDateFromProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Delivery date from" }, securityTicket).Result; if (quickOrderProperty != null) { practice_details.DeliveryDateFrom = deliveryDateFromProperty.TextValue; } else { practice_details.DeliveryDateFrom = "08:00"; } var deliveryDateToProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Delivery date to" }, securityTicket).Result; if (quickOrderProperty != null) { practice_details.DeliveryDateTo = deliveryDateToProperty.TextValue; } else { practice_details.DeliveryDateTo = "18:00"; } var gracePeriodProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916() { PracticeID = Parameter.ID, PropertyName = "Grace period" }, securityTicket).Result; if (gracePeriodProperty != null) { practice_details.UseGracePeriod = gracePeriodProperty.BooleanValue; } returnValue.Result = practice_details; return(returnValue); #endregion UserCode }
///<summary> /// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured ///<summary> public static FR_DO_GPDD_1700 Invoke(DbConnection Connection, DbTransaction Transaction, P_DO_GPDD_1700 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_DO_GPDD_1700 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_DO_GPDD_1700 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_DO_GPDD_1700 functionReturn = new FR_DO_GPDD_1700(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw new Exception("Exception occured in method cls_Get_Practice_DetailData", ex); } return(functionReturn); }
///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_DO_GPDD_1700 Invoke(string ConnectionString, P_DO_GPDD_1700 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }