private int Insert(AreaMPZT item, IDbConnection db)
{
string consultationTime = item.ConsultationTime.ToString("yyyy-MM-dd HH:mm:ss");
string expirationDate = item.ExpirationDate.ToString("yyyy-MM-dd HH:mm:ss");
string sql = @"INSERT INTO AreaMPZT (Name, ConsultationTime, ExpirationDate, PhaseId, OfficeId, LocationId)"
+ $"Values ('{item.Name}', '{consultationTime}', '{expirationDate}', {item.Phase.Id}, {item.Office.Id}, {item.Location.Id});"
+ @"SELECT CAST(SCOPE_IDENTITY() as int)";
var id = db.Query <int>(sql).SingleOrDefault();
return(id);
}
public int InsertOrUpdate(AreaMPZT item)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString))
{
db.Open();
if (item.Id > 0)
{
return(Update(item, db));
}
else
{
return(Insert(item, db));
}
}
}
public void InsertOrUpdateAreaReturnsIdOfNewAreaTest()
{
AreaMPZT area = new AreaMPZT()
{
ConsultationTime = new DateTime(2020, 06, 25, 16, 00, 00),
ExpirationDate = new DateTime(2020, 07, 10),
Location = new Location()
{
Id = 1
},
Name = "Nowe zagospodarowanie ulicy Mickiewicza",
Office = new Office()
{
Id = 1
},
Phase = new Phase()
{
Id = 1
}
};
Assert.IsTrue(_areaRepository.InsertOrUpdate(area) > 0);
}
private int Update(AreaMPZT item, IDbConnection db)
{
throw new NotImplementedException();
}
