public ConstructionSiteNote Delete(Guid identifier)
{
ConstructionSiteNote dbEntry = context.ConstructionSiteNotes
.Union(context.ChangeTracker.Entries()
.Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(ConstructionSiteNote))
.Select(x => x.Entity as ConstructionSiteNote))
.FirstOrDefault(x => x.Identifier == identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.Active = false;
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public static ConstructionSiteNote ConvertToConstructionSiteNote(this ConstructionSiteNoteViewModel constructionSiteNoteViewModel)
{
ConstructionSiteNote ConstructionSiteNote = new ConstructionSiteNote()
{
Id = constructionSiteNoteViewModel.Id,
Identifier = constructionSiteNoteViewModel.Identifier,
ConstructionSiteId = constructionSiteNoteViewModel.ConstructionSite?.Id ?? null,
Note = constructionSiteNoteViewModel.Note,
NoteDate = constructionSiteNoteViewModel.NoteDate,
ItemStatus = constructionSiteNoteViewModel.ItemStatus,
Path = constructionSiteNoteViewModel.Path,
CreatedById = constructionSiteNoteViewModel.CreatedBy?.Id ?? null,
CompanyId = constructionSiteNoteViewModel.Company?.Id ?? null,
CreatedAt = constructionSiteNoteViewModel.CreatedAt,
UpdatedAt = constructionSiteNoteViewModel.UpdatedAt
};
return(ConstructionSiteNote);
}
public ConstructionSiteNote Create(ConstructionSiteNote constructionSiteNote)
{
if (context.ConstructionSiteNotes.Where(x => x.Identifier != null && x.Identifier == constructionSiteNote.Identifier).Count() == 0)
{
constructionSiteNote.Id = 0;
constructionSiteNote.Active = true;
constructionSiteNote.UpdatedAt = DateTime.Now;
constructionSiteNote.CreatedAt = DateTime.Now;
context.ConstructionSiteNotes.Add(constructionSiteNote);
return(constructionSiteNote);
}
else
{
// Load item that will be updated
ConstructionSiteNote dbEntry = context.ConstructionSiteNotes
.FirstOrDefault(x => x.Identifier == constructionSiteNote.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.CompanyId = constructionSiteNote.CompanyId ?? null;
dbEntry.CreatedById = constructionSiteNote.CreatedById ?? null;
// Set properties
dbEntry.Note = constructionSiteNote.Note;
dbEntry.NoteDate = constructionSiteNote.NoteDate;
dbEntry.ItemStatus = constructionSiteNote.ItemStatus;
dbEntry.Path = constructionSiteNote.Path;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public static ConstructionSiteNoteViewModel ConvertToConstructionSiteNoteViewModelLite(this ConstructionSiteNote constructionSiteNote)
{
ConstructionSiteNoteViewModel constructionSiteNoteViewModel = new ConstructionSiteNoteViewModel()
{
Id = constructionSiteNote.Id,
Identifier = constructionSiteNote.Identifier,
Note = constructionSiteNote.Note,
NoteDate = constructionSiteNote.NoteDate,
ItemStatus = constructionSiteNote.ItemStatus,
Path = constructionSiteNote.Path,
IsActive = constructionSiteNote.Active,
UpdatedAt = constructionSiteNote.UpdatedAt,
CreatedAt = constructionSiteNote.CreatedAt
};
return(constructionSiteNoteViewModel);
}
public List <ConstructionSiteNote> GetConstructionSiteNotes(int companyId)
{
List <ConstructionSiteNote> ConstructionSiteNotes = new List <ConstructionSiteNote>();
string queryString =
"SELECT ConstructionSiteNoteId, ConstructionSiteNoteIdentifier, " +
"ConstructionSiteId, ConstructionSiteIdentifier, ConstructionSiteCode, ConstructionSiteName, " +
"Note, NoteDate, Path, ItemStatus, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vConstructionSiteNotes " +
"WHERE CompanyId = @CompanyId AND Active = 1;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@CompanyId", companyId));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
ConstructionSiteNote constructionSiteNote;
while (reader.Read())
{
constructionSiteNote = new ConstructionSiteNote();
constructionSiteNote.Id = Int32.Parse(reader["ConstructionSiteNoteId"].ToString());
constructionSiteNote.Identifier = Guid.Parse(reader["ConstructionSiteNoteIdentifier"].ToString());
if (reader["ConstructionSiteId"] != DBNull.Value)
{
constructionSiteNote.ConstructionSite = new ConstructionSite();
constructionSiteNote.ConstructionSiteId = Int32.Parse(reader["ConstructionSiteId"].ToString());
constructionSiteNote.ConstructionSite.Id = Int32.Parse(reader["ConstructionSiteId"].ToString());
constructionSiteNote.ConstructionSite.Identifier = Guid.Parse(reader["ConstructionSiteIdentifier"].ToString());
constructionSiteNote.ConstructionSite.Code = reader["ConstructionSiteCode"].ToString();
constructionSiteNote.ConstructionSite.Name = reader["ConstructionSiteName"].ToString();
}
if (reader["Note"] != DBNull.Value)
{
constructionSiteNote.Note = reader["Note"].ToString();
}
if (reader["NoteDate"] != DBNull.Value)
{
constructionSiteNote.NoteDate = DateTime.Parse(reader["NoteDate"].ToString());
}
if (reader["ItemStatus"] != DBNull.Value)
{
constructionSiteNote.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString());
}
if (reader["Path"] != DBNull.Value)
{
constructionSiteNote.Path = reader["Path"].ToString();
}
constructionSiteNote.Active = bool.Parse(reader["Active"].ToString());
constructionSiteNote.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
constructionSiteNote.CreatedBy = new User();
constructionSiteNote.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
constructionSiteNote.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
constructionSiteNote.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
constructionSiteNote.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
constructionSiteNote.Company = new Company();
constructionSiteNote.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
constructionSiteNote.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
constructionSiteNote.Company.Name = reader["CompanyName"].ToString();
}
ConstructionSiteNotes.Add(constructionSiteNote);
}
}
}
return(ConstructionSiteNotes);
//List<ConstructionSiteNote> ConstructionSiteNotes = context.ConstructionSiteNotes
// .Include(x => x.ConstructionSite)
// .Include(x => x.Company)
// .Include(x => x.CreatedBy)
// .Where(x => x.Active == true && x.CompanyId == companyId)
// .AsNoTracking()
// .ToList();
//return ConstructionSiteNotes;
}