internal void AddBeneficiaryContractToDB(Beneficiarycontract beneficiarycontract) { IMongoCollection <Beneficiarycontract> benecontractcollection = dBContext.Database.GetCollection <Beneficiarycontract>("BeneficiariesContracts"); modifiedDocumentManager.AddIDtoString(beneficiarycontract._id); benecontractcollection.InsertOne(beneficiarycontract); }
internal void UpdateBeneficiaryContract(Beneficiarycontract contractupdate, string id) { IMongoCollection <Beneficiarycontract> benecontractcollection = dBContext.Database.GetCollection <Beneficiarycontract>("BeneficiariesContracts"); var filter = Builders <Beneficiarycontract> .Filter.Eq("_id", id); contractupdate._id = id; modifiedDocumentManager.AddIDtoString(id); benecontractcollection.FindOneAndReplace(filter, contractupdate); }
internal Beneficiarycontract GetBeneficiaryContract(string id) { IMongoCollection <Beneficiarycontract> benecontractcollection = dBContext.Database.GetCollection <Beneficiarycontract>("BeneficiariesContracts"); var filter = Builders <Beneficiarycontract> .Filter.Eq("_id", id); Beneficiarycontract returnBeneficiaryContract = benecontractcollection.Find(filter).FirstOrDefault(); return(returnBeneficiaryContract); }
public ActionResult Create(Beneficiarycontract benenficiarycontract, string idofbeneficiary) { try { try { if (ModelState.IsValid) { Beneficiary beneficiary = beneficiaryManager.GetOneBeneficiary(idofbeneficiary); benenficiarycontract._id = Guid.NewGuid().ToString(); benenficiarycontract.ExpirationDate = benenficiarycontract.ExpirationDate.AddDays(1); benenficiarycontract.RegistrationDate = benenficiarycontract.RegistrationDate.AddDays(1); benenficiarycontract.Birthdate = beneficiary.PersonalInfo.Birthdate; benenficiarycontract.Fullname = beneficiary.Fullname; benenficiarycontract.CNP = beneficiary.CNP; benenficiarycontract.CIinfo = beneficiary.CI.CIinfo; benenficiarycontract.Nrtel = beneficiary.PersonalInfo.PhoneNumber; benenficiarycontract.NumberOfPortion = beneficiary.NumberOfPortions.ToString(); benenficiarycontract.IdApplication = beneficiary.Marca.IdAplication; benenficiarycontract.IdInvestigation = beneficiary.Marca.IdInvestigation; benenficiarycontract.Address = beneficiary.Adress; benenficiarycontract.OwnerID = idofbeneficiary; beneficiaryContractManager.AddBeneficiaryContractToDB(benenficiarycontract); return(RedirectToAction("Index", new { idofbeneficiary })); } } catch { ModelState.AddModelError("", "Unable to save changes! "); } return(View(benenficiarycontract)); } catch { return(RedirectToAction("Localserver", "Home")); } }
public static List <Beneficiarycontract> GetBeneficiaryContractsFromCsv(List <string[]> beneficiaryasstring, List <Beneficiary> beneficiarycollection, List <Beneficiarycontract> beneficiarycontractcollection) { List <Beneficiarycontract> to_be_inseted = new List <Beneficiarycontract>(); foreach (var details in beneficiaryasstring) { if (details[9] != null || details[9] != "") { if (details[15] != "" && details[16] != "") { var results = from b in beneficiarycollection where b.CNP == details[9] select b; string numberOfRegistration = ReturnRegistrationNumber(details[15]); if (beneficiarycontractcollection.Count(z => z.NumberOfRegistration == numberOfRegistration) != 0) { } else { foreach (var b in results) { Beneficiarycontract beneficiarycontract = new Beneficiarycontract { Fullname = b.Fullname, Address = b.Adress, OwnerID = b._id, Birthdate = b.PersonalInfo.Birthdate, CIinfo = b.CI.CIinfo, CNP = b.CNP, IdApplication = b.Marca.IdAplication, IdInvestigation = b.Marca.IdInvestigation, Nrtel = b.PersonalInfo.PhoneNumber, NumberOfPortion = b.NumberOfPortions.ToString(), NumberOfRegistration = ReturnRegistrationNumber(details[15]), RegistrationDate = DateTime.MinValue, ExpirationDate = DateTime.MinValue }; try { string[] splitDates = details[16].Split('-'); string[] forRegistrtionDate = splitDates[0].Split('.'); string forRegistrationDate = forRegistrtionDate[2] + "-" + forRegistrtionDate[1] + "-" + forRegistrtionDate[0]; DateTime data = DateTime.ParseExact(forRegistrationDate, "yy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); beneficiarycontract.RegistrationDate = data.AddDays(1); string[] forexpirationDate = splitDates[1].Split('.'); string forExpirationDate = forRegistrtionDate[2] + "-" + forRegistrtionDate[1] + "-" + forRegistrtionDate[0]; DateTime data_ = DateTime.ParseExact(forRegistrationDate, "yy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); beneficiarycontract.ExpirationDate = data_.AddDays(1); } catch { string[] splitDates = details[16].Split('-'); string[] forRegistrtionDate = splitDates[0].Split('.'); string forRegistrationDate = forRegistrtionDate[2] + "-" + forRegistrtionDate[1] + "-" + forRegistrtionDate[0]; DateTime data = Convert.ToDateTime(forRegistrationDate); beneficiarycontract.RegistrationDate = data.AddDays(1); string[] forexpirationDate = splitDates[1].Split('.'); string forExpirationDate = forRegistrtionDate[2] + "-" + forRegistrtionDate[1] + "-" + forRegistrtionDate[0]; DateTime data_ = Convert.ToDateTime(forRegistrationDate); beneficiarycontract.ExpirationDate = data_.AddDays(1); } to_be_inseted.Add(beneficiarycontract); } } } } } return(to_be_inseted); }