public void InsertInsured(Insured insured)
{
string queryString = "INSERT INTO Osiguranik (adresa, broj_telefona, email, broj_tekućeg_računa) VALUES (@address, @phoneNumber, @email, @accountNumber)";
using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@address", insured.Address);
command.Parameters.AddWithValue("@phoneNumber", insured.PhoneNumber);
command.Parameters.AddWithValue("@email", insured.Email);
command.Parameters.AddWithValue("@accountNumber", insured.AccountNumber);
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
connection.Close();
}
}
}
private void btnAddInsured_Click(object sender, EventArgs e)
{
try
{
var query = new CypherQuery($"MATCH (i:Insured) WHERE i.Identifier = '{long.Parse(tbIdentifier.Text)}'" +
$" or i.MailAddress = '" + tbMail.Text + "' or i.PhoneNumber = '" + tbPhoneNumber.Text +
"' or i.CreditCard = '" + tbCreditCard.Text + "' RETURN i", new Dictionary <string, object>(), CypherResultMode.Set);
var user = ((IRawGraphClient)client).ExecuteGetCypherResults <Insured>(query).ToList().FirstOrDefault();
if (user == null && checkRequirements())
{
Insured insured = new Insured
{
FirstName = tbFirstName.Text,
LastName = tbLastName.Text,
Identifier = long.Parse(tbIdentifier.Text),
Address = tbAddress.Text,
MailAddress = tbMail.Text,
BirthDate = dtpBirthdate.Value.Date,
CreditCard = tbCreditCard.Text,
Gender = cbGender.Text,
PhoneNumber = tbPhoneNumber.Text
};
Dictionary <string, object> queryDict = new Dictionary <string, object>
{
{ "FirstName", insured.FirstName },
{ "LastName", insured.LastName },
{ "Identifier", insured.Identifier },
{ "Address", insured.Address },
{ "MailAddress", insured.MailAddress },
{ "BirthDate", insured.BirthDate },
{ "CreditCard", insured.CreditCard },
{ "Gender", insured.Gender },
{ "PhoneNumber", insured.PhoneNumber }
};
query = new CypherQuery("Create (i:Insured {FirstName: '"
+ insured.FirstName + "', LastName: '" + insured.LastName + "', Identifier: '"
+ insured.Identifier + "', Address: '" + insured.Address + "', MailAddress: '" + insured.MailAddress
+ "', BirthDate: '" + insured.BirthDate + "', CreditCard: '" + insured.CreditCard
+ "', Gender: '" + insured.Gender + "', PhoneNumber: '" + insured.PhoneNumber + "'})",
queryDict, CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
lbStatus.Text = "Registracija osiguranika uspesna.";
lbStatus.Visible = true;
}
else if (user != null)
{
MessageBox.Show("JMBG, broj telefona, mejl adresa i broj racuna moraju biti jedinstveni.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void InsuredSearcherResponseTimeWithReflectionTest(string firstName, string middleName, string lastName, long milliseconds)
{
var monitor = new SemaphoreSlim(1);
monitor.Wait();
var form = new Insured();
form.SetControlProperty <TextBox>("tbFirstName", "Text", firstName);
form.SetControlProperty <TextBox>("tbMiddleName", "Text", middleName);
form.SetControlProperty <TextBox>("tbLastName", "Text", lastName);
form.ObserveControlEvents <DataGridView>(
"dataGridView1",
"DataSourceChanged",
(sender, args) =>
{
Trace.WriteLine("Occured in delegate");
monitor.Release();
});
Trace.WriteLine("Executing");
var sw = form.ClickButton("btnSearch");
monitor.Wait();
sw.Stop();
Trace.WriteLine(String.Format("Row count was {0} took {1}ms to process", form.GetControlProperty <DataGridView>("dataGridView1", "RowCount"), sw.ElapsedMilliseconds));
Assert.IsTrue(sw.ElapsedMilliseconds < milliseconds);
}
/// <summary>
/// Method responsible for create the properties necessaries
/// in creating Insurance
/// </summary>
/// <param name="command"> Property has all values necessary for creating de final object</param>
/// <returns></returns>
public ICommandResult Handler(InsuranceCreateCommand command)
{
var document = new Document(command.InsuredCpf);
var name = new Name(command.InsuredFirstName, command.InsuredLastName);
var insured = new Insured(command.InsuredAge, name, document);
decimal vehicleValue = 0;
decimal.TryParse(command.VehicleValue, out vehicleValue);
var vehicle = new Vehicle(command.VehicleBrand, command.VehicleModel, vehicleValue);
var insurance = new Insurance(insured, vehicle);
AddNotifications(insurance);
if (Invalid)
{
return(new CommandResult(false, "Falha ao cadastrar Seguro!", Notifications));
}
_iInsuranceRepository.Save(insurance);
return(new CommandResult(true, "Cadastrado com sucesso",
new CreateInsuranceResult(insurance.Id, insurance.Insured.Name.ToString())));
}
public int SaveInsured(Insured insured)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn.connectionStr;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"INSERT INTO [dbo].[Segurado]
VALUES
(@nomeSegurado,@cpf,@idade);
SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("@nomeSegurado", insured.Name);
cmd.Parameters.AddWithValue("@cpf", insured.Cpf);
cmd.Parameters.AddWithValue("@idade", insured.Age);
cnn.ConnOpen();
int Id = Convert.ToInt32(cmd.ExecuteScalar());
return(Id);
}
catch (Exception)
{
return(0);
}
finally
{
cnn.ConnClose();
}
}
private void btnRemoveInsured_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Da li ste sigurni?", "Ukloni korisnika", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
var query = new CypherQuery("MATCH (i:Insured { Identifier: '" + long.Parse(tbIdentifier.Text) + "' }) DETACH DELETE i",
new Dictionary <string, object>(), CypherResultMode.Set);
((IRawGraphClient)client).ExecuteCypher(query);
gbData.Visible = false;
lbStatus.Text = "Korisnik uspesno obrisan";
lbStatus.Visible = true;
user = null;
allowActions();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
protected void BtnInsuredCommit_Click(object sender, EventArgs e)
{
insured = new Insured(txtFirstName.Text, txtLastName.Text, txtMiddle.Text, txtDateOfBirth.Text,
Convert.ToInt32(txtCreditScore.Text), Convert.ToInt32(drpInsuredAddressID.SelectedValue), txtLicense.Text, txtInsuredUpdatedBy.Text,
txtInsuredLastUpdated.Text);
sc.Open();
String sqlQuery;
SqlCommand command = new SqlCommand();
command.Connection = sc;
try
{
sqlQuery = "INSERT INTO [dbo].[Insured] VALUES (@firstName, @lastName, @middle, @dateOfBirth, @creditScore, @addressID, @driversLicense, @updatedBy, @lastUpdated)";
command = new SqlCommand(sqlQuery, sc);
command.Parameters.AddWithValue("@firstName", insured.GetFirstName());
command.Parameters.AddWithValue("@lastName", insured.GetLastName());
if (insured.GetMiddle().Equals('\0'))
{
command.Parameters.AddWithValue("@middle", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@middle", insured.GetMiddle());
}
command.Parameters.AddWithValue("@dateOfBirth", insured.GetDOB());
command.Parameters.AddWithValue("@creditScore", insured.GetCreditScore());
command.Parameters.AddWithValue("@addressID", insured.GetAddressID());
if (insured.GetDriversLicense().Equals(""))
{
command.Parameters.AddWithValue("@driversLicense", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@driversLicense", insured.GetDriversLicense());
}
command.Parameters.AddWithValue("@updatedBy", insured.GetUpdatedBy());
command.Parameters.AddWithValue("@lastUpdated", insured.GetLastUpdated());
command.ExecuteNonQuery();
}
catch (SqlException ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('" + ex.Message + "')", true);
}
sc.Close();
//Response.Redirect("PolicyForm.aspx");
LoadGridView();
ClearTextFields();
}
public void ShouldReturnTrueWhenNotIsValid(string firstName, string lastName, string cpf, int age, string brand, string model, string value)
{
decimal.TryParse(value, out decimal _value);
var name = new Name(firstName, lastName);
var document = new Document(cpf);
var insured = new Insured(15, name, document);
var vehicle = new Vehicle(brand, model, _value);
var insurance = new Insurance(insured, vehicle);
Assert.IsTrue(insurance.Invalid);
}
public HttpResponseMessage SaveInsured(Insured sendInsured)
{
try
{
InsuredBusiness Insuredbusiness = new InsuredBusiness();
int idInsured = Insuredbusiness.SaveInsured(sendInsured);
return(Request.CreateResponse(HttpStatusCode.OK, "Veículo" + idInsured + "adicionado"));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.ToString()));
}
}
private void BTNSave_Click(object sender, EventArgs e)
{
Insured temp = new Insured(TBName.Text, NUValue.Value, DTPurchased.Value, CBCategory.Text,
TBComments.Lines);
if (BTNSave.Text.Equals("Update"))
{
InsuranceList.RemoveAt(LBIns.SelectedIndex);
BTNSave.Text = "BTNSave";
}
InsuranceList.Add(temp);
WriteToFile();
LoadList();
FormReset();
}
public async Task <int> Handle(CreateInsuranceCommand request, CancellationToken cancellationToken)
{
Insured insured = await insuredHelpers.GetInsured(request.Cpf);
Vehicle vehicle = new Vehicle(request.VehiclePrice, request.Model, request.Manufacture);
Insurance insurance = await insuranceFactory.Create(request.VehiclePrice, vehicle, insured);
context.Insurances.Add(insurance);
await context.SaveChangesAsync(cancellationToken);
return(insurance.Id);
}
public ActionResult <Insured> Save([FromBody] Insured insured)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
_repo.Add(insured);
bool isOk = _repo.Save();
if (isOk)
{
return(CreatedAtAction(nameof(GetById), new { id = insured.Id, insured }));
}
return(BadRequest());
}
public Task <Insurance> Create(decimal value, Vehicle vehicle, Insured insured)
{
IInsuranceTaxComponent component = new InsuranceTaxComponent(value);
foreach (var factory in componentFactories)
{
component = factory.Decorate(component);
}
if (System.Diagnostics.Debugger.IsAttached)
{
Console.WriteLine(component.Analyze());
}
return(Task.FromResult(new Insurance(component, vehicle, insured)));
}
public async Task <CreatePolicyResponse> CreatePolicyAsync(CreatePolicyCommand command)
{
var policy = new Domain.Policy(command.PolicyDateFrom, command.PolicyDateTo);
_policyContext.Policy.Add(policy);
var insured = new Insured(command.InsuredFirstName, command.InsuredLastName, command.InsuredNumber);
policy.AttachInsured(insured);
policy.AddProducts(command.ProductsCodes.ToList());
await _policyContext.SaveChangesAsync();
return(new CreatePolicyResponse {
PolicyId = policy.PolicyId
});
}
private void btnFindInsured_Click(object sender, EventArgs e)
{
try
{
if (rbIdentifier.Checked)
{
var query = new CypherQuery("MATCH (i:Insured) WHERE i.Identifier = '" + long.Parse(tbIdentifier.Text)
+ "' RETURN i", new Dictionary <string, object>(), CypherResultMode.Set);
user = ((IRawGraphClient)client).ExecuteGetCypherResults <Insured>(query).SingleOrDefault();
showUserData();
allowActions();
}
else if (rbMail.Checked)
{
var query = new CypherQuery("MATCH (i:Insured) WHERE i.MailAddress = '" + tbMailAddress.Text
+ "' RETURN i", new Dictionary <string, object>(), CypherResultMode.Set);
user = ((IRawGraphClient)client).ExecuteGetCypherResults <Insured>(query).SingleOrDefault();
showUserData();
allowActions();
}
else if (rbCreditCard.Checked)
{
var query = new CypherQuery("MATCH (i:Insured) WHERE i.CreditCard = '" + tbCreditCard.Text
+ "' RETURN i", new Dictionary <string, object>(), CypherResultMode.Set);
user = ((IRawGraphClient)client).ExecuteGetCypherResults <Insured>(query).SingleOrDefault();
showUserData();
allowActions();
}
else
{
var query = new CypherQuery("MATCH (i:Insured) WHERE i.PhoneNumber = '" + tbPhoneNumber.Text
+ "' RETURN i", new Dictionary <string, object>(), CypherResultMode.Set);
user = ((IRawGraphClient)client).ExecuteGetCypherResults <Insured>(query).SingleOrDefault();
showUserData();
allowActions();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void TestFixtureSetup()
{
var monitor = new SemaphoreSlim(1);
monitor.Wait();
var form = new Insured();
form.ObserveControlEvents <DataGridView>(
"dataGridView1",
"DataSourceChanged",
(sender, args) =>
{
Trace.WriteLine("Occured in delegate");
monitor.Release();
});
form.ClickButton("btnSearch");
monitor.Wait();
}
public void Setup()
{
_base = new CallObject();
var oNode = new Claim();
var oNode2 = new Insured();
var oNode3 = new Vehicle();
var oNode4 = new Driver();
_base.Add(oNode);
oNode.Add(oNode2);
oNode2.Add(oNode3);
oNode2.Add(oNode4);
oNode.SetValue(CallObject.LobCdAttributeName, "WOR");
oNode.ClaimNumber = "00122345";
oNode.LossDate = "12092005";
oNode2.InsuredName = "Steven Murphy";
oNode2.SetValue(Address.AddressLine1, "95 Wells Avenue");
oNode2.SetValue(Address.AddressCity, "Newton");
oNode2.SetValue(Address.AddressState, "MA");
oNode2.SetValue(Address.AddressZip, "02459");
oNode2.PhoneHome = "6178862064";
oNode3.Make = "TOYOTA";
oNode3.Model = "MATRIX";
oNode3.Vin = "1234567891011121314";
oNode3.Year = "2004";
oNode4.NameFirst = "Cookie";
oNode4.NameLast = " Murphy";
oNode4.SetValue(Address.AddressLine1, "529 Main Street");
oNode4.SetValue(Address.AddressCity, "Charlestown");
oNode4.SetValue(Address.AddressState, "MA");
oNode4.SetValue(Address.AddressZip, "02129");
oNode4.SetValue(EntityBase.HomePhoneAttribute, "6178862064");
_base.Commit();
}
public async Task <Insured> GetInsured(string cpf)
{
Insured insured = await context.Insureds.Where(e => e.CPF == cpf).FirstOrDefaultAsync();
if (!(insured is object))
{
insured = await insuredService.GetInsured(cpf);
}
if (!(insured is object))
{
throw new Exceptions.ValidationException(new List <FluentValidation.Results.ValidationFailure>()
{
new FluentValidation.Results.ValidationFailure("Cpf", "Cpf não encontrado")
});
}
return(insured);
}
public void AddInsured(Insured newInsured)
{
if (newInsured == null)
{
throw new ArgumentNullException();
}
var insuredExists = Insureds?.Exists(p => p.Id.Equals(newInsured.Id, StringComparison.OrdinalIgnoreCase)) ?? false;
if (insuredExists)
{
throw new InvalidOperationException("Received insured allready exists .");
}
Insureds.Add(newInsured);
var @event = new InsuredHasBeenCreated(newInsured);
Event.Dispatch(newInsured);
StoredEvents.Add(@event);
}
public List <Insured> GetInsureds()
{
List <Insured> insureds = new List <Insured>();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn.connectionStr;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"SELECT * FROM [dbo].[Segurado]";
cnn.ConnOpen();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
Insured retorno = new Insured();
retorno.idInsured = Convert.ToInt32(dt.Rows[j]["idSegurado"].ToString());
retorno.Cpf = dt.Rows[j]["cpf"].ToString();
retorno.Age = Convert.ToInt32(dt.Rows[j]["idade"].ToString());
retorno.Name = dt.Rows[j]["nomeSegurado"].ToString();
insureds.Add(retorno);
}
}
cnn.ConnClose();
return(insureds);
}
catch (Exception)
{
throw;
}
finally
{
cnn.ConnClose();
}
}
public Insured GetInsuredById(int idInsured)
{
Insured insured = new Insured();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn.connectionStr;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"SELECT * FROM [dbo].[Segurado] WHERE idSegurado=@idSegurado";
cmd.Parameters.AddWithValue("@idSegurado", idInsured);
cnn.ConnOpen();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
insured.idInsured = Convert.ToInt32(dt.Rows[0]["idSegurado"].ToString());
insured.Cpf = dt.Rows[0]["cpf"].ToString();
insured.Age = Convert.ToInt32(dt.Rows[0]["idade"].ToString());
insured.Name = dt.Rows[0]["nomeSegurado"].ToString();
}
cnn.ConnClose();
return(insured);
}
catch (Exception)
{
throw;
}
finally
{
cnn.ConnClose();
}
}
public List <Insured> GetAllInsured()
{
string queryString = "SELECT * FROM Osiguranik";
List <Insured> returnList = new List <Insured>();
using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(queryString, connection))
{
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Insured insured = new Insured();
insured.Id = reader.GetInt32(0);
insured.Address = reader.GetString(1);
insured.PhoneNumber = reader.GetString(2);
insured.Email = reader.GetString(3);
insured.AccountNumber = reader.GetString(4);
returnList.Add(insured);
}
reader.Close();
return(returnList);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
finally
{
connection.Close();
}
}
}
public void Delete(Insured insured)
{
db.Insureds.DeleteOnSubmit(insured);
}
//Insert/Delete Methods
public void Add(Insured insured)
{
db.Insureds.InsertOnSubmit(insured);
}
public NewInsuredViewModel()
{
_errorsList.Clear();
InsuredRepository insuredRepository = new InsuredRepository();
AddCommand = new RelayCommand <object>((p) =>
{
if (string.IsNullOrEmpty(this.InputId))
{
return(false);
}
if (string.IsNullOrEmpty(this.InputName))
{
return(false);
}
if (this.InputId.Length > 30)
{
UpdateResultAsync(Result.HasError, "Độ dài tối đa của số CMT/CCCD là 30 ký tự");
}
else
{
UpdateResultAsync(Result.ExcludeError, "Độ dài tối đa của số CMT/CCCD là 30 ký tự");
}
if (this.InputName.Length > 30)
{
UpdateResultAsync(Result.HasError, "Độ dài tối đa của Họ tên nhân viên là 50 ký tự");
}
else
{
UpdateResultAsync(Result.ExcludeError, "Độ dài tối đa của Họ tên nhân viên là 50 ký tự");
}
var creatingInsured = insuredRepository.GetInsured(this.InputId);
if (creatingInsured != null)
{
UpdateResultAsync(Result.HasError, "Số CMT/CCCD này đã tồn tại");
}
else
{
UpdateResultAsync(Result.ExcludeError, "Số CMT/CCCD này đã tồn tại");
}
if (_errorsList.Count > 0)
{
return(false);
}
else
{
return(true);
}
}, (p) =>
{
Insured newInsured = new Insured();
newInsured.Id = this.InputId.Trim(' ');
newInsured.Name = this.InputName.Trim(' ');
insuredRepository.Add(newInsured);
insuredRepository.Save();
Success = "Đã tạo nhân viên";
UpdateResultAsync(Result.Successful);
InputId = null;
InputName = null;
IsStartOver = true;
OnPropertyChanged("IsStartOver");
IsStartOver = false;
});
}
public List <Policy> GetAllPolicies()
{
string queryString = "SELECT * FROM Polisa JOIN Paket_rizika ON (Polisa.oznaka_paketa_rizika = Paket_rizika.ID_paketa_rizika) JOIN Osiguranik ON (Polisa.ID_osiguranika = Osiguranik.ID_osiguranika) JOIN Filijala ON (Polisa.ID_filijale = Filijala.ID_filijale) JOIN Vozilo ON (Polisa.registarski_broj = Vozilo.registarski_broj) JOIN Agent_osiguranja ON (Polisa.ID_agenta = Agent_osiguranja.ID_agenta)";
List <Policy> returnList = new List <Policy>();
using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(queryString, connection))
{
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Insured insured = new Insured
{
Id = reader.GetInt32(6),
AccountNumber = reader.GetString(18)
};
Affiliate affiliate = new Affiliate
{
Id = reader.GetInt32(19),
Name = reader.GetString(20)
};
RiskPackage riskPackage = new RiskPackage
{
Id = reader.GetInt32(11),
Name = reader.GetString(12)
};
Vehicle vehicle = new Vehicle
{
RegisterNumber = reader.GetString(23)
};
Agent agent = new Agent
{
Id = reader.GetInt32(31),
FirstName = reader.GetString(32),
LastName = reader.GetString(33)
};
Policy policy = new Policy
{
Id = reader.GetInt32(0),
CreatedOn = reader.GetDateTime(1),
StartDate = reader.GetDateTime(2),
EndDate = reader.GetDateTime(3),
Premium = reader.GetDecimal(4),
RiskPackage = riskPackage,
Insured = insured,
Affiliate = affiliate,
Vehicle = vehicle,
Agent = agent,
Bonus = reader.GetInt32(10)
};
returnList.Add(policy);
}
reader.Close();
return(returnList);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(returnList);
}
finally
{
connection.Close();
}
}
}
public bool SavePolicy(PolicyViewModel policy, string package, string franshiza, string tipkind, string tipkind1, int typepolicy, out string policyID)
{
//Tipkind p_tipkind1=null;
//Tipkind p_tipkind2 = null;
//Package p_pckg=null;
//Franshiza p_f=null;
policyID = string.Empty;
ValidatePolicy(policy);
int p_tipkindContractor = Convert.ToInt32(tipkind);
int p_tipkindInsured = Convert.ToInt32(tipkind1);
Tipkind p_tipkind1 = context.Tipkinds.FirstOrDefault(x => x.Id == p_tipkindContractor);
Tipkind p_tipkind2 = context.Tipkinds.FirstOrDefault(x => x.Id == p_tipkindInsured);
Policy ac = new Policy();
ac.Contractor = new List <Contractor>();
ac.Insurers = new List <Insured>();
ac.Beneficiaries = new List <Beneficiary>();
ac.Vehicles = new List <Vehicle>();
ac.DateSale = DateTime.Now;
ac.FromDate = policy.FromDate;
ac.ToDate = policy.ToDate;
ac.Moment = DateTime.Now;
ac.Premium = policy.Premium;
ac.DDV = policy.DDV;
ac.Premiumtotal = policy.Premium + policy.DDV;
Contractor acc = new Contractor();
acc.Tipkind = p_tipkind1.Id.ToString();
acc.Name = policy.ContractorName;
acc.Surname = policy.ContractorSurname;
acc.EMBG = policy.ContractorEMBG;
acc.Regnumber = policy.ContractorRegnumber;
acc.Phone = policy.ContractorPhone;
acc.Fax = policy.ContractorFax;
ac.Contractor.Add(acc);
Insured accc = new Insured();
accc.Tipkind = p_tipkind2.Id.ToString();
accc.Name = policy.InsuredName;
accc.Surname = policy.InsuredSurname;
accc.EMBG = policy.InsuredEMBG;
accc.Regnumber = policy.InsuredRegnumber;
accc.Phone = policy.InsuredPhone;
accc.Fax = policy.InsuredFax;
ac.Insurers.Add(accc);
Vehicle acccc = new Vehicle();
acccc.TypeVehicle = policy.VehicleTypeVehicle;
acccc.Regnumber = policy.VehicleRegnumber;
acccc.Chassis = policy.VehicleChassis;
acccc.MotorNum = policy.VehicleMotorNum;
acccc.Power = policy.VehiclePower;
acccc.Capacity = policy.VehicleCapacity;
acccc.Color = policy.VehicleColor;
acccc.SeetsNum = policy.VehicleSeetsNum;
ac.Vehicles.Add(acccc);
if (typepolicy == 200)
{
int p_package = Convert.ToInt32(package);
Guid p_fransh = Guid.Parse(franshiza);
Package p_pckg = context.Packages.FirstOrDefault(x => x.Id == p_package);
Franshiza p_f = context.Franshizas.FirstOrDefault(x => x.Id == p_fransh);
ac.Package = p_pckg.Id.ToString();
ac.Franshiza = p_f.Id.ToString();
}
if (typepolicy == 201)
{
}
context.Policies.Add(ac);
try
{
context.SaveChanges();
policyID = ac.ID.ToString();
return(true);
}
catch (Exception ex)
{
return(false);
}
#region allcode
//ValidatePolicy(policy);
#region ConvertPackageFranshTipKind
#endregion
#region ContextFirstOrDefault
#endregion
#region PolicyModel
//Policy p = new Policy();
//p.Contractor = new List<Contractor>();
//p.Insurers = new List<Insured>();
//p.Beneficiaries = new List<Beneficiary>();
//p.Vehicles = new List<Vehicle>();
//p.Package = p_pckg.Id.ToString();
//p.Franshiza = p_f.Id.ToString();
//p.Moment = DateTime.Now;
//p.DateSale = DateTime.Now;
//p.FromDate = policy.FromDate;
//p.ToDate = policy.ToDate;
//p.Premium = policy.Premium;
//p.DDV = policy.DDV;
//p.Premiumtotal = policy.Premium + policy.DDV;
#endregion
//Dogovarac(toj sto gi dava parite)
#region ContractorModel
//Contractor c = new Contractor();
//c.Tipkind = p_tipkind1.Id.ToString();
//c.Name = policy.ContractorName;
//c.Surname = policy.ContractorSurname;
//c.EMBG = policy.ContractorEMBG;
//c.Regnumber = policy.ContractorRegnumber;
//c.Phone = policy.ContractorPhone;
//c.Fax = policy.ContractorFax;
//p.Contractor.Add(c);
#endregion
//Osigurenik(toj sto e pokrien so polisata)
#region InsuredModel
//Insured i = new Insured();
//i.Tipkind = p_tipkind2.Id.ToString();
//i.Name = policy.InsuredName;
//i.Surname = policy.InsuredSurname;
//i.EMBG = policy.InsuredEMBG;
//i.Regnumber = policy.InsuredRegnumber;
//i.Phone = policy.InsuredPhone;
//i.Fax = policy.InsuredFax;
//p.Insurers.Add(i);
#endregion
//Korisnik na sredstva(toj gi zema parite)
#region BeneficiaryModel
//Beneficiary b = new Beneficiary();
//b.Name = policy.BeneficiaryName;
//b.Surname = policy.BeneficiarySurname;
//b.EMBG = policy.BeneficiaryEMBG;
//b.Regnumber = policy.BeneficiaryRegnumber;
//b.Phone = policy.BeneficiaryPhone;
//b.Fax = policy.BeneficiaryEMBG;
//p.Beneficiaries.Add(b);
#endregion
#region VehicleModel
//Vehicle v = new Vehicle();
//v.TypeVehicle = policy.VehicleTypeVehicle;
//v.Regnumber = policy.VehicleRegnumber;
//v.Chassis = policy.VehicleChassis;
//v.MotorNum = policy.VehicleMotorNum;
//v.Power = policy.VehiclePower;
//v.Capacity = policy.VehicleCapacity;
//v.Color = policy.VehicleColor;
//v.SeetsNum = policy.VehicleSeetsNum;
//p.Vehicles.Add(v);
#endregion
//Calculations
//#region Calculations
//decimal CapacityDec =Convert.ToDecimal(v.Capacity);
//p.SumOsig = CapacityDec;
#region SaveData
//context.Policies.Add(p);
//try
//{
// context.SaveChanges();
// policyID = p.ID.ToString();
// return true;
//}
//catch (Exception ex)
//{
// return false;
//}
#endregion
#endregion
}
public CreateEventForm(GraphClient client, Insured insured)
{
this.insured = insured;
this.client = client;
InitializeComponent();
}
public int SaveInsured(Insured insured)
{
return(dalInsured.SaveInsured(insured));
}
public void ShouldReturnTrueWhenIsValid(int age)
{
var insured = new Insured(age, _name, _document);
Assert.IsTrue(insured.Valid);
}
public void ShouldReturnTrueWhenNotIsValid(int Age)
{
var insured = new Insured(Age, _name, _document);
Assert.IsTrue(insured.Invalid);
}
