public static List <OutputInvoiceNoteViewModel> ConvertToOutputInvoiceNoteViewModelList(this IEnumerable <OutputInvoiceNote> OutputInvoiceNotes)
{
List <OutputInvoiceNoteViewModel> OutputInvoiceNoteViewModels = new List <OutputInvoiceNoteViewModel>();
foreach (OutputInvoiceNote OutputInvoiceNote in OutputInvoiceNotes)
{
OutputInvoiceNoteViewModels.Add(OutputInvoiceNote.ConvertToOutputInvoiceNoteViewModel());
}
return(OutputInvoiceNoteViewModels);
}
public OutputInvoiceNote Delete(Guid identifier)
{
OutputInvoiceNote dbEntry = context.OutputInvoiceNotes
.Union(context.ChangeTracker.Entries()
.Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(OutputInvoiceNote))
.Select(x => x.Entity as OutputInvoiceNote))
.FirstOrDefault(x => x.Identifier == identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.Active = false;
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public static OutputInvoiceNote ConvertToOutputInvoiceNote(this OutputInvoiceNoteViewModel OutputInvoiceNoteViewModel)
{
OutputInvoiceNote OutputInvoiceNote = new OutputInvoiceNote()
{
Id = OutputInvoiceNoteViewModel.Id,
Identifier = OutputInvoiceNoteViewModel.Identifier,
OutputInvoiceId = OutputInvoiceNoteViewModel.OutputInvoice?.Id ?? null,
Note = OutputInvoiceNoteViewModel.Note,
NoteDate = OutputInvoiceNoteViewModel.NoteDate,
ItemStatus = OutputInvoiceNoteViewModel.ItemStatus,
CreatedById = OutputInvoiceNoteViewModel.CreatedBy?.Id ?? null,
CompanyId = OutputInvoiceNoteViewModel.Company?.Id ?? null,
CreatedAt = OutputInvoiceNoteViewModel.CreatedAt,
UpdatedAt = OutputInvoiceNoteViewModel.UpdatedAt
};
return(OutputInvoiceNote);
}
public OutputInvoiceNote Create(OutputInvoiceNote OutputInvoiceNote)
{
if (context.OutputInvoiceNotes.Where(x => x.Identifier != null && x.Identifier == OutputInvoiceNote.Identifier).Count() == 0)
{
OutputInvoiceNote.Id = 0;
OutputInvoiceNote.Active = true;
OutputInvoiceNote.UpdatedAt = DateTime.Now;
OutputInvoiceNote.CreatedAt = DateTime.Now;
context.OutputInvoiceNotes.Add(OutputInvoiceNote);
return(OutputInvoiceNote);
}
else
{
// Load item that will be updated
OutputInvoiceNote dbEntry = context.OutputInvoiceNotes
.FirstOrDefault(x => x.Identifier == OutputInvoiceNote.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.CompanyId = OutputInvoiceNote.CompanyId ?? null;
dbEntry.CreatedById = OutputInvoiceNote.CreatedById ?? null;
// Set properties
dbEntry.Note = OutputInvoiceNote.Note;
dbEntry.NoteDate = OutputInvoiceNote.NoteDate;
dbEntry.ItemStatus = OutputInvoiceNote.ItemStatus;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public static OutputInvoiceNoteViewModel ConvertToOutputInvoiceNoteViewModel(this OutputInvoiceNote OutputInvoiceNote)
{
OutputInvoiceNoteViewModel OutputInvoiceNoteViewModel = new OutputInvoiceNoteViewModel()
{
Id = OutputInvoiceNote.Id,
Identifier = OutputInvoiceNote.Identifier,
OutputInvoice = OutputInvoiceNote.OutputInvoice?.ConvertToOutputInvoiceViewModelLite(),
Note = OutputInvoiceNote.Note,
NoteDate = OutputInvoiceNote.NoteDate,
ItemStatus = OutputInvoiceNote.ItemStatus,
IsActive = OutputInvoiceNote.Active,
CreatedBy = OutputInvoiceNote.CreatedBy?.ConvertToUserViewModelLite(),
Company = OutputInvoiceNote.Company?.ConvertToCompanyViewModelLite(),
UpdatedAt = OutputInvoiceNote.UpdatedAt,
CreatedAt = OutputInvoiceNote.CreatedAt
};
return(OutputInvoiceNoteViewModel);
}
public static OutputInvoiceNoteViewModel ConvertToOutputInvoiceNoteViewModelLite(this OutputInvoiceNote OutputInvoiceNote)
{
OutputInvoiceNoteViewModel OutputInvoiceNoteViewModel = new OutputInvoiceNoteViewModel()
{
Id = OutputInvoiceNote.Id,
Identifier = OutputInvoiceNote.Identifier,
Note = OutputInvoiceNote.Note,
NoteDate = OutputInvoiceNote.NoteDate,
ItemStatus = OutputInvoiceNote.ItemStatus,
IsActive = OutputInvoiceNote.Active,
UpdatedAt = OutputInvoiceNote.UpdatedAt,
CreatedAt = OutputInvoiceNote.CreatedAt
};
return(OutputInvoiceNoteViewModel);
}
public List <OutputInvoiceNote> GetOutputInvoiceNotes(int companyId)
{
List <OutputInvoiceNote> OutputInvoiceNotes = new List <OutputInvoiceNote>();
string queryString =
"SELECT OutputInvoiceNoteId, OutputInvoiceNoteIdentifier, " +
"OutputInvoiceId, OutputInvoiceIdentifier, OutputInvoiceCode, " +
"Note, NoteDate, ItemStatus," +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vOutputInvoiceNotes " +
"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())
{
OutputInvoiceNote outputInvoiceNote;
while (reader.Read())
{
outputInvoiceNote = new OutputInvoiceNote();
outputInvoiceNote.Id = Int32.Parse(reader["OutputInvoiceNoteId"].ToString());
outputInvoiceNote.Identifier = Guid.Parse(reader["OutputInvoiceNoteIdentifier"].ToString());
if (reader["OutputInvoiceId"] != DBNull.Value)
{
outputInvoiceNote.OutputInvoice = new OutputInvoice();
outputInvoiceNote.OutputInvoiceId = Int32.Parse(reader["OutputInvoiceId"].ToString());
outputInvoiceNote.OutputInvoice.Id = Int32.Parse(reader["OutputInvoiceId"].ToString());
outputInvoiceNote.OutputInvoice.Identifier = Guid.Parse(reader["OutputInvoiceIdentifier"].ToString());
outputInvoiceNote.OutputInvoice.Code = reader["OutputInvoiceCode"].ToString();
}
if (reader["Note"] != DBNull.Value)
{
outputInvoiceNote.Note = reader["Note"].ToString();
}
if (reader["NoteDate"] != DBNull.Value)
{
outputInvoiceNote.NoteDate = DateTime.Parse(reader["NoteDate"].ToString());
}
if (reader["ItemStatus"] != DBNull.Value)
{
outputInvoiceNote.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString());
}
outputInvoiceNote.Active = bool.Parse(reader["Active"].ToString());
outputInvoiceNote.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
outputInvoiceNote.CreatedBy = new User();
outputInvoiceNote.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
outputInvoiceNote.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
outputInvoiceNote.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
outputInvoiceNote.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
outputInvoiceNote.Company = new Company();
outputInvoiceNote.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
outputInvoiceNote.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
outputInvoiceNote.Company.Name = reader["CompanyName"].ToString();
}
OutputInvoiceNotes.Add(outputInvoiceNote);
}
}
}
return(OutputInvoiceNotes);
//List<OutputInvoiceNote> OutputInvoiceNotes = context.OutputInvoiceNotes
// .Include(x => x.OutputInvoice)
// .Include(x => x.Company)
// .Include(x => x.CreatedBy)
// .Where(x => x.Active == true && x.CompanyId == companyId)
// .AsNoTracking()
// .ToList();
//return OutputInvoiceNotes;
}
public List <OutputInvoiceNote> GetOutputInvoiceNotesNewerThen(int companyId, DateTime lastUpdateTime)
{
List <OutputInvoiceNote> OutputInvoiceNotes = new List <OutputInvoiceNote>();
string queryString =
"SELECT OutputInvoiceNoteId, OutputInvoiceNoteIdentifier, " +
"OutputInvoiceId, OutputInvoiceIdentifier, OutputInvoiceCode, " +
"Note, NoteDate, ItemStatus, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vOutputInvoiceNotes " +
"WHERE CompanyId = @CompanyId " +
"AND CONVERT(DATETIME, CONVERT(VARCHAR(20), UpdatedAt, 120)) > CONVERT(DATETIME, CONVERT(VARCHAR(20), @LastUpdateTime, 120));";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@CompanyId", companyId));
command.Parameters.Add(new SqlParameter("@LastUpdateTime", lastUpdateTime));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
OutputInvoiceNote outputInvoiceNote;
while (reader.Read())
{
outputInvoiceNote = new OutputInvoiceNote();
outputInvoiceNote.Id = Int32.Parse(reader["OutputInvoiceNoteId"].ToString());
outputInvoiceNote.Identifier = Guid.Parse(reader["OutputInvoiceNoteIdentifier"].ToString());
if (reader["OutputInvoiceId"] != DBNull.Value)
{
outputInvoiceNote.OutputInvoice = new OutputInvoice();
outputInvoiceNote.OutputInvoiceId = Int32.Parse(reader["OutputInvoiceId"].ToString());
outputInvoiceNote.OutputInvoice.Id = Int32.Parse(reader["OutputInvoiceId"].ToString());
outputInvoiceNote.OutputInvoice.Identifier = Guid.Parse(reader["OutputInvoiceIdentifier"].ToString());
outputInvoiceNote.OutputInvoice.Code = reader["OutputInvoiceCode"].ToString();
}
if (reader["Note"] != DBNull.Value)
{
outputInvoiceNote.Note = reader["Note"].ToString();
}
if (reader["NoteDate"] != DBNull.Value)
{
outputInvoiceNote.NoteDate = DateTime.Parse(reader["NoteDate"].ToString());
}
if (reader["ItemStatus"] != DBNull.Value)
{
outputInvoiceNote.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString());
}
outputInvoiceNote.Active = bool.Parse(reader["Active"].ToString());
outputInvoiceNote.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
outputInvoiceNote.CreatedBy = new User();
outputInvoiceNote.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
outputInvoiceNote.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
outputInvoiceNote.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
outputInvoiceNote.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
outputInvoiceNote.Company = new Company();
outputInvoiceNote.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
outputInvoiceNote.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
outputInvoiceNote.Company.Name = reader["CompanyName"].ToString();
}
OutputInvoiceNotes.Add(outputInvoiceNote);
}
}
}
return(OutputInvoiceNotes);
}
