public static void GetDevisPrestataire(Devis d)
{
String sql = "SELECT devisid, prestataireid, dp.prix, nom FROM DevisPrestataire dp inner join Prestataire p on dp.prestataireid = p.id WHERE devisId=@devisId ";
using (MySqlCommand command = new MySqlCommand(sql, connection))
{
command.Connection.Open();
command.Parameters.AddWithValue("@devisid", d.Id);
using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader())
{
while (dbReader.Read())
{
int devisid = dbReader.GetInt32(0);
int prestataireid = dbReader.GetInt32(1);
int prix = dbReader.GetInt32(2);
string nom = dbReader.GetString(3);
DevisPrestataire dp = new DevisPrestataire(devisid, prestataireid, prix)
{
Nom = nom
};
d.DevisPrestataires.Add(dp);
}
}
command.Connection.Close();
}
}
private static BasicPerson ReadPersonFromDataReader (DbDataReader reader)
{
int personId = reader.GetInt32(0);
string passwordHash = reader.GetString(1);
string name = reader.GetString(2);
string email = reader.GetString(3);
string street = reader.GetString(4);
string postalCode = reader.GetString(5);
string cityName = reader.GetString(6);
int countryId = reader.GetInt32(7);
string phone = reader.GetString(8);
int geographyId = reader.GetInt32(9);
DateTime birthdate = reader.GetDateTime(10);
int genderId = reader.GetInt32(11);
// Fix broken names, emails
email = email.ToLower().Trim();
name = name.Trim();
while (name.Contains(" "))
{
name = name.Replace(" ", " ");
}
return new BasicPerson(personId, passwordHash, name, email, street, postalCode, cityName, countryId, phone,
geographyId, birthdate, (PersonGender)genderId);
}
private static BasicGeography ReadGeographyFromDataReader (DbDataReader reader)
{
int geographyId = reader.GetInt32(0);
int parentGeographyId = reader.GetInt32(1);
string name = reader.GetString(2);
return new BasicGeography(geographyId, parentGeographyId, name);
}
private static BasicCity ReadCityFromDataReader (DbDataReader reader)
{
int cityId = reader.GetInt32(0);
int countryId = reader.GetInt32(1);
string cityName = reader.GetString(2);
int geographyId = reader.GetInt32(3);
return new BasicCity(cityId, cityName, countryId, geographyId);
}
private BasicOutboundInvoiceItem ReadOutboundInvoiceItemFromDataReader (DbDataReader reader)
{
int outboundInvoiceItemId = reader.GetInt32(0);
int outboundInvoiceId = reader.GetInt32(1);
string description = reader.GetString(2);
Int64 amountCents = reader.GetInt64(3);
return new BasicOutboundInvoiceItem(outboundInvoiceItemId, outboundInvoiceId, description, amountCents);
}
private static BasicGeographyDesignation ReadGeographyDesignationFromDataReader (DbDataReader reader)
{
int geographyId = reader.GetInt32(0);
int countryId = reader.GetInt32(1);
string designation = reader.GetString(2);
GeographyLevel level = (GeographyLevel) reader.GetInt32(3);
return new BasicGeographyDesignation(geographyId, countryId, designation, level);
}
private BasicPostalCode ReadPostalCodeFromDataReader(DbDataReader reader)
{
int postalCodeId = reader.GetInt32(0);
string postalCode = reader.GetString(1);
int cityId = reader.GetInt32(2);
int countryId = reader.GetInt32(3);
return new BasicPostalCode(postalCodeId, postalCode, cityId, countryId);
}
private static BasicCountry ReadCountryFromDataReader(DbDataReader reader)
{
int countryId = reader.GetInt32(0);
string name = reader.GetString(1);
string code = reader.GetString(2).ToUpperInvariant();
string culture = reader.GetString(3);
int geographyId = reader.GetInt32(4);
return new BasicCountry(countryId, name, code, culture, geographyId);
}
private BasicOutboundMailRecipient ReadOutboundMailRecipientFromDataReader(DbDataReader reader)
{
int outboundMailRecipientId = reader.GetInt32(0);
int outboundMailId = reader.GetInt32(1);
int personId = reader.GetInt32(2);
bool asOfficer = reader.GetBoolean(3);
int personType = reader.GetInt32(4);
return new BasicOutboundMailRecipient(outboundMailRecipientId, outboundMailId, personId, asOfficer, personType);
}
static private BasicChurnDataPoint ReadChurnDataPointFromDataReader (DbDataReader reader)
{
int personId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
bool churn = reader.GetBoolean(2);
DateTime decisionDateTime = reader.GetDateTime(3);
DateTime expiryDateTime = reader.GetDateTime(4);
return new BasicChurnDataPoint(churn ? ChurnDataType.Churn : ChurnDataType.Retention, decisionDateTime,
expiryDateTime, personId, organizationId);
}
static private BasicPersonRole ReadPersonRoleFromDataReader (DbDataReader reader)
{
int personRoleId = reader.GetInt32(0);
string personRoleTypeName = reader.GetString(1);
int personId = reader.GetInt32(2);
int organizationId = reader.GetInt32(3);
int geographyId = reader.GetInt32(4);
RoleType roleType = (RoleType) Enum.Parse(typeof (RoleType), personRoleTypeName);
return new BasicPersonRole(personRoleId, personId, roleType, organizationId, geographyId);
}
private static BasicAutoMail ReadAutoMailFromDataReader (DbDataReader reader)
{
int autoMailId = reader.GetInt32(0);
AutoMailType type = (AutoMailType) Enum.Parse(typeof (AutoMailType), reader.GetString(1));
int geographyId = reader.GetInt32(3);
int organizationId = reader.GetInt32(2);
int authorPersonId = reader.GetInt32(4); // appear to be unused?
string title = reader.GetString(5);
string body = reader.GetString(6);
return new BasicAutoMail(autoMailId, type, organizationId, geographyId, authorPersonId,
title, body);
}
private BasicPayrollAdjustment ReadPayrollAdjustmentFromDataReader(DbDataReader reader)
{
int payrollAdjustmentId = reader.GetInt32(0);
int payrollAdjustmentTypeId = reader.GetInt32(1);
int payrollItemId = reader.GetInt32(2);
Int64 amountCents = reader.GetInt64(3);
string description = reader.GetString(4);
bool open = reader.GetBoolean(5);
int salaryId = reader.GetInt32(6);
return new BasicPayrollAdjustment(payrollAdjustmentId, payrollItemId,
(PayrollAdjustmentType) payrollAdjustmentTypeId,
amountCents, description, open, salaryId);
}
public static void GetPrestataire()
{
String sql = "SELECT * FROM Prestataire";
using (MySqlCommand command = new MySqlCommand(sql, connection))
{
try
{
command.Connection.Open();
}
catch (MySqlException) { }
using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader())
{
while (dbReader.Read())
{
int Id = dbReader.GetInt32(0);
String Nom = dbReader.GetString(1);
String Url = dbReader.GetString(2);
String Categorie = dbReader.GetString(3);
String Contact = dbReader.GetString(4);
String Adresse = dbReader.GetString(5);
String Description = dbReader.GetString(6);
Boolean Activation = dbReader.GetBoolean(7);
String Prix = dbReader.GetString(8);
// attente de la création de la class business
Business.Prestataires.Add(new Prestataire(Id, Nom, Url, Categorie, Contact, Adresse, Description, Activation, Prix));
}
}
command.Connection.Close();
}
}
private static BasicOrganization ReadOrganizationFromDataReader (DbDataReader reader)
{
int organizationId = reader.GetInt32(0);
int parentOrganizationId = reader.GetInt32(1);
string name = reader.GetString(2);
string nameInternational = reader.GetString(3);
string nameShort = reader.GetString(4);
string domain = reader.GetString(5);
string mailPrefix = reader.GetString(6);
int anchorGeographyId = reader.GetInt32(7);
bool acceptsMembers = reader.GetBoolean(8);
bool autoAssignNewMembers = reader.GetBoolean(9);
int defaultCountryId = reader.GetInt32(10);
return new BasicOrganization(organizationId, parentOrganizationId, name, nameInternational, nameShort,
domain, mailPrefix, anchorGeographyId, acceptsMembers, autoAssignNewMembers,
defaultCountryId);
}
private BasicExternalCredential ReadExternalCredentialFromDataReader (DbDataReader reader)
{
int externalCredentialId = reader.GetInt32(0);
string serviceName = reader.GetString(1);
string login = reader.GetString(2);
string password = reader.GetString(3);
return new BasicExternalCredential(externalCredentialId, serviceName, login, password);
}
private static BasicExceptionLog ExceptionLogFromDataReader (DbDataReader reader)
{
int ExceptionId = reader.GetInt32(0);
DateTime ExceptionDateTime = reader.GetDateTime(1);
string Source = reader.GetString(2);
string ExceptionText = reader.GetString(3);
return new BasicExceptionLog(ExceptionId, ExceptionDateTime, Source, ExceptionText);
}
private Dictionary<int, Medicine> Read(DbDataReader reader, IDatabase db)
{
Dictionary<int, Medicine> medicines = new Dictionary<int, Medicine>();
while (reader.Read())
{
Medicine m = new Medicine();
m.Id = reader.GetInt32(0);
m.Name = reader.GetString(1);
m.Description = reader.GetString(2);
m.PackageSize = reader.GetInt32(3);
m.Price = Decimal.ToSingle(reader.GetDecimal(4));
m.Allergens = this.ReadAllergens(m, db);
medicines.Add(m.Id, m);
}
return medicines;
}
private BasicOutboundInvoice ReadOutboundInvoiceFromDataReader(DbDataReader reader)
{
int outboundInvoiceId = reader.GetInt32(0);
string customerName = reader.GetString(1);
string invoiceAddressPaper = reader.GetString(2);
string invoiceAddressMail = reader.GetString(3);
int currencyId = reader.GetInt32(4);
// double amount = reader.GetDouble(5);
int organizationId = reader.GetInt32(6);
int budgetId = reader.GetInt32(7);
DateTime createdDateTime = reader.GetDateTime(8);
int createdByPersonId = reader.GetInt32(9);
DateTime dueDate = reader.GetDateTime(10);
int reminderCount = reader.GetInt32(11);
string reference = reader.GetString(12);
bool domestic = reader.GetBoolean(13);
bool open = reader.GetBoolean(14);
bool sent = reader.GetBoolean(15);
string securityCode = reader.GetString(16);
string theirReference = reader.GetString(17);
return new BasicOutboundInvoice(outboundInvoiceId, customerName, invoiceAddressPaper, invoiceAddressMail,
currencyId, organizationId, budgetId, createdDateTime,
createdByPersonId, dueDate, reminderCount, reference, domestic, open, sent, securityCode, theirReference);
}
private BasicInboundInvoice ReadInboundInvoiceFromDataReader(DbDataReader reader)
{
int inboundInvoiceId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
DateTime createdDateTime = reader.GetDateTime(2);
int createdByPersonId = reader.GetInt32(3);
DateTime dueDate = reader.GetDateTime(4);
Int64 amountCents = reader.GetInt64(5);
int budgetId = reader.GetInt32(6);
bool attested = reader.GetBoolean(7);
bool open = reader.GetBoolean(8);
string supplier = reader.GetString(9);
string payToAccount = reader.GetString(10);
string ocr = reader.GetString(11);
string invoiceReference = reader.GetString(12);
DateTime closedDateTime = reader.GetDateTime(13);
int closedByPersonId = reader.GetInt32(14);
return new BasicInboundInvoice(inboundInvoiceId, organizationId, createdDateTime, dueDate,
amountCents, budgetId, supplier, payToAccount, ocr, invoiceReference,
attested, open, closedDateTime, closedByPersonId);
}
static int GetInt32(IntPtr L)
{
try
{
ToLua.CheckArgsCount(L, 2);
System.Data.Common.DbDataReader obj = (System.Data.Common.DbDataReader)ToLua.CheckObject(L, 1, typeof(System.Data.Common.DbDataReader));
int arg0 = (int)LuaDLL.luaL_checknumber(L, 2);
int o = obj.GetInt32(arg0);
LuaDLL.lua_pushinteger(L, o);
return(1);
}
catch (Exception e)
{
return(LuaDLL.toluaL_exception(L, e));
}
}
protected Conversation GetCurrentConversation(DbDataReader reader)
{
int colID = reader.GetOrdinal("grupoid_grupo");
int colName = reader.GetOrdinal("nombre");
Conversation conversation = new Conversation();
if (!reader.IsDBNull(colID))
{
conversation.ID = reader.GetInt32(colID);
}
if (!reader.IsDBNull(colName))
{
conversation.Name = reader.GetString(colName);
}
return conversation;
}
private BasicPayrollItem ReadPayrollItemFromDataReader(DbDataReader reader)
{
int payrollItemId = reader.GetInt32(0);
int personId = reader.GetInt32(1);
int organizationId = reader.GetInt32(2);
int countryId = reader.GetInt32(3);
DateTime employedDate = reader.GetDateTime(4);
int reportsToPersonId = reader.GetInt32(5);
Int64 baseSalaryCents = reader.GetInt64(6);
int budgetId = reader.GetInt32(7);
bool open = reader.GetBoolean(8);
DateTime terminatedDate = reader.GetDateTime(9);
int subtractiveTaxLevelId = reader.GetInt32(10);
double additiveTaxLevel = reader.GetDouble(11);
return new BasicPayrollItem(payrollItemId, personId, organizationId, countryId, employedDate,
reportsToPersonId, baseSalaryCents, budgetId, open, terminatedDate, subtractiveTaxLevelId, additiveTaxLevel);
}
private void mapValues(DbDataReader reader, object record)
{
foreach (var accessor in this.accessors) {
var index = reader.GetOrdinal(accessor.Name);
if (reader.IsDBNull(index)) {
continue;
}
if (accessor.PropertyType == typeof(string)) {
accessor.Set(record, reader.GetString(index));
} else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) {
accessor.Set(record, reader.GetInt32(index));
} else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) {
accessor.Set(record, reader.GetInt64(index));
} else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) {
accessor.Set(record, reader.GetDateTime(index));
} else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) {
accessor.Set(record, reader.GetChar(index));
}
}
}
private BasicPWEvent ReadPWEventFromDataReader (DbDataReader reader)
{
int eventId = reader.GetInt32(0);
EventType eventType = (EventType)Enum.Parse(typeof(EventType), reader.GetString(1));
EventSource eventSource = (EventSource)Enum.Parse(typeof(EventSource), reader.GetString(2));
int actingPersonId = reader.GetInt32(3);
int affectedPersonId = reader.GetInt32(4);
DateTime eventDateTime = reader.GetDateTime(5);
DateTime processedDateTime = reader.GetDateTime(6);
bool open = reader.GetBoolean(7);
int organizationId = reader.GetInt32(8);
int geographyId = reader.GetInt32(9);
int parameterInt = reader.GetInt32(10);
string parameterText = reader.GetString(11);
return new BasicPWEvent(eventId, eventDateTime, open, processedDateTime, eventType, eventSource, actingPersonId,
affectedPersonId, organizationId, geographyId, parameterInt, parameterText);
}
private BasicInternalPoll ReadInternalPollFromDataReader(DbDataReader reader)
{
int internalPollId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
int geographyId = reader.GetInt32(2);
string name = reader.GetString(3);
bool runningOpen = reader.GetBoolean(4);
bool votingOpen = reader.GetBoolean(5);
int maxVoteLength = reader.GetInt32(6);
int createdByPersonId = reader.GetInt32(7);
DateTime runningOpens = reader.GetDateTime(8);
DateTime runningCloses = reader.GetDateTime(9);
DateTime votingOpens = reader.GetDateTime(10);
DateTime votingCloses = reader.GetDateTime(11);
int resultsTypeId = reader.GetInt32(12);
InternalPollResultsType resultsType = (InternalPollResultsType) resultsTypeId;
return new BasicInternalPoll(internalPollId, createdByPersonId, organizationId, geographyId, name, runningOpen, votingOpen, maxVoteLength, runningOpens, runningCloses, votingOpens, votingCloses, resultsType);
}
ProfileInfoCollection BuildProfileInfoCollection (DbDataReader reader, out int totalRecords)
{
ProfileInfoCollection pic = new ProfileInfoCollection ();
while (reader.Read ()) {
ProfileInfo pi = ReadProfileInfo (reader);
if (pi != null)
pic.Add (pi);
}
totalRecords = 0;
if (reader.NextResult ()) {
if (reader.Read ())
totalRecords = reader.GetInt32 (0);
}
return pic;
}
ProfileInfo ReadProfileInfo (DbDataReader reader)
{
ProfileInfo pi = null;
try {
string username = reader.GetString (0);
bool anonymous = reader.GetBoolean (1);
DateTime lastUpdate = reader.GetDateTime (2);
DateTime lastActivity = reader.GetDateTime (3);
int size = reader.GetInt32 (4);
pi = new ProfileInfo (username, anonymous, lastActivity, lastUpdate, size);
}
catch {
}
return pi;
}
// Copy multiple fields from reader to SmiTypedGetterSetter
// Supports V200 code path, without damaging backward compat for V100 code.
// Main differences are supporting DbDataReader, and for binary, character, decimal and Udt types.
// Assumes caller enforces that reader and setter metadata are compatible
internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) {
for (int i = 0; i < metaData.Count; i++) {
if (reader.IsDBNull(i)) {
ValueUtilsSmi.SetDBNull_Unchecked(sink, setters, i);
}
else {
switch (metaData[i].SqlDbType) {
case SqlDbType.BigInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int64));
SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i));
break;
case SqlDbType.Binary:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Bit:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Boolean));
SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i));
break;
case SqlDbType.Char:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.DateTime:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.Decimal: { // block to scope sqlReader local to avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlDecimal));
// Support full fidelity for SqlDataReader
SqlDataReader sqlReader = reader as SqlDataReader;
if (null != sqlReader) {
SetSqlDecimal_Unchecked(sink, setters, i, sqlReader.GetSqlDecimal(i));
}
else {
SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i)));
}
}
break;
case SqlDbType.Float:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Double));
SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i));
break;
case SqlDbType.Image:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Int:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int32));
SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i));
break;
case SqlDbType.Money:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney));
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
break;
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Real:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Single));
SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i));
break;
case SqlDbType.UniqueIdentifier:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Guid));
SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i));
break;
case SqlDbType.SmallDateTime:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i,metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.SmallInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int16));
SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i));
break;
case SqlDbType.SmallMoney:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney));
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
break;
case SqlDbType.Text:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Timestamp:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.TinyInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Byte));
SetByte_Unchecked(sink, setters, i, reader.GetByte(i));
break;
case SqlDbType.VarBinary:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.VarChar:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.String));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Xml: {
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlXml));
SqlDataReader sqlReader = reader as SqlDataReader;
if (null != sqlReader) {
SetSqlXml_Unchecked(sink, setters, i, sqlReader.GetSqlXml(i));
}
else {
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
}
}
break;
case SqlDbType.Variant: { // block to scope sqlReader local and avoid conflicts
// Support better options for SqlDataReader
SqlDataReader sqlReader = reader as SqlDataReader;
SqlBuffer.StorageType storageType = SqlBuffer.StorageType.Empty;
object o;
if (null != sqlReader) {
o = sqlReader.GetSqlValue(i);
storageType = sqlReader.GetVariantInternalStorageType(i);
}
else {
o = reader.GetValue(i);
}
ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, o, null,
//
SmiContextFactory.KatmaiVersion
);
if ((storageType == SqlBuffer.StorageType.DateTime2) || (storageType == SqlBuffer.StorageType.Date))
SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null, storageType);
else
SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null);
}
break;
case SqlDbType.Udt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
// Skip serialization for Udt types.
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
// SqlDbType.Structured should have been caught before this point for TVPs. SUDTs will still need to implement.
case SqlDbType.Date:
case SqlDbType.DateTime2:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.Time: { // block to scope sqlReader local and avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.TimeSpan));
SqlDataReader sqlReader = reader as SqlDataReader;
TimeSpan ts;
if (null != sqlReader) {
ts = sqlReader.GetTimeSpan(i);
} else {
ts = (TimeSpan)reader.GetValue(i);
}
SetTimeSpan_Checked(sink, setters, i, metaData[i], ts);
}
break;
case SqlDbType.DateTimeOffset: { // block to scope sqlReader local and avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTimeOffset));
SqlDataReader sqlReader = reader as SqlDataReader;
DateTimeOffset dto;
if (null != sqlReader) {
dto = sqlReader.GetDateTimeOffset(i);
} else {
dto = (DateTimeOffset)reader.GetValue(i);
}
SetDateTimeOffset_Unchecked(sink, setters, i, dto);
}
break;
default:
// In order for us to get here we would have to have an
// invalid instance of SqlDbType, or one would have to add
// new member to SqlDbType without adding a case in this
// switch, hence the assert - it must be
Debug.Assert(false, "unsupported DbType:" + metaData[i].SqlDbType.ToString());
throw ADP.NotSupported();
}
}
}
}
public IEnumerable <Bunk> QueryBunkListView(DataTransferObject.Foundation.BunkQueryCondition condition, Core.Pagination pagination)
{
var result = new List <Bunk>();
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
if (!string.IsNullOrWhiteSpace(condition.Airline))
{
dbOperator.AddParameter("@iAirline", condition.Airline.Trim());
}
if (!string.IsNullOrWhiteSpace(condition.Departure))
{
dbOperator.AddParameter("@iDeparture", condition.Departure.Trim());
}
if (!string.IsNullOrWhiteSpace(condition.Arrival))
{
dbOperator.AddParameter("@iArrival", condition.Arrival.Trim());
}
if (!string.IsNullOrWhiteSpace(condition.BunkCode))
{
dbOperator.AddParameter("@iBunkCode", condition.BunkCode.Trim());
}
if (condition.BunkType.HasValue)
{
dbOperator.AddParameter("@iBunkType", (int)condition.BunkType);
}
if (condition.VoyageType.HasValue)
{
dbOperator.AddParameter("@iVoyageType", (byte)condition.VoyageType);
}
if (condition.FlightBeginDate.HasValue)
{
dbOperator.AddParameter("@iFlightBeginDate", condition.FlightBeginDate.Value.Date);
}
if (condition.FlightEndDate.HasValue)
{
dbOperator.AddParameter("@iFlightEndDate", condition.FlightEndDate.Value.Date);
}
if (condition.Status.HasValue)
{
dbOperator.AddParameter("@iStatus", condition.Status);
}
if (pagination != null)
{
dbOperator.AddParameter("@iPageSize", pagination.PageSize);
dbOperator.AddParameter("@iPageIndex", pagination.PageIndex);
}
System.Data.Common.DbParameter totalCount = dbOperator.AddParameter("@oTotalCount");
totalCount.DbType = System.Data.DbType.Int32;
totalCount.Direction = System.Data.ParameterDirection.Output;
using (System.Data.Common.DbDataReader reader = dbOperator.ExecuteReader("dbo.P_QueryBunks", System.Data.CommandType.StoredProcedure))
{
Guid?previousId = null;
Bunk bunk = null;
while (reader.Read())
{
var currentId = reader.GetGuid(1);
if (bunk == null || previousId.Value != currentId)
{
bunk = null;
}
var bunkType = (BunkType)reader.GetInt32(0);
switch (bunkType)
{
case BunkType.Economic:
bunk = loadEconomicBunk(bunk, reader);
break;
case BunkType.FirstOrBusiness:
bunk = loadFirstBusinessBunk(bunk, reader);
break;
case BunkType.Promotion:
bunk = loadPromotionBunk(bunk, reader);
break;
case BunkType.Production:
bunk = loadProductionBunk(bunk, reader);
break;
case BunkType.Transfer:
bunk = loadTransferBunk(bunk, reader);
break;
case BunkType.Free:
bunk = loadFreeBunk(bunk, reader);
break;
case BunkType.Team:
bunk = loadTeamBunk(bunk, reader);
break;
}
bunk.VoyageType = (VoyageTypeValue)reader.GetByte(19);
bunk.TravelType = (TravelTypeValue)reader.GetByte(20);
bunk.PassengerType = (PassengerTypeValue)reader.GetByte(21);
bunk.RefundRegulation = reader.IsDBNull(8) ? string.Empty : reader.GetString(8);
bunk.ChangeRegulation = reader.IsDBNull(16) ? string.Empty : reader.GetString(16);
bunk.EndorseRegulation = reader.IsDBNull(17) ? string.Empty : reader.GetString(17);
bunk.Remarks = reader.IsDBNull(18) ? string.Empty : reader.GetString(18);
if (!previousId.HasValue || previousId.Value != currentId)
{
result.Add(bunk);
previousId = currentId;
}
}
}
if (pagination.GetRowCount)
{
pagination.RowCount = (int)totalCount.Value;
}
}
return(result);
}
private List<Request> Read(DbDataReader reader)
{
List<Request> requests = new List<Request>();
while (reader.Read())
{
SampleRequest er = new SampleRequest();
er.Id = reader.GetInt32(0);
er.Type = reader.GetString(1);
er.Description = reader.GetString(2);
er.Created = reader.GetDateTime(3);
requests.Add(er);
}
return requests;
}
protected Authority readAuthority(DbDataReader dataReader)
{
Authority auth = null;
while (dataReader.Read())
{
auth = new Authority();
//Authority_ID,Auth_Type_ID,Default_Group_ID,Authority_Guid,Authority_Name,
//Authority_URL,Pass_Phrase, Email_Proxy,Description,Contact_Email,Bug_Email,Location
if (!dataReader.IsDBNull(0))
auth.authorityID = dataReader.GetInt32(0);
if (!dataReader.IsDBNull(1))
auth.authTypeID = dataReader.GetInt32(1);
if (!dataReader.IsDBNull(2))
auth.defaultGroupID = dataReader.GetInt32(2);
if (!dataReader.IsDBNull(3))
auth.authGuid = dataReader.GetString(3);
if (!dataReader.IsDBNull(4))
auth.authName = dataReader.GetString(4);
if (!dataReader.IsDBNull(5))
auth.authURL = dataReader.GetString(5);
if (!dataReader.IsDBNull(6))
auth.passphrase = dataReader.GetString(6);
if (!dataReader.IsDBNull(7))
auth.emailProxy = dataReader.GetString(7);
if (!dataReader.IsDBNull(8))
auth.description = dataReader.GetString(8);
if (!dataReader.IsDBNull(9))
auth.contactEmail = dataReader.GetString(9);
if (!dataReader.IsDBNull(10))
auth.bugEmail = dataReader.GetString(10);
if (!dataReader.IsDBNull(11))
auth.location = dataReader.GetString(11);
}
return auth;
}
private int CheckDbAndIndex(DbDataReader dbreader, IndexReader ixreader, List<Difference> result)
{
var versionId = dbreader.GetInt32(0);
var dbNodeTimestamp = dbreader.GetInt64(1);
var dbVersionTimestamp = dbreader.GetInt64(2);
var termDocs = ixreader.TermDocs(new Lucene.Net.Index.Term(LucObject.FieldName.VersionId, Lucene.Net.Util.NumericUtils.IntToPrefixCoded(versionId)));
Lucene.Net.Documents.Document doc = null;
int docid = -1;
if (termDocs.Next())
{
docid = termDocs.Doc();
doc = ixreader.Document(docid);
var indexNodeTimestamp = ParseLong(doc.Get(LucObject.FieldName.NodeTimestamp));
var indexVersionTimestamp = ParseLong(doc.Get(LucObject.FieldName.VersionTimestamp));
var nodeId = ParseInt(doc.Get(LucObject.FieldName.NodeId));
var version = doc.Get(LucObject.FieldName.Version);
var p = doc.Get(LucObject.FieldName.Path);
if (termDocs.Next())
{
result.Add(new Difference(IndexDifferenceKind.MoreDocument)
{
DocId = docid,
NodeId = nodeId,
VersionId = versionId,
Version = version,
Path = p,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
IxNodeTimestamp = indexNodeTimestamp,
IxVersionTimestamp = indexVersionTimestamp,
});
}
if (dbVersionTimestamp != indexVersionTimestamp)
{
result.Add(new Difference(IndexDifferenceKind.DifferentVersionTimestamp)
{
DocId = docid,
VersionId = versionId,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
IxNodeTimestamp = indexNodeTimestamp,
IxVersionTimestamp = indexVersionTimestamp,
NodeId = nodeId,
Version = version,
Path = p
});
}
if (dbNodeTimestamp != indexNodeTimestamp)
{
var ok = false;
var isLastDraft = doc.Get(LucObject.FieldName.IsLastDraft);
if (isLastDraft != BooleanIndexHandler.YES)
{
var latestDocs = ixreader.TermDocs(new Lucene.Net.Index.Term(LucObject.FieldName.NodeId, Lucene.Net.Util.NumericUtils.IntToPrefixCoded(nodeId)));
Lucene.Net.Documents.Document latestDoc = null;
while (latestDocs.Next())
{
var latestdocid = latestDocs.Doc();
var d = ixreader.Document(latestdocid);
if (d.Get(LucObject.FieldName.IsLastDraft) != BooleanIndexHandler.YES)
continue;
latestDoc = d;
break;
}
var latestPath = latestDoc.Get(LucObject.FieldName.Path);
if (latestPath == p)
ok = true;
}
if (!ok)
{
result.Add(new Difference(IndexDifferenceKind.DifferentNodeTimestamp)
{
DocId = docid,
VersionId = versionId,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
IxNodeTimestamp = indexNodeTimestamp,
IxVersionTimestamp = indexVersionTimestamp,
NodeId = nodeId,
Version = version,
Path = p
});
}
}
}
else
{
result.Add(new Difference(IndexDifferenceKind.NotInIndex)
{
DocId = docid,
VersionId = versionId,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
});
}
return docid;
}
protected void FillTreeNavigation(int major, TreeNode tNode, ContextMenuStrip nodeContextMenuStrip)
{
//change the type of data base
if (tNode != null)
{
TreeNodeData dataNode = (TreeNodeData)tNode.Tag;
currentConnectionStringName = dataNode.ConnectionStringName;
}
if (!string.IsNullOrEmpty(currentConnectionStringName))
{
currentProviderName = ConfigurationManager.ConnectionStrings[currentConnectionStringName].ProviderName;
currentConnectionString = ConfigurationManager.ConnectionStrings[currentConnectionStringName].ConnectionString;
switch (currentProviderName)
{
case "System.Data.SqlClient":
{
dbConnection = sqlConnection;
dbCommand = sqlCommand;
dbConnectionDaughter = sqlConnectionDaughter;
dbCommandDaughter = sqlCommandDaughter;
break;
}
case "FirebirdSql.Data.FirebirdClient":
{
dbConnection = fbConnection;
dbCommand = fbCommand;
dbConnectionDaughter = fbConnectionDaughter;
dbCommandDaughter = fbCommandDaughter;
break;
}
default:
{
throw new Exception("Bad name of current connection string");
}
}
}
else
{
throw new Exception("Bad name of current connection string");
}
//logic
dbConnection.Open();
dbConnectionDaughter.Open();
TreeNodeData treeNodeData;
TreeNode currentNode;
int i = 0, n = 0;
dbCommand.CommandText = "Select Id, Name From TUObjects Where Major = " + major + " Order by ClassId, Name";
dbDataReader = dbCommand.ExecuteReader();
while (dbDataReader.Read())
{
treeNodeData = new TreeNodeData(dbDataReader.GetInt32(0), false, currentConnectionStringName);
currentNode = new TreeNode(dbDataReader.GetString(1));
currentNode.Tag = treeNodeData;
if(nodeContextMenuStrip != null)
currentNode.ContextMenuStrip = nodeContextMenuStrip;
if (tNode != null)
tNode.Nodes.Add(currentNode);
else
treeNavigation.Nodes.Add(currentNode);
dbCommandDaughter.CommandText = "Select Count(Id) From TUObjects Where Major = " + dbDataReader.GetInt32(0);
n = (int)dbCommandDaughter.ExecuteScalar();
if (n > 0)
{
if (tNode != null)
tNode.Nodes[i].Nodes.Add("Virtual Node");
else
treeNavigation.Nodes[i].Nodes.Add("Virtual Node");
}
i++;
}
dbDataReader.Close();
dbConnection.Close();
dbConnectionDaughter.Close();
}
