public ContractViewModel GetElement(ContractBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new TravelAgencyContext())
{
var contract = context.Contract
.FirstOrDefault(rec => rec.Contractid == model.Id);
return(contract != null ?
new ContractViewModel
{
Id = contract.Contractid,
Clientid = contract.Clientid,
Datetotravel = contract.Datetotravel,
Datefromtravel = contract.Datefromtravel,
Countnumberhotel = contract.Countnumberhotel,
Datetohotel = contract.Datetohotel,
Datefromhotel = contract.Datefromhotel,
Routeid = contract.Routeid,
Hotelid = contract.Hotelid,
Transportid = contract.Trasportid
} :
null);
}
}
public List <ContractViewModel> GetFilteredList(ContractBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new TravelAgencyContext())
{
return(context.Contract
.Where(rec => rec.Datefromtravel == model.Datefromtravel)
.Select(rec => new ContractViewModel
{
Id = rec.Contractid,
Clientid = rec.Clientid,
Datetotravel = rec.Datetotravel,
Datefromtravel = rec.Datefromtravel,
Countnumberhotel = rec.Countnumberhotel,
Datetohotel = rec.Datetohotel,
Datefromhotel = rec.Datefromhotel,
Routeid = rec.Routeid,
Hotelid = rec.Hotelid,
Transportid = rec.Trasportid
})
.ToList());
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
int HotelDays = (dateTimePickerHotelTo.Value.Date - dateTimePickerHotelFrom.Value.Date).Days;
decimal Price = Convert.ToDecimal(dataGridViewTransport.SelectedRows[0].Cells[5].Value) +
Convert.ToDecimal(dataGridViewRooms.SelectedRows[0].Cells[4].Value) * HotelDays;
ContractBindingModel model = new ContractBindingModel
{
Clientid = Program.Client.Id,
Hotelid = HotelId.Value,
Routeid = RouteId.Value,
Transportid = TransportId.Value,
Datefromhotel = dateTimePickerHotelFrom.Value,
Datetohotel = dateTimePickerHotelTo.Value,
Datefromtravel = dateTimePickerTravelFrom.Value,
Datetotravel = dateTimePickerTravelTo.Value,
Price = Price,
Countnumberhotel = 1
};
_logicC.CreateOrUpdate(model);
MessageBox.Show("Успешно", "Сохранено",
MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException?.Message + "\n" + ex.Message, "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public void Insert(ContractBindingModel model)
{
using (var context = new TravelAgencyContext())
{
context.Contract.Add(CreateModel(model, new Contract()));
context.SaveChanges();
}
}
public IActionResult GetContract()
{
var model = new ContractBindingModel
{
ContractContent = System.IO.File.ReadAllText(CONTRACT_PATH)
};
return(this.Ok(model));
}
public List <ContractViewModel> Read(ContractBindingModel model)
{
if (model.Id.HasValue)
{
return(new List <ContractViewModel> {
_contractStorage.GetElement(model)
});
}
return(_contractStorage.GetFullList());
}
private Contract CreateModel(ContractBindingModel model, Contract contract, ComputerRepairDatabase context)
{
contract.CustomerBaseid = model.CustomerBaseId;
contract.Employeeid = model.EmployeeId;
contract.Paymentid = model.PaymentId;
contract.DateOfConclusion = model.DateOfConclusion;
if (contract.Id == 0)
{
context.Contract.Add(contract);
context.SaveChanges();
}
if (model.Id.HasValue)
{
List <ServicesContract> servicesContract = context.ServicesContract.Where(rec => rec.Contractid == model.Id.Value).ToList();
// удалили те, которых нет в модели
context.ServicesContract.RemoveRange(servicesContract.Where(rec => !model.ServicesContract.Contains(rec.Servicesid)).ToList());
context.SaveChanges();
// обновили количество у существующих записей
foreach (var updateServices in servicesContract)
{
model.ServicesContract.Remove(updateServices.Servicesid);
}
List <MaterialsContract> materialsContract = context.MaterialsContract.Where(rec => rec.Contractid == model.Id.Value).ToList();
// удалили те, которых нет в модели
context.MaterialsContract.RemoveRange(materialsContract.Where(rec => !model.MaterialsContract.Contains(rec.Materialsid)).ToList());
context.SaveChanges();
// обновили количество у существующих записей
foreach (var updateMaterials in materialsContract)
{
model.MaterialsContract.Remove(updateMaterials.Materialsid);
}
context.SaveChanges();
}
// добавили новые
foreach (var pc in model.ServicesContract)
{
context.ServicesContract.Add(new ServicesContract
{
Contractid = contract.Id,
Servicesid = pc
});
context.SaveChanges();
}
foreach (var pc in model.MaterialsContract)
{
context.MaterialsContract.Add(new MaterialsContract
{
Contractid = contract.Id,
Materialsid = pc
});
context.SaveChanges();
}
return(contract);
}
public void CreateOrUpdate(ContractBindingModel model)
{
if (model.Id.HasValue)
{
_contractStorage.Update(model);
}
else
{
_contractStorage.Insert(model);
}
}
public void Delete(ContractBindingModel model)
{
var element = _contractStorage.GetElement(new ContractBindingModel
{
Id = model.Id
});
if (element == null)
{
throw new Exception("Элемент не найден");
}
_contractStorage.Delete(model);
}
public void Update(ContractBindingModel model)
{
using (var context = new TravelAgencyContext())
{
var element = context.Contract.FirstOrDefault(rec => rec.Contractid == model.Id);
if (element == null)
{
throw new Exception("Договор не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
/// <summary>
/// Create contract
/// </summary>
/// <param name="contextId"></param>
/// <param name="keccak">Hashed tokens</param>
/// <returns></returns>
public GenericContractDeployment CreateGenericContract(Guid contextId, ContractBindingModel bindingModel)
{
GenericContractDeployment genericContractDeployment = new GenericContractDeployment
{
Parent = "0x0000000000000000000000000000000000000000",
ContextId = contextId.ToString(),
Token = Encoding.ASCII.GetBytes("X"), // keccak,
Version = "1",
ContextHash = bindingModel.ContextHash,
EndDate = 9,
};
return(genericContractDeployment);
}
private Contract CreateModel(ContractBindingModel model, Contract contract)
{
contract.Clientid = model.Clientid;
contract.Datetotravel = model.Datetotravel;
contract.Datefromtravel = model.Datefromtravel;
contract.Countnumberhotel = model.Countnumberhotel;
contract.Datetohotel = model.Datetohotel;
contract.Datefromhotel = model.Datefromhotel;
contract.Routeid = model.Routeid;
contract.Hotelid = model.Hotelid;
contract.Price = model.Price;
contract.Trasportid = model.Transportid;
return(contract);
}
public void Delete(ContractBindingModel model)
{
using (var context = new TravelAgencyContext())
{
Contract element = context.Contract.FirstOrDefault(rec => rec.Contractid == model.Id);
if (element != null)
{
context.Contract.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Договор не найден");
}
}
}
public void Delete(ContractBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
var contract = context.Contract.FirstOrDefault(rec => rec.Id == model.Id);
if (contract != null)
{
context.Contract.Remove(contract);
context.SaveChanges();
}
else
{
throw new Exception("Заказ не найден");
}
}
}
public void Insert(ContractBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
CreateModel(model, new Contract(), context);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
public ContractViewModel GetElement(ContractBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new ComputerRepairDatabase())
{
var contract = context.Contract
.Include(rec => rec.Employee)
.Include(rec => rec.ServicesContracts)
.ThenInclude(rec => rec.Services)
.Include(rec => rec.MaterialsContracts)
.ThenInclude(rec => rec.Materials)
.Include(rec => rec.Payment)
.Include(rec => rec.CustomerBase)
.FirstOrDefault(rec => rec.Id == model.Id);
return(contract != null ?
new ContractViewModel
{
Id = contract.Id,
DateOfConclusion = contract.DateOfConclusion,
CustomerBaseId = contract.CustomerBase.Id,
EmployeeId = contract.Employee.Id,
CustomerBase = contract.CustomerBase.Surname,
Employee = contract.Employee.Surname,
Payment = contract.Payment.Summ,
Materials = contract.MaterialsContracts
.Select(rc => new MaterialsViewModel {
Id = rc.Materials.Id, Name = rc.Materials.Name, Price = rc.Materials.Price
})
.ToList(),
Services = contract.ServicesContracts
.Select(rc => new ServicesViewModel {
Id = rc.Services.Id, Name = rc.Services.Name, Price = rc.Services.Price
})
.ToList()
} :
null);
}
}
/// <summary>
///
/// </summary>
/// <param name="contractBindingModel"></param>
/// <returns></returns>
public async Task <ResponseModel> AddContract(ContractBindingModel contractBindingModel)
{
var amountToSend = new HexBigInteger(1000000000000000000);
string keccak = Multihash.Encode(contractBindingModel.Token1 + contractBindingModel.Token2, HashType.KECCAK_256);
byte[] keccak2 = Multihash.Encode(contractBindingModel.Token1 + contractBindingModel.Token2, HashType.KECCAK_256);
var web3 = new Web3(_account, _blockChainUrl);
var deployment = CreateGenericContract(Guid.NewGuid(), contractBindingModel);
deployment.Gas = DefaultGasAmount;
var transactionHash = await GenericContractService.DeployContractAsync(web3, deployment);
//var addAttachment = await service.AddAttachmentHashRequestAndWaitForReceiptAsync(new AddAttachmentHashFunction
//{
// FromAddress = _account.Address,
// Hash = contractBindingModel.FileChecksum,
// Gas = DefaultGasAmount
//});
var contractId = transactionHash;
var abi = _contractRepository.GetAbi();
var bin = _contractRepository.GetBin();
var responseModel = new ResponseModel(contractBindingModel.ContextId, contractId, bin, abi);
_ = BenChainClientApi.Client.Signator.BenChainUpdateWithHttpMessagesAsync(new SignatoryModel
{
BenChainABI = abi,
BenChainBytescode = bin,
BenChainContractId = contractId,
ContextId = contractBindingModel.ContextId
});
return(responseModel);
}
public void Update(ContractBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var element = context.Contract.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
CreateModel(model, element, context);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
public IActionResult ModifyContract(ContractBindingModel model)
{
System.IO.File.WriteAllText(CONTRACT_PATH, model.ContractContent);
return(this.Ok(model));
}
