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(); }