public static List <RemoconDetail> Get(string constructionCode)
{
constructionCode = constructionCode.Replace("'", "''");
var sql = @"SELECT * FROM RemoconDetails WHERE ConstructionCode = '" + constructionCode + "'";
var db = RemoconDetail.GetDatabase();
return(db.ExecuteQuery <RemoconDetail>(sql));
}
public static void Update(List <RemoconDetail> remocons)
{
if (remocons.Count == 0)
{
return;
}
var constructionCode = remocons[0].ConstructionCode;
var deleteSql = @"DELETE FROM RemoconDetails WHERE ConstructionCode = '" + constructionCode + "'";
var db = RemoconDetail.GetDatabase();
db.ExecuteNonQuery(deleteSql);
var now = DateTime.Now;
foreach (var remocon in remocons)
{
remocon.UpdatedDateTime = now;
db.Insert <RemoconDetail>(remocon);
}
}