private void SaveDevice(FacilityDevice div, SqlTransaction sqltransaction)
{
string sql = "INSERT INTO FacilityDevice ([InstrumentId],[FacilityId],[TestingPointId],[DeviceCode],[DateInstalled],"
+ "[Longitude],[Latitude],[SerialNumber],[MobilNo],[PINNumber]) VALUES (@InstrumentId, @FacilityId,@TestingPointId,"
+ "@DeviceCode,@DateInstalled, @Longitude, @Latitude,@SerialNumber,@MobilNo,@PINNumber) SELECT @@identity";
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, sqltransaction))
{
SetDevice(cm, div);
div.Id = int.Parse(cm.ExecuteScalar().ToString());
}
}
private void SetDevice(SqlCommand cm, FacilityDevice div)
{
DatabaseHelper.InsertStringNVarCharParam("@DeviceCode", cm, div.DeviceCode);
DatabaseHelper.InsertInt32Param("@InstrumentId", cm, div.InstrumentId);
DatabaseHelper.InsertStringNVarCharParam("@MobilNo", cm, div.MobilNo);
DatabaseHelper.InsertStringNVarCharParam("@PINNumber", cm, div.PINNumber);
DatabaseHelper.InsertStringNVarCharParam("@SerialNumber", cm, div.SerialNumber);
DatabaseHelper.InsertInt32Param("@FacilityId", cm, div.FacilityId);
DatabaseHelper.InsertInt32Param("@TestingPointId", cm, div.TestingPointId);
DatabaseHelper.InsertDateTimeParam("@DateInstalled", cm, div.DateInstalled);
DatabaseHelper.InsertMoneyParam("@Longitude", cm, div.Longitude);
DatabaseHelper.InsertMoneyParam("@Latitude", cm, div.Latitude);
}
private void FetchDevice(SqlDataReader dr, Facility fac)
{
while (dr.Read())
{
FacilityDevice device = new FacilityDevice
{
Id = DatabaseHelper.GetInt32("DeviceId", dr),
InstrumentId = DatabaseHelper.GetInt32("InstrumentId", dr),
FacilityId = DatabaseHelper.GetInt32("FacilityId", dr),
TestingPointId = DatabaseHelper.GetInt32("TestingPointId", dr),
InstrumentName = DatabaseHelper.GetString("InstrumentName", dr),
DeviceCode = DatabaseHelper.GetString("DeviceCode", dr),
MobilNo = DatabaseHelper.GetString("MobilNo", dr),
PINNumber = DatabaseHelper.GetString("PINNumber", dr),
SerialNumber = DatabaseHelper.GetString("SerialNumber", dr),
DateInstalled = DatabaseHelper.GetDateTime("DateInstalled", dr),
Latitude = DatabaseHelper.GetMoney("Latitude", dr),
Longitude = DatabaseHelper.GetMoney("Longitude", dr),
TestingPoint = DatabaseHelper.GetString("TypeName", dr)
};
fac.Devices.Add(device);
}
}
