public static OutputInvoiceDocument ConvertToOutputInvoiceDocument(this OutputInvoiceDocumentViewModel outputInvoiceDocumentViewModel)
{
OutputInvoiceDocument OutputInvoiceDocument = new OutputInvoiceDocument()
{
Id = outputInvoiceDocumentViewModel.Id,
Identifier = outputInvoiceDocumentViewModel.Identifier,
OutputInvoiceId = outputInvoiceDocumentViewModel.OutputInvoice?.Id ?? null,
Name = outputInvoiceDocumentViewModel.Name,
CreateDate = outputInvoiceDocumentViewModel.CreateDate,
Path = outputInvoiceDocumentViewModel.Path,
ItemStatus = outputInvoiceDocumentViewModel.ItemStatus,
Active = outputInvoiceDocumentViewModel.IsActive,
CreatedById = outputInvoiceDocumentViewModel.CreatedBy?.Id ?? null,
CompanyId = outputInvoiceDocumentViewModel.Company?.Id ?? null,
CreatedAt = outputInvoiceDocumentViewModel.CreatedAt,
UpdatedAt = outputInvoiceDocumentViewModel.UpdatedAt
};
return(OutputInvoiceDocument);
}
public static List <OutputInvoiceDocumentViewModel> ConvertToOutputInvoiceDocumentViewModelList(this IEnumerable <OutputInvoiceDocument> outputInvoiceDocuments)
{
List <OutputInvoiceDocumentViewModel> OutputInvoiceDocumentViewModels = new List <OutputInvoiceDocumentViewModel>();
foreach (OutputInvoiceDocument OutputInvoiceDocument in outputInvoiceDocuments)
{
OutputInvoiceDocumentViewModels.Add(OutputInvoiceDocument.ConvertToOutputInvoiceDocumentViewModel());
}
return(OutputInvoiceDocumentViewModels);
}
public OutputInvoiceDocument Delete(Guid identifier)
{
OutputInvoiceDocument dbEntry = context.OutputInvoiceDocuments
.Union(context.ChangeTracker.Entries()
.Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(OutputInvoiceDocument))
.Select(x => x.Entity as OutputInvoiceDocument))
.FirstOrDefault(x => x.Identifier == identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.Active = false;
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public OutputInvoiceDocument Create(OutputInvoiceDocument OutputInvoiceDocument)
{
if (context.OutputInvoiceDocuments.Where(x => x.Identifier != null && x.Identifier == OutputInvoiceDocument.Identifier).Count() == 0)
{
OutputInvoiceDocument.Id = 0;
OutputInvoiceDocument.Active = true;
OutputInvoiceDocument.UpdatedAt = DateTime.Now;
OutputInvoiceDocument.CreatedAt = DateTime.Now;
context.OutputInvoiceDocuments.Add(OutputInvoiceDocument);
return(OutputInvoiceDocument);
}
else
{
// Load item that will be updated
OutputInvoiceDocument dbEntry = context.OutputInvoiceDocuments
.FirstOrDefault(x => x.Identifier == OutputInvoiceDocument.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.CompanyId = OutputInvoiceDocument.CompanyId ?? null;
dbEntry.CreatedById = OutputInvoiceDocument.CreatedById ?? null;
// Set properties
dbEntry.Name = OutputInvoiceDocument.Name;
dbEntry.CreateDate = OutputInvoiceDocument.CreateDate;
dbEntry.Path = OutputInvoiceDocument.Path;
dbEntry.ItemStatus = OutputInvoiceDocument.ItemStatus;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public static OutputInvoiceDocumentViewModel ConvertToOutputInvoiceDocumentViewModelLite(this OutputInvoiceDocument outputInvoiceDocument)
{
OutputInvoiceDocumentViewModel OutputInvoiceDocumentViewModel = new OutputInvoiceDocumentViewModel()
{
Id = outputInvoiceDocument.Id,
Identifier = outputInvoiceDocument.Identifier,
Name = outputInvoiceDocument.Name,
CreateDate = outputInvoiceDocument.CreateDate,
Path = outputInvoiceDocument.Path,
ItemStatus = outputInvoiceDocument.ItemStatus,
IsActive = outputInvoiceDocument.Active,
UpdatedAt = outputInvoiceDocument.UpdatedAt,
CreatedAt = outputInvoiceDocument.CreatedAt
};
return(OutputInvoiceDocumentViewModel);
}
public List <OutputInvoiceDocument> GetOutputInvoiceDocuments(int companyId)
{
List <OutputInvoiceDocument> OutputInvoiceDocuments = new List <OutputInvoiceDocument>();
string queryString =
"SELECT OutputInvoiceDocumentId, OutputInvoiceDocumentIdentifier, " +
"OutputInvoiceId, OutputInvoiceIdentifier, OutputInvoiceCode, " +
"Name, CreateDate, Path, ItemStatus, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, " +
"CompanyId, CompanyName " +
"FROM vOutputInvoiceDocuments " +
"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())
{
OutputInvoiceDocument outputInvoiceDocument;
while (reader.Read())
{
outputInvoiceDocument = new OutputInvoiceDocument();
outputInvoiceDocument.Id = Int32.Parse(reader["OutputInvoiceDocumentId"].ToString());
outputInvoiceDocument.Identifier = Guid.Parse(reader["OutputInvoiceDocumentIdentifier"].ToString());
if (reader["OutputInvoiceId"] != DBNull.Value)
{
outputInvoiceDocument.OutputInvoice = new OutputInvoice();
outputInvoiceDocument.OutputInvoiceId = Int32.Parse(reader["OutputInvoiceId"].ToString());
outputInvoiceDocument.OutputInvoice.Id = Int32.Parse(reader["OutputInvoiceId"].ToString());
outputInvoiceDocument.OutputInvoice.Identifier = Guid.Parse(reader["OutputInvoiceIdentifier"].ToString());
outputInvoiceDocument.OutputInvoice.Code = reader["OutputInvoiceCode"].ToString();
}
if (reader["Name"] != DBNull.Value)
{
outputInvoiceDocument.Name = reader["Name"].ToString();
}
if (reader["CreateDate"] != DBNull.Value)
{
outputInvoiceDocument.CreateDate = DateTime.Parse(reader["CreateDate"].ToString());
}
if (reader["Path"] != DBNull.Value)
{
outputInvoiceDocument.Path = reader["Path"].ToString();
}
if (reader["ItemStatus"] != DBNull.Value)
{
outputInvoiceDocument.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString());
}
outputInvoiceDocument.Active = bool.Parse(reader["Active"].ToString());
outputInvoiceDocument.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
outputInvoiceDocument.CreatedBy = new User();
outputInvoiceDocument.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
outputInvoiceDocument.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
outputInvoiceDocument.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
outputInvoiceDocument.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
outputInvoiceDocument.Company = new Company();
outputInvoiceDocument.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
outputInvoiceDocument.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
outputInvoiceDocument.Company.Name = reader["CompanyName"].ToString();
}
OutputInvoiceDocuments.Add(outputInvoiceDocument);
}
}
}
return(OutputInvoiceDocuments);
}
