public static double?GetDoubleNullable(System.Data.IDataReader dataReader, int i)
{
if (dataReader.IsDBNull(i))
{
return(null);
}
return(dataReader.GetDouble(i));
}
public static double GetDouble(System.Data.IDataReader rdr, string Column, double NullValue)
{
if (rdr[Column] != DBNull.Value)
{
return(rdr.GetDouble(rdr.GetOrdinal(Column)));
}
else
{
return(NullValue);
}
}
public IQuest ParseQuest(System.Data.IDataReader reader)
{
dbReader = DatabaseReader.Instance();
IQuest currentQuest = null;
string name = reader.GetString(0);
string description = reader.GetString(1);
int type = reader.GetInt32(2);
int rewardExp = reader.GetInt32(3);
int rewardMoney = reader.GetInt16(4);
double prevValue = reader.GetDouble(5);
double requireValue = reader.GetDouble(6);
switch (type)
{
case 0: // Distance
double totalDistance = dbReader.totalDistance;
currentQuest = new DistanceQuest
(name, description,
requireValue, prevValue,
rewardExp, rewardMoney);
break;
case 1: // Share
int totalShare = dbReader.totalShare;
currentQuest = new FacebookQuest(
name, description,
(int)prevValue, (int)requireValue,
rewardExp, rewardMoney);
break;
default:
break;
}
return(currentQuest);
}
public static Achievement Parse(System.Data.IDataReader reader)
{
string _name = reader.GetString(0);
string _description = reader.GetString(1);
int _shareRequirement = reader.GetInt32(2);
double _distanceRequirement = reader.GetDouble(3);
int _petLevelRequirement = reader.GetInt32(4);
int _rewardExp = reader.GetInt32(5);
int _rewardMoney = reader.GetInt32(6);
return(new Achievement(
_name,
_description,
_shareRequirement,
_distanceRequirement,
_petLevelRequirement,
_rewardExp,
_rewardMoney
));
}
public void TestUpdateOPCSampleGrp01()
{
OPCSampleGrpConfigStartModel oPCSampleGrpConfigStartModel = new OPCSampleGrpConfigStartModel();
//insert temp grp
EtyDataLogDPGroupTrend etySampleGrp = new EtyDataLogDPGroupTrend();
etySampleGrp.SampleGrpName = "ParasoftTesting123";
etySampleGrp.SampleGrpDescription = "testing";
etySampleGrp.IntervalType = "S";
etySampleGrp.Interval = 23;
etySampleGrp.DeltaValue = 1;
etySampleGrp.Disabled = true;
etySampleGrp.StartTime = "09:44";
etySampleGrp.NewData = true;
oPCSampleGrpConfigStartModel.InsertOPCSampleGrp(etySampleGrp);
//update the values
etySampleGrp.IntervalType = "H";
etySampleGrp.Interval = 1;
etySampleGrp.DeltaValue = 4;
etySampleGrp.Disabled = false;
etySampleGrp.StartTime = "";
//Test Procedure Call
oPCSampleGrpConfigStartModel.UpdateOPCSampleGrp(etySampleGrp);
//Post Condition Check
#region PostConditionCheck
//Check updation from DB
try
{
string localSQL = "SELECT PKEY,NAME,DESCRIPTION,SAMPLE_INTERVAL,INTERVAL_TYPE,START_TIME,DELTA_VALUE,ENABLED FROM DATALOG_DP_GROUP_TREND where NAME ='" +
etySampleGrp.SampleGrpName + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(0))
{
etySampleGrp.SampleGrpID = drReader.GetInt32(0);
double Interval = drReader.GetInt32(3);
Assert.AreEqual(Interval, etySampleGrp.Interval);
string IntervalType = drReader.GetString(4).ToString();
Assert.AreEqual(etySampleGrp.IntervalType, IntervalType);
string StartTime = drReader.GetString(5).ToString();
Assert.AreEqual(etySampleGrp.StartTime, StartTime);
double DeltaValue = drReader.GetDouble(6);
Assert.AreEqual(etySampleGrp.DeltaValue, DeltaValue);
string disabled = drReader.GetString(7).ToString();
bool bdis = DAOHelper.ChangeStrToBool(disabled);
Assert.AreEqual(etySampleGrp.Disabled, bdis);
}
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
}
catch (Exception localException)
{
//failed test
}
#endregion
#region Cleanup
//delete inserted temp group
DatalogDPGroupTrendDAO.GetInstance().DeleteOPCSampleGroupById(etySampleGrp.SampleGrpID.ToString());
#endregion
}
public void Write(System.Data.IDataReader reader)
{
var organization = db.Organizations.Find(organizationId);
Dictionary <string, KitMaterial> materials = new Dictionary <string, KitMaterial>();
Dictionary <string, KitOption> options = new Dictionary <string, KitOption>();
Dictionary <int, ValveInterfaceCode> valveInterfaces = new Dictionary <int, ValveInterfaceCode>();
Dictionary <int, ActuatorInterfaceCode> actuatorInterfaces = new Dictionary <int, ActuatorInterfaceCode>();
while (reader.Read())
{
// columns
// KitNumber, ValveIntCode, ActIntCode, MaterialCode, OptionCode, Price
string kitNumber = reader.GetString(0);
var kit = db.Kits.Where(k => k.KitNumber == kitNumber).FirstOrDefault();
if (kit == null)
{
// get the material
string materialCode = reader.GetString(3);
var material = db.KitMaterials.Where(m => m.Code == materialCode).FirstOrDefault();
if (material == null)
{
if (materials.ContainsKey(materialCode))
{
material = materials[materialCode];
}
else
{
material = new KitMaterial()
{
Code = materialCode,
Name = materialCode
};
db.KitMaterials.Add(material);
materials.Add(materialCode, material);
}
}
// get the locking option
string optionCode = reader.GetString(4);
var option = db.KitOptions.Where(o => o.Code == optionCode).FirstOrDefault();
if (option == null)
{
if (options.ContainsKey(optionCode))
{
option = options[optionCode];
}
else
{
option = new KitOption()
{
Code = optionCode,
Name = optionCode
};
db.KitOptions.Add(option);
options.Add(optionCode, option);
}
}
// get the valve interface
int valveIntCode = reader.GetInt32(1);
var valveInterface = db.ValveInterfaceCodes.Find(valveIntCode);
if (valveInterface == null)
{
if (valveInterfaces.ContainsKey(valveIntCode))
{
valveInterface = valveInterfaces[valveIntCode];
}
else
{
valveInterface = new ValveInterfaceCode()
{
InterfaceCode = valveIntCode
};
db.ValveInterfaceCodes.Add(valveInterface);
valveInterfaces.Add(valveIntCode, valveInterface);
}
}
// get the actuator interace
int actIntCode = reader.GetInt32(2);
var actInterface = db.ActuatorInterfaceCodes.Find(actIntCode);
if (actInterface == null)
{
if (actuatorInterfaces.ContainsKey(actIntCode))
{
actInterface = actuatorInterfaces[actIntCode];
}
else
{
actInterface = new ActuatorInterfaceCode()
{
InterfaceCode = actIntCode
};
db.ActuatorInterfaceCodes.Add(actInterface);
actuatorInterfaces.Add(actIntCode, actInterface);
}
}
// add the kit
double price = reader.GetDouble(5);
kit = new Kit()
{
KitNumber = reader.GetString(0),
ValuveIntefaceCodeEntity = valveInterface,
ActuatorInterfaceCodeEntity = actInterface,
Price = price,
Material = material,
Option = option
};
db.Kits.Add(kit);
}
// link this kit to the organization
if (kit.KitId > 0)
{
if (!organization.Kits.Where(k => k.KitId == kit.KitId).Any())
{
organization.Kits.Add(kit);
}
}
else
{
organization.Kits.Add(kit);
}
}
}
public static double Double(System.Data.IDataReader reader, MapPoint mapPoint, double defaultValue = 0)
{
try
{
return(mapPoint.IsInResultSet() && !reader.IsDBNull(mapPoint.Index) ? reader.GetDouble(mapPoint.Index) : defaultValue);
}
catch (Exception)
{
throw;
}
}
public static double?GetDouble(System.Data.IDataReader rdr, string Column)
{
return(rdr [Column] != DBNull.Value ? (double?)rdr.GetDouble(rdr.GetOrdinal(Column)) : null);
}
public void SetFromReader <T>(T obj, System.Data.IDataReader reader, Action <T, string, object> setMethod)
where T : class
{
if (!reader.IsDBNull(this.Index))
{
switch (this.SqlType)
{
case System.Data.SqlDbType.BigInt:
setMethod(obj, FieldName, reader.GetInt64(this.Index));
break;
case System.Data.SqlDbType.Image:
case System.Data.SqlDbType.VarBinary:
case System.Data.SqlDbType.Binary:
long size = reader.GetBytes(this.Index, 0, null, 0, 0);
byte[] values = new byte[size];
int bufferSize = 1024;
long bytesRead = 0;
int curPos = 0;
while (bytesRead < size)
{
bytesRead += reader.GetBytes(this.Index, curPos, values, curPos, bufferSize);
curPos += bufferSize;
}
setMethod(obj, FieldName, values);
break;
case System.Data.SqlDbType.Bit:
setMethod(obj, FieldName, reader.GetBoolean(this.Index));
break;
case System.Data.SqlDbType.Char:
setMethod(obj, FieldName, reader.GetChar(this.Index));
break;
case System.Data.SqlDbType.SmallDateTime:
case System.Data.SqlDbType.Date:
case System.Data.SqlDbType.DateTime:
case System.Data.SqlDbType.DateTime2:
setMethod(obj, FieldName, reader.GetDateTime(this.Index));
break;
case System.Data.SqlDbType.SmallMoney:
case System.Data.SqlDbType.Money:
case System.Data.SqlDbType.Decimal:
setMethod(obj, FieldName, reader.GetDecimal(this.Index));
break;
case System.Data.SqlDbType.Float:
setMethod(obj, FieldName, reader.GetDouble(this.Index));
break;
case System.Data.SqlDbType.Int:
setMethod(obj, FieldName, reader.GetInt32(this.Index));
break;
case System.Data.SqlDbType.Text:
case System.Data.SqlDbType.NVarChar:
case System.Data.SqlDbType.NText:
case System.Data.SqlDbType.VarChar:
case System.Data.SqlDbType.NChar:
setMethod(obj, FieldName, reader.GetString(this.Index));
break;
case System.Data.SqlDbType.Real:
setMethod(obj, FieldName, reader.GetFloat(this.Index));
break;
case System.Data.SqlDbType.SmallInt:
setMethod(obj, FieldName, reader.GetInt16(this.Index));
break;
case System.Data.SqlDbType.TinyInt:
setMethod(obj, FieldName, reader.GetByte(this.Index));
break;
case System.Data.SqlDbType.UniqueIdentifier:
setMethod(obj, FieldName, reader.GetGuid(this.Index));
break;
default:
break;
}
}
else
{
setMethod(obj, FieldName, null);
}
}
double System.Data.IDataRecord.GetDouble(int i)
{
return(_dataReader.GetDouble(i));
}
public static double AsDouble(this System.Data.IDataReader reader, string name, double defaultValue = 0d)
{
var o = reader[name];
return(o != null && o != DBNull.Value ? reader.GetDouble(reader.GetOrdinal(name)) : defaultValue);
}
