bool CheckIfExists(SqlConnection connection, SurvelemOld e)
{
var r = connection.Query(
"SELECT COUNT(ID) as Count FROM Survelems WHERE NetmeraId = @id", new { id = e.id }).ToList().First();
return(r.Count > 0);
}
void Insert(SurvelemOld e, SqlConnection connection)
{
var newId = Guid.NewGuid();
Guid?optionId = null;
Guid?optionId2 = null;
if (!string.IsNullOrEmpty(e.OptionID))
{
optionId = _options.First(x => x.NetmeraId == e.OptionID).Id;
}
if (!string.IsNullOrEmpty(e.OptionID2ndry))
{
optionId2 = _options.First(x => x.NetmeraId == e.OptionID2ndry).Id;
}
connection.Execute(@"INSERT INTO [dbo].[Survelems]
([Id]
,[OptionID]
,[UPRN]
,[Question_Ref]
,[COMMENT]
,[Freetext]
,[BuildingType]
,[DateOfSurvey]
,[CustomerID]
,[CustomerSurveyID]
,[NetmeraId]
,[CreateDate]
,[OptionID2ndry]
,SqT1
,SqT2
,SqT3
,SqT4
,SqT5
,SqT6
,SqT7
,SqT8
,SqT9
,SqT10
,SqT11
,SqT12
,SqT13
,SqT14
,SqT15
,SqN1
,SqN2
,SqN3
,SqN4
,SqN5
,SqN6
,SqN7
,SqN8
,SqN9
,SqN10
,SqN11
,SqN12
,SqN13
,SqN14
,SqN15
)
VALUES
(@Id
,@OptionID
,@UPRN
,@Question_Ref
,@COMMENT
,@Freetext
,@BuildingType
,@DateOfSurvey
,@CustomerID
,@CustomerSurveyID
,@NetmeraId
,@CreateDate
,@OptionID2ndry
,@SqT1
,@SqT2
,@SqT3
,@SqT4
,@SqT5
,@SqT6
,@SqT7
,@SqT8
,@SqT9
,@SqT10
,@SqT11
,@SqT12
,@SqT13
,@SqT14
,@SqT15
,@SqN1
,@SqN2
,@SqN3
,@SqN4
,@SqN5
,@SqN6
,@SqN7
,@SqN8
,@SqN9
,@SqN10
,@SqN11
,@SqN12
,@SqN13
,@SqN14
,@SqN15
)", new
{
@Id = newId,
OptionID = optionId,
UPRN = e.UPRN,
Question_Ref = e.Question_Ref,
COMMENT = e.COMMENT,
Freetext = e.Freetext,
BuildingType = e.BuildingType,
DateOfSurvey = e.DateOfSurvey,
CustomerID = e.CustomerID,
CustomerSurveyID = e.CustomerSurveyID,
NetmeraId = e.id,
CreateDate = DateTime.UtcNow,
OptionID2ndry = optionId2,
e.SqT1,
e.SqT2,
e.SqT3,
e.SqT4,
e.SqT5,
e.SqT6,
e.SqT7,
e.SqT8,
e.SqT9,
e.SqT10,
e.SqT11,
e.SqT12,
e.SqT13,
e.SqT14,
e.SqT15,
e.SqN1,
e.SqN2,
e.SqN3,
e.SqN4,
e.SqN5,
e.SqN6,
e.SqN7,
e.SqN8,
e.SqN9,
e.SqN10,
e.SqN11,
e.SqN12,
e.SqN13,
e.SqN14,
e.SqN15,
});
}