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); }