public IHttpActionResult PostInsurances(Insurances insurances)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Insurances.Add(insurances);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (InsurancesExists(insurances.InsurancesId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = insurances.InsurancesId }, insurances));
}
//Edit
public ActionResult EditIinsurance(Insurances insurance)
{
if (ModelState.IsValid)
{
db.Entry(insurance).State = EntityState.Modified;
var stdata = db.SummaryTable.Find(insurance.STID);
if (insurance.PurchaseOrWithdraw == true)
{
stdata.TradeDate = insurance.PurchaseDate;
var arr = db.CashExpense.Where(C => C.OID == insurance.STID).Select(C => C).SingleOrDefault();
arr.ExAmount = insurance.CashFlow;
arr.ExDate = insurance.PurchaseDate;
}
else
{
stdata.TradeDate = insurance.WithdrawDate;
var arr = db.CashIncome.Where(C => C.OID == insurance.STID).Select(C => C).SingleOrDefault();
arr.InAmount = -insurance.CashFlow;
arr.InDate = insurance.PurchaseDate;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(insurance));
}
public static Client getClient1()
{
//var dataClient = new ClientData();
//dataClient.BirthDate = new DateTime(2017, 1, 18);
//dataClient.PeselNumber = 92081992;
var isurances = new Insurances();
//List<RealEstateInsurance> realEstateInsurancesList = new List<RealEstateInsurance>
//{
// new RealEstateInsurance
// {
// NumberOfFloors=4,
// HasBasement=true,
// Adress="TestAdress"
// },
// new RealEstateInsurance
// {
// NumberOfFloors=5,
// HasBasement=false,
// Adress="TestAdress2"
// }
//};
// isurances.RealEstateInsurance = realEstateInsurancesList;
var testClient = new Client();
testClient.FirstName = "TestName1";
testClient.SecondName = "TestSecondName1";
// testClient.ClientData = dataClient;
testClient.Insurances = isurances;
return(testClient);
}
public void CreateClient(string firstName, string secondName, DateTime?dayOfBirth, int peselNumber, int id)
{
var dataClient = new ClientData
{
BirthDate = dayOfBirth,
PeselNumber = peselNumber,
};
var isurances = new Insurances();
var clientToAdd = new Client
{
FirstName = firstName,
SecondName = secondName,
ClientData = dataClient,
Insurances = isurances,
ClientId = id,
};
var request = new RestRequest("api/Clients", Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(clientToAdd);
restClient.Execute(request);
}
public static List <RealEstateInsurance> getRealEstateInsurance(Insurances insurance)
{
List <RealEstateInsurance> realEstateInsurancesList = new List <RealEstateInsurance>
{
new RealEstateInsurance
{
NumberOfFloors = 5,
HasBasement = true,
Adress = "TestAdress1",
InsurancesId = 4,
ConstructionDate = new DateTime(2017, 1, 18),
StartDate = new DateTime(2017, 1, 18),
FinishDate = new DateTime(2017, 1, 18),
Insurances = insurance,
},
new RealEstateInsurance
{
NumberOfFloors = 5,
HasBasement = false,
Adress = "TestAdress2",
ConstructionDate = new DateTime(2016, 1, 18),
StartDate = new DateTime(2016, 1, 18),
FinishDate = new DateTime(2016, 1, 18),
}
};
return(realEstateInsurancesList);
}
public override IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
if (DateOfBirth < DateTime.Now.AddYears(-Constants.MaxAgeInsuree) || DateOfBirth > DateTime.Now)
{
yield return
(new ValidationResult(
$"Invalid range for date of birth; must be between {0} and {Constants.MaxAgeInsuree} years.",
new[] { "DateOfBirth" }));
}
foreach (var validationResult in Addresses.Validate())
{
yield return(validationResult);
}
foreach (var validationResult in EmailAddresses.Validate())
{
yield return(validationResult);
}
foreach (var validationResult in PhoneNumbers.Validate())
{
yield return(validationResult);
}
foreach (var validationResult in Insurances.Validate())
{
yield return(validationResult);
}
}
public IHttpActionResult PutInsurances(int id, Insurances insurances)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != insurances.InsurancesId)
{
return(BadRequest());
}
db.Entry(insurances).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!InsurancesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <ActionResult <Insurances> > Update([FromBody] Insurances _Insurances)
{
Insurances _Insurancesq = _Insurances;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_Insurancesq = await(from c in _context.Insurances
.Where(q => q.InsurancesId == _Insurances.InsurancesId)
select c
).FirstOrDefaultAsync();
_context.Entry(_Insurancesq).CurrentValues.SetValues((_Insurances));
//_context.Alert.Update(_Alertq);
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _Insurances.InsurancesId,
DocType = "Insurances",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_Insurancesq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_Insurances, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Actualizar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _Insurances.CreatedUser,
UsuarioModificacion = _Insurances.ModifiedUser,
UsuarioEjecucion = _Insurances.ModifiedUser,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
// return BadRequest($"Ocurrio un error:{ex.Message}");
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_Insurancesq)));
}
public ActionResult Withdraw(Insurances insurances)
{
if (Session["User"] == null)
{
return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" }));
}
Insurances olddata = db.Insurances.Find(insurances.SerialNumber);
olddata.Withdrawed = true;
db.SaveChanges();
insurances.CashFlow = insurances.Withdrawal;
insurances.PurchaseOrWithdraw = false;
insurances.Withdrawed = true;
insurances.RelateCash = true;
insurances.UserID = Session["User"].ToString();
SummaryTable ST = new SummaryTable {
TradeType = "保險", TradeDate = insurances.WithdrawDate, UserName = insurances.UserID
};
db.SummaryTable.Add(ST);
db.SaveChanges();
var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault();
insurances.STID = id;
db.Insurances.Add(insurances);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
Insurances insurances = db.Insurances.Find(id);
db.Insurances.Remove(insurances);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static Insurances getInsurances()
{
var isurances = new Insurances();
isurances.RealEstateInsurance = getRealEstateInsurance(isurances);
return(isurances);
}
public Insuree()
{
Addresses = new Addresses();
EmailAddresses = new EmailAddresses();
PhoneNumbers = new PhoneNumbers();
Insurances = new Insurances();
}
public ActionResult Withdraw(Insurances insurances)
{
insurances.CashFlow = insurances.Withdrawal;
insurances.PurchaseOrWithdraw = false;
//insurances.UserID = Session["User"].ToString();
db.Insurances.Add(insurances);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//Delete
public ActionResult DeleteInsurances(int?id)
{
Insurances obj = db.Insurances.Find(id);
var STdata = db.SummaryTable.Where(c => c.STId == obj.STID).Select(c => c).SingleOrDefault();
db.SummaryTable.Remove(STdata);
db.Insurances.Remove(obj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SerialNumber,UserID,InsuranceName,PurchaseDate,WithdrawDate,PaymentPerYear,PayYear,PurchaseOrWithdraw,CashFlow,Withdrawal")] Insurances insurances)
{
if (ModelState.IsValid)
{
db.Entry(insurances).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(insurances));
}
//Edit
public ActionResult EditIinsurance(Insurances insurance)
{
if (ModelState.IsValid)
{
db.Entry(insurance).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(insurance));
}
//private static void GetProviders(List<Filter> filters)
//{
// Task<DocumentSearchResult<AzureSearchProviderRequestedFields>> task = Providers.GetProviders(0, 25, null, filters, false, false);
// task.Wait();
//}
private static void GetSuggestions(string searchTerm)
{
List <Task <List <SuggestionResponse> > > tasks = new List <Task <List <SuggestionResponse> > >(4);
tasks.Add(Conditions.GetSuggestions(searchTerm)); //13K condition entries. (1.6MB) Kick it off first.
tasks.Add(Names.GetSuggestions(searchTerm)); //4K name entries. (0.6MB)
tasks.Add(Specialties.GetSuggestions(searchTerm)); //2K specialty entries. (0.4MB)
tasks.Add(Insurances.GetSuggestions(searchTerm)); //0.1K insurance entries. (0.1MB)
Task.WaitAll(tasks.ToArray());
}
public IHttpActionResult GetInsurances(int id)
{
Insurances insurances = db.Insurances.Find(id);
if (insurances == null)
{
return(NotFound());
}
return(Ok(insurances));
}
public CaseInsurance GetActiveInsuranceAtDate(DateTime refDate)
{
var insurances =
Insurances
.Where(x =>
x.DatePlanEffective.GetValueOrDefault(DateTime.MinValue) <= refDate &&
x.DatePlanTerminated.GetValueOrDefault(DateTime.MaxValue) >= refDate)
.OrderBy(x => x.DatePlanTerminated)
.OrderByDescending(x => x.DatePlanEffective)
.ToList();
return(insurances.FirstOrDefault());
}
public List <CaseInsurance> GetActiveInsurance(DateTime StartDate, DateTime EndDate)
{
var insurances =
Insurances
.Where(x =>
x.DatePlanEffective.GetValueOrDefault(DateTime.MinValue) <= EndDate &&
x.DatePlanTerminated.GetValueOrDefault(DateTime.MaxValue) >= StartDate)
.OrderBy(x => x.DatePlanTerminated)
.OrderByDescending(x => x.DatePlanEffective)
.ToList();
return(insurances);
}
public IHttpActionResult DeleteInsurances(int id)
{
Insurances insurances = db.Insurances.Find(id);
if (insurances == null)
{
return(NotFound());
}
db.Insurances.Remove(insurances);
db.SaveChanges();
return(Ok(insurances));
}
//解約
public ActionResult Withdraw(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Insurances insurances = db.Insurances.Find(id);
if (insurances == null)
{
return(HttpNotFound());
}
return(View(insurances));
}
public ActionResult Create([Bind(Include = "SerialNumber,UserID,InsuranceName,PurchaseDate,WithdrawDate,PaymentPerYear,PayYear,PurchaseOrWithdraw,CashFlow,Withdrawal")] Insurances insurances)
{
insurances.CashFlow = -insurances.PaymentPerYear * insurances.PayYear;
insurances.PurchaseOrWithdraw = true;
insurances.Withdrawed = false;
//insurances.UserID = Session["User"].ToString();
if (ModelState.IsValid)
{
db.Insurances.Add(insurances);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(insurances));
}
public async Task <IActionResult> GetInsurancesById(Int64 InsurancesId)
{
Insurances Items = new Insurances();
try
{
Items = await _context.Insurances.Where(q => q.InsurancesId == InsurancesId).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public ActionResult Create([Bind(Include = "SerialNumber,UserID,InsuranceName,PurchaseDate,WithdrawDate,PaymentPerYear,PayYear,PurchaseOrWithdraw,CashFlow,Withdrawal,RelateCash")] Insurances insurances)
{
if (insurances.RelateCash == true)
{
insurances.CashFlow = -insurances.PaymentPerYear * insurances.PayYear;
}
else
{
insurances.CashFlow = 0;
}
insurances.PurchaseOrWithdraw = true;
insurances.Withdrawed = false;
//insurances.UserID = Session["User"].ToString();
if (ModelState.IsValid)
{
insurances.UserID = Session["User"].ToString();
SummaryTable ST = new SummaryTable {
TradeType = "保險", TradeDate = insurances.PurchaseDate, UserName = insurances.UserID
};
db.SummaryTable.Add(ST);
db.SaveChanges();
var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault();
insurances.STID = id;
db.Insurances.Add(insurances);
db.SaveChanges();
CashExpense CE = new CashExpense();
CE.ExAmount = -insurances.CashFlow;
CE.UserName = insurances.UserID;
CE.ExDate = ST.TradeDate;
CE.ExCashType = ST.TradeType;
CE.OID = id;
db.CashExpense.Add(CE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(insurances));
}
public async Task <IActionResult> Delete([FromBody] Insurances _Insurances)
{
Insurances _Insurancesq = new Insurances();
try
{
_Insurancesq = _context.Insurances
.Where(x => x.InsurancesId == (Int64)_Insurances.InsurancesId)
.FirstOrDefault();
_context.Insurances.Remove(_Insurancesq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_Insurancesq)));
}
//Delete
public ActionResult DeleteInsurances(int?id)
{
Insurances obj = db.Insurances.Find(id);
var STdata = db.SummaryTable.ToList().Where(c => c.STId == obj.STID).Select(c => c).SingleOrDefault();
var STID = obj.STID;
var RelateCash = obj.RelateCash;
db.Insurances.Remove(obj);
if (obj.PurchaseOrWithdraw == true)
{
if (RelateCash == true)
{
var arr = db.CashExpense.Where(C => C.OID == STID).Select(C => C).SingleOrDefault();
db.CashExpense.Remove(arr);
}
if (RelateCash == false)
{
db.SummaryTable.Remove(STdata);
}
}
else
{
if (RelateCash == true)
{
var arr = db.CashIncome.Where(C => C.OID == STID).Select(C => C).SingleOrDefault();
db.CashIncome.Remove(arr);
}
else
{
db.SummaryTable.Remove(STdata);
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "SerialNumber,UserID,InsuranceName,PurchaseDate,WithdrawDate,PaymentPerYear,PayYear,PurchaseOrWithdraw,CashFlow,Withdrawal,RelateCash")] Insurances insurances)
{
if (ModelState.IsValid)
{
insurances.UserID = Session["User"].ToString();
insurances.PurchaseOrWithdraw = true;
insurances.Withdrawed = false;
SummaryTable ST = new SummaryTable
{
TradeType = "保險",
TradeDate = insurances.PurchaseDate,
UserName = insurances.UserID
};
string UID = Session["User"].ToString();
var ExSUM = db.CashExpense.Where(C => C.UserName == UID).Sum(C => C.ExAmount);
var InSUM = db.CashIncome.Where(C => C.UserName == UID).Sum(C => C.InAmount);
if (insurances.RelateCash == true && InSUM - ExSUM > insurances.PaymentPerYear * insurances.PayYear)
{
db.SummaryTable.Add(ST);
db.SaveChanges();
var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault();
insurances.STID = id;
insurances.CashFlow = -insurances.PaymentPerYear * insurances.PayYear;
db.Insurances.Add(insurances);
db.SaveChanges();
CashExpense CE = new CashExpense
{
ExAmount = -insurances.CashFlow,
UserName = insurances.UserID,
ExDate = ST.TradeDate,
ExCashType = ST.TradeType,
OID = id,
ExNote = insurances.InsuranceName + "支出"
};
db.CashExpense.Add(CE);
var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault();
User.InsuranceValue += insurances.Withdrawal;
User.CashValue -= insurances.PaymentPerYear * insurances.PayYear;
db.SaveChanges();
}
else
{
db.SummaryTable.Add(ST);
db.SaveChanges();
var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault();
insurances.STID = id;
insurances.CashFlow = 0;
db.Insurances.Add(insurances);
db.SaveChanges();
var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault();
User.InsuranceValue += insurances.Withdrawal;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(insurances));
}
public People getPersonHealth(short keyfield)
{
People p = new People();
using (SqlConnection conn = new SqlConnection(DBConnect.GetSchoolConnStr()))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "uspGetPersonHealth";
cmd.Parameters.Add("@keyfield", SqlDbType.SmallInt).Value = keyfield;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Allergies a = new Allergies();
a.Keyfield = DbUtilities.GetShort(rdr, "KeyField");
a.allergyDescription = rdr["Description"].ToString();
p.Allergies.Add(a);
}
rdr.NextResult();
if (rdr.HasRows)
{
while (rdr.Read())
{
Insurances i = new Insurances();
i.keyfield = DbUtilities.GetShort(rdr, "keyfield");
i.InsuranceCo = rdr["InsuranceCo"].ToString();
i.PolicyNum = rdr["PolicyNum"].ToString();
i.SubscriberName = rdr["SubscriberName"].ToString();
i.SubscriberNum = rdr["SubscriberNum"].ToString();
i.SubscriberEmployer = rdr["SubscriberEmployer"].ToString();
i.SubscriberJob = rdr["SubscriberJob"].ToString();
i.SubscriberWorkPhone = rdr["SubscriberWorkPhone"].ToString();
p.Insurances.Add(i);
}
}
rdr.NextResult();
if (rdr.HasRows)
{
while (rdr.Read())
{
MedHist mh = new MedHist();
mh.keyfield = DbUtilities.GetShort(rdr, "KeyField");
mh.HealthCondition = DbUtilities.GetByte(rdr, "HealthCondition");
mh.ConditionExplanation = rdr["ConditionExplanation"].ToString();
mh.HealthTreatment = rdr["HealthTreatment"].ToString();
mh.HasAsthma = DbUtilities.GetBool(rdr, "HasAsthma");
mh.HasSinusitis = DbUtilities.GetBool(rdr, "HasSinusitis");
mh.HasBronchitis = DbUtilities.GetBool(rdr, "HasBronchitis");
mh.HasKidneyTrouble = DbUtilities.GetBool(rdr, "HasKidneyTrouble");
mh.HasHeartTrouble = DbUtilities.GetBool(rdr, "HasHeartTrouble");
mh.HasDiabetes = DbUtilities.GetBool(rdr, "HasDiabetes");
mh.HasDizziness = DbUtilities.GetBool(rdr, "HasDizziness");
mh.HasStomachUpset = DbUtilities.GetBool(rdr, "HasStomachUpset");
mh.HasHayFever = DbUtilities.GetBool(rdr, "HasHayFever");
mh.Explanation = rdr["Explanation"].ToString();
mh.PastOperationsOrIllnesses = rdr["PastOperationsOrIllnesses"].ToString();
mh.CurrentMeds = rdr["CurrentMeds"].ToString();
mh.SpecialDietOrNeeds = rdr["SpecialDietOrNeeds"].ToString();
mh.HadChickenPox = DbUtilities.GetBool(rdr, "HadChickenPox");
mh.HadMeasles = DbUtilities.GetBool(rdr, "HadMeasles");
mh.HadMumps = DbUtilities.GetBool(rdr, "HadMumps");
mh.HadWhoopingCough = DbUtilities.GetBool(rdr, "HadWhoopingCough");
mh.OtherChildhoodDiseases = rdr["OtherChildhoodDiseases"].ToString();
mh.DateOfTetanusShot = DbUtilities.GetDateTime(rdr, "DateOfTetanusShot");
mh.FamilyDoctor = rdr["FamilyDoctor"].ToString();
mh.FamilyDoctorPhone = rdr["FamilyDoctorPhone"].ToString();
p.MedHist.Add(mh);
}
}
}
return(p);
}
}
public ActionResult Withdraw(Insurances insurances)
{
if (Session["User"] == null)
{
return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" }));
}
if (ModelState.IsValid)
{
SummaryTable ST = new SummaryTable
{
TradeType = "保險",
TradeDate = insurances.WithdrawDate,
UserName = Session["User"].ToString()
};
Insurances olddata = db.Insurances.Find(insurances.SerialNumber);
olddata.Withdrawed = true;
db.SaveChanges();
insurances.PurchaseOrWithdraw = false;
insurances.Withdrawed = true;
insurances.UserID = Session["User"].ToString();
if (insurances.RelateCash == true)
{
insurances.CashFlow = insurances.Withdrawal;
db.SummaryTable.Add(ST);
db.SaveChanges();
var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault();
insurances.STID = id;
db.Insurances.Add(insurances);
db.SaveChanges();
var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault();
User.InsuranceValue -= insurances.Withdrawal;
User.CashValue += insurances.Withdrawal;
db.SaveChanges();
CashIncome CI = new CashIncome
{
OID = id,
UserName = insurances.UserID,
InCashType = "保險",
InAmount = insurances.CashFlow,
InDate = insurances.WithdrawDate,
InNote = insurances.InsuranceName + "解約金"
};
db.CashIncome.Add(CI);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
insurances.CashFlow = 0;
db.SummaryTable.Add(ST);
db.SaveChanges();
var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault();
insurances.STID = id;
db.Insurances.Add(insurances);
db.SaveChanges();
var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault();
User.InsuranceValue -= insurances.Withdrawal;
User.CashValue += insurances.Withdrawal;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(insurances));
}
