public LimitationResponse Create(LimitationViewModel limitation)
{
LimitationResponse response = new LimitationResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, limitation);
insertCommand.ExecuteNonQuery();
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
return(response);
}
db.Close();
response.Success = true;
return(response);
}
}
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, LimitationViewModel limitation)
{
insertCommand.Parameters.AddWithValue("@ServerId", limitation.Id);
insertCommand.Parameters.AddWithValue("@Identifier", limitation.Identifier);
insertCommand.Parameters.AddWithValue("@ConstructionSiteLimit", ((object)limitation.ConstructionSiteLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@BusinessPartnerConstructionSiteLimit", ((object)limitation.BusinessPartnerConstructionSiteLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeConstructionSiteLimit", ((object)limitation.EmployeeConstructionSiteLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeBusinessPartnerLimit", ((object)limitation.EmployeeBusinessPartnerLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeBirthdayLimit", ((object)limitation.EmployeeBirthdayLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeePassportLimit", ((object)limitation.EmployeePassportLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeEmbasyLimit", ((object)limitation.EmployeeEmbasyLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeVisaTakeOffLimit", ((object)limitation.EmployeeVisaTakeOffLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeVisaLimit", ((object)limitation.EmployeeVisaLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeWorkLicenceLimit", ((object)limitation.EmployeeWorkLicenceLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeDriveLicenceLimit", ((object)limitation.EmployeeDriveLicenceLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@EmployeeEmbasyFamilyLimit", ((object)limitation.EmployeeEmbasyFamilyLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonPassportLimit", ((object)limitation.PersonPassportLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonEmbasyLimit", ((object)limitation.PersonEmbasyLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonVisaTakeOffLimit", ((object)limitation.PersonVisaTakeOffLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonVisaLimit", ((object)limitation.PersonVisaLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonWorkLicenceLimit", ((object)limitation.PersonWorkLicenceLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonDriveLicenceLimit", ((object)limitation.PersonDriveLicenceLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@PersonEmbasyFamilyLimit", ((object)limitation.PersonEmbasyFamilyLimit) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@IsSynced", limitation.IsSynced);
insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)limitation.UpdatedAt) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@CreatedById", MainWindow.CurrentUser.Id);
insertCommand.Parameters.AddWithValue("@CreatedByName", MainWindow.CurrentUser.FirstName + " " + MainWindow.CurrentUser.LastName);
insertCommand.Parameters.AddWithValue("@CompanyId", MainWindow.CurrentCompany.Id);
insertCommand.Parameters.AddWithValue("@CompanyName", MainWindow.CurrentCompany.CompanyName);
return(insertCommand);
}
public LimitationResponse Create(LimitationViewModel limitation)
{
LimitationResponse response = new LimitationResponse();
try
{
response = WpfApiHandler.SendToApi <LimitationViewModel, LimitationResponse>(limitation, "Create");
}
catch (Exception ex)
{
response.Limitation = new LimitationViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult Create([FromBody] LimitationViewModel c)
{
LimitationResponse response = new LimitationResponse();
try
{
response = this.limitationService.Create(c);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
Console.WriteLine(ex.Message);
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public LimitationResponse Create(LimitationViewModel limitation)
{
LimitationResponse response = new LimitationResponse();
try
{
Limitation addedLimitation = unitOfWork.GetLimitationRepository().Create(limitation.ConvertToLimitation());
unitOfWork.Save();
response.Limitation = addedLimitation.ConvertToLimitationViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.Limitation = new LimitationViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public static LimitationViewModel ConvertToLimitationViewModel(this Limitation limitation)
{
LimitationViewModel limitationViewModel = new LimitationViewModel()
{
Id = limitation.Id,
Identifier = limitation.Identifier,
ConstructionSiteLimit = limitation.ConstructionSiteLimit,
BusinessPartnerConstructionSiteLimit = limitation.BusinessPartnerConstructionSiteLimit,
EmployeeConstructionSiteLimit = limitation.EmployeeConstructionSiteLimit,
EmployeeBusinessPartnerLimit = limitation.EmployeeBusinessPartnerLimit,
EmployeeBirthdayLimit = limitation.EmployeeBirthdayLimit,
EmployeePassportLimit = limitation.EmployeePassportLimit,
EmployeeEmbasyLimit = limitation.EmployeeEmbasyLimit,
EmployeeVisaTakeOffLimit = limitation.EmployeeVisaTakeOffLimit,
EmployeeVisaLimit = limitation.EmployeeVisaLimit,
EmployeeWorkLicenceLimit = limitation.EmployeeWorkLicenceLimit,
EmployeeDriveLicenceLimit = limitation.EmployeeDriveLicenceLimit,
EmployeeEmbasyFamilyLimit = limitation.EmployeeEmbasyFamilyLimit,
PersonPassportLimit = limitation.PersonPassportLimit,
PersonEmbasyLimit = limitation.PersonEmbasyLimit,
PersonVisaTakeOffLimit = limitation.PersonVisaTakeOffLimit,
PersonVisaLimit = limitation.PersonVisaLimit,
PersonWorkLicenceLimit = limitation.PersonWorkLicenceLimit,
PersonDriveLicenceLimit = limitation.PersonDriveLicenceLimit,
PersonEmbasyFamilyLimit = limitation.PersonEmbasyFamilyLimit,
IsActive = limitation.Active,
CreatedBy = limitation.CreatedBy?.ConvertToUserViewModelLite(),
Company = limitation.Company?.ConvertToCompanyViewModelLite(),
UpdatedAt = limitation.UpdatedAt,
CreatedAt = limitation.CreatedAt
};
return(limitationViewModel);
}
public static Limitation ConvertToLimitation(this LimitationViewModel limitationViewModel)
{
Limitation limitation = new Limitation()
{
Id = limitationViewModel.Id,
Identifier = limitationViewModel.Identifier,
ConstructionSiteLimit = limitationViewModel.ConstructionSiteLimit,
BusinessPartnerConstructionSiteLimit = limitationViewModel.BusinessPartnerConstructionSiteLimit,
EmployeeConstructionSiteLimit = limitationViewModel.EmployeeConstructionSiteLimit,
EmployeeBusinessPartnerLimit = limitationViewModel.EmployeeBusinessPartnerLimit,
EmployeeBirthdayLimit = limitationViewModel.EmployeeBirthdayLimit,
EmployeePassportLimit = limitationViewModel.EmployeePassportLimit,
EmployeeEmbasyLimit = limitationViewModel.EmployeeEmbasyLimit,
EmployeeVisaTakeOffLimit = limitationViewModel.EmployeeVisaTakeOffLimit,
EmployeeVisaLimit = limitationViewModel.EmployeeVisaLimit,
EmployeeWorkLicenceLimit = limitationViewModel.EmployeeWorkLicenceLimit,
EmployeeDriveLicenceLimit = limitationViewModel.EmployeeDriveLicenceLimit,
EmployeeEmbasyFamilyLimit = limitationViewModel.EmployeeEmbasyFamilyLimit,
PersonPassportLimit = limitationViewModel.PersonPassportLimit,
PersonEmbasyLimit = limitationViewModel.PersonEmbasyLimit,
PersonVisaTakeOffLimit = limitationViewModel.PersonVisaTakeOffLimit,
PersonVisaLimit = limitationViewModel.PersonVisaLimit,
PersonWorkLicenceLimit = limitationViewModel.PersonWorkLicenceLimit,
PersonDriveLicenceLimit = limitationViewModel.PersonDriveLicenceLimit,
PersonEmbasyFamilyLimit = limitationViewModel.PersonEmbasyFamilyLimit,
Active = limitationViewModel.IsActive,
CreatedById = limitationViewModel.CreatedBy?.Id ?? null,
CompanyId = limitationViewModel.Company?.Id ?? null,
CreatedAt = limitationViewModel.CreatedAt,
UpdatedAt = limitationViewModel.UpdatedAt
};
return(limitation);
}
public LimitationResponse GetLimitation(int companyId)
{
LimitationResponse response = new LimitationResponse();
LimitationViewModel limitation = new LimitationViewModel();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM Limitations " +
"WHERE CompanyId = @CompanyId;", db);
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
limitation = Read(query);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.Limitation = new LimitationViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.Limitation = limitation;
return(response);
}
private LimitationViewModel Read(SqliteDataReader query)
{
int counter = 0;
LimitationViewModel dbEntry = new LimitationViewModel();
dbEntry.Id = SQLiteHelper.GetInt(query, ref counter);
dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter);
dbEntry.ConstructionSiteLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.BusinessPartnerConstructionSiteLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeConstructionSiteLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeBusinessPartnerLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeBirthdayLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeePassportLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeEmbasyLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeVisaTakeOffLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeVisaLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeWorkLicenceLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeDriveLicenceLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.EmployeeEmbasyFamilyLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonPassportLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonEmbasyLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonVisaTakeOffLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonVisaLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonWorkLicenceLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonDriveLicenceLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.PersonEmbasyFamilyLimit = SQLiteHelper.GetInt(query, ref counter);
dbEntry.IsSynced = SQLiteHelper.GetBoolean(query, ref counter);
dbEntry.UpdatedAt = SQLiteHelper.GetDateTime(query, ref counter);
dbEntry.CreatedBy = SQLiteHelper.GetCreatedBy(query, ref counter);
dbEntry.Company = SQLiteHelper.GetCompany(query, ref counter);
return(dbEntry);
}
