public void Insert(RoadmapGroupDto data)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(_dbName)) {
using (var cm = ctx.Connection.CreateCommand()) {
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO RoadmapGroups (OwnerSss, RoadmapName, Protected, CreationTime, StartYear, " +
"EndYear, XML, Validation_Status, ConvertToVehicleInput_Status) " +
"VALUES (@ownerSss, @roadmapName, @protected, @creationTime, @startYear, @endYear, @xml, @validationStatus, @convertToVehicleInputStatus)";
cm.Parameters.AddWithValue("@ownerSss", data.OwnerSss);
cm.Parameters.AddWithValue("@roadmapName", data.RoadmapName);
cm.Parameters.AddWithValue("@protected", data.Protected);
cm.Parameters.AddWithValue("@creationTime", data.CreationTime);
cm.Parameters.AddWithValue("@startYear", data.StartYear);
cm.Parameters.AddWithValue("@endYear", data.EndYear);
cm.Parameters.AddWithValue("@xml", data.Xml);
cm.Parameters.AddWithValue("@validationStatus", data.ValidationStatusValue);
cm.Parameters.AddWithValue("@convertToVehicleInputStatus", data.ConvertToVehicleInputStatusValue);
cm.ExecuteNonQuery();
cm.Parameters.Clear();
cm.CommandText = "SELECT @@identity";
var r = cm.ExecuteScalar();
var newId = int.Parse(r.ToString());
data.RoadmapGroupId = newId;
}
}
}
public void Update(RoadmapGroupDto data)
{
using (var ctx = DbContextManager <Reco4Context> .GetManager(_dbName)) {
var item = (from r in ctx.DbContext.RoadmapGroups
where r.RoadmapGroupId == data.RoadmapGroupId
select r).FirstOrDefault();
if (data == null)
{
throw new DataNotFoundException("RoadmapGroup not found error.");
}
if (!data.CreationTime.Matches(item.CreationTime))
{
throw new ConcurrencyException("ConcurrencyException: CreationTime mismatch.");
}
item.RoadmapGroupId = data.RoadmapGroupId;
item.OwnerSss = data.OwnerSss;
item.RoadmapName = data.RoadmapName;
item.Protected = data.Protected;
item.CreationTime = data.CreationTime;
item.StartYear = data.StartYear;
item.EndYear = data.EndYear;
item.Xml = data.Xml;
item.Validation_Status = data.ValidationStatusValue;
item.ConvertToVehicleInput_Status = data.ConvertToVehicleInputStatusValue;
var count = ctx.DbContext.SaveChanges();
if (count == 0)
{
throw new UpdateFailureException("Failed to save RoadmapGroup.");
}
}
}
private void Child_Fetch(RoadmapGroupDto item)
{
RoadmapGroupId = item.RoadmapGroupId;
OwnerSss = item.OwnerSss;
RoadmapName = item.RoadmapName;
Protected = item.Protected;
CreationTime = item.CreationTime;
StartYear = item.StartYear;
EndYear = item.EndYear;
Xml = item.Xml;
ValidationStatusValue = (ValidationStatus)item.ValidationStatusValue;
ConvertToVehicleInputStatusValue = (ConvertToVehicleInputStatus)item.ConvertToVehicleInputStatusValue;
}
public List <RoadmapGroupDto> Fetch()
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(_dbName)) {
using (var cm = ctx.Connection.CreateCommand()) {
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT * FROM RoadmapGroups";
//cm.CommandType = CommandType.StoredProcedure;
//cm.CommandText = "GetRoadmapGroups";
using (var dr = cm.ExecuteReader()) {
if (dr.HasRows)
{
var result = new List <RoadmapGroupDto>();
while (dr.Read())
{
var roadmapGroup = new RoadmapGroupDto {
RoadmapGroupId = dr.GetInt32(0),
OwnerSss = dr.GetString(1),
RoadmapName = dr.GetString(2),
Protected = dr.GetBoolean(3),
CreationTime = dr.GetDateTime(4),
StartYear = dr.GetInt32(5),
EndYear = dr.GetInt32(6),
Xml = dr.GetString(7),
ValidationStatusValue = dr.GetInt32(8),
ConvertToVehicleInputStatusValue = dr.GetInt32(9)
};
result.Add(roadmapGroup);
}
;
return(result);
}
else
{
return(null);
}
}
}
}
}
public void Insert(RoadmapGroupDto data)
{
using (var ctx = DbContextManager <Reco4Context> .GetManager(_dbName)) {
var item = new RoadmapGroup {
OwnerSss = data.OwnerSss,
RoadmapName = data.RoadmapName,
Protected = data.Protected,
CreationTime = data.CreationTime,
StartYear = data.StartYear,
EndYear = data.EndYear,
Xml = data.Xml,
Validation_Status = data.ValidationStatusValue,
ConvertToVehicleInput_Status = data.ConvertToVehicleInputStatusValue
};
ctx.DbContext.RoadmapGroups.Add(item);
ctx.DbContext.SaveChanges();
data.RoadmapGroupId = item.RoadmapGroupId;
}
}
private void Update()
{
using (var ctx = DalFactory.GetManager()) {
var dal = ctx.GetProvider <Dal.IRoadmapGroupDal>();
using (BypassPropertyChecks) {
var item = new RoadmapGroupDto {
RoadmapGroupId = RoadmapGroupId,
OwnerSss = OwnerSss,
RoadmapName = RoadmapName,
Protected = Protected,
CreationTime = CreationTime,
StartYear = StartYear,
EndYear = EndYear,
Xml = Xml,
ValidationStatusValue = (int)ValidationStatusValue,
ConvertToVehicleInputStatusValue = (int)ConvertToVehicleInputStatusValue
};
dal.Update(item);
}
}
}
public RoadmapGroupDto Fetch(int id)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager(_dbName)) {
using (var cm = ctx.Connection.CreateCommand()) {
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT * FROM RoadmapGroups WHERE RoadmapGroupId = @id";
cm.Parameters.AddWithValue("@id", id);
using (var dr = cm.ExecuteReader()) {
if (dr.HasRows)
{
dr.Read();
var result = new RoadmapGroupDto {
RoadmapGroupId = dr.GetInt32(0),
OwnerSss = dr.GetString(1),
RoadmapName = dr.GetString(2),
Protected = dr.GetBoolean(3),
CreationTime = dr.GetDateTime(4),
StartYear = dr.GetInt32(5),
EndYear = dr.GetInt32(6),
Xml = dr.GetString(7),
ValidationStatusValue = dr.GetInt32(8),
ConvertToVehicleInputStatusValue = dr.GetInt32(9)
};
return(result);
}
else
{
return(null);
}
}
}
}
}
public void Update(RoadmapGroupDto data)
{
throw new NotImplementedException();
}
