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