public RateInsurance(Insurance insur)
{
this.InitializeComponent();
this.DataContext = this;
providerName = insur.Provider;
}
private async Task generateInsuranceNotification(Insurance insurance)
{
var notification = NotificationFactory.CreateNewInsuranceNotification(
Guid.NewGuid().ToString(), "systemAccount", insurance.Data.AccountId,
insurance.Data.Type, false, insurance.Data.ValidFrom, insurance.Data.ValidTo);
await notifications.AddObject(notification);
}
protected override void SeedDataBody(TContext context)
{
Console.WriteLine("Seeding database with RandomInsuranceSeeder");
var rate = _randomGenerator.RandomRate();
var code = _randomGenerator.RandomString();
var provider = new Provider
{
ProviderRate = rate,
ProviderCode = $"P_{code}",
Insurances = new List <Insurance>()
};
var insurance = new Insurance
{
InsuranceProvider = provider,
InsuranceCode = $"I_{code}",
Enabled = true
};
provider.Insurances.Add(insurance);
context.Providers.Add(provider);
context.Insurances.Add(insurance);
context.SaveChanges();
}
public bool AssignInsurance(int customerId, int insuranceId)
{
IList <CustomerInsurance> existingItems = _customerInsurancesList
.Where(ci => ci.CustomerID == customerId)
.Where(ci => ci.InsuranceID == insuranceId).ToList();
if (existingItems.Count == 0)
{
Customer customer = _customersList.FirstOrDefault(c => (c.Id == customerId));
Insurance insurance = _insurancesList.FirstOrDefault(i => (i.Id == insuranceId));
if (customer != null || insurance != null)
{
var customerInsurance = new CustomerInsurance()
{
Customer = customer,
Insurance = insurance,
};
customer.CustomerInsurances.Add(customerInsurance);
return(true);
}
}
return(false);
}
public bool UpdateInsurance(Insurance insurance)
{
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(UpdateInsuranceSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@CompanyId", System.Data.SqlDbType.Int);
cmd.Parameters["@CompanyId"].Value = insurance.CompanyId;
cmd.Parameters.Add("@InsuranceName", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsuranceName"].Value = insurance.InsuranceName;
cmd.Parameters.Add("@InsuranceAddress", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsuranceAddress"].Value = insurance.InsuranceAddress;
cmd.Parameters.Add("@InsurancePhone", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsurancePhone"].Value = insurance.InsurancePhone;
cmd.Parameters.Add("@InsurnaceWebSite", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsurnaceWebSite"].Value = insurance.InsuranceWebsite;
return(cmd.ExecuteNonQuery() > 0);
}
}
}
public Insurance GetInsurance(int insuranceId)//
{
Insurance insurance = null;
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(GetInsuranceByIdSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@InsuranceId", System.Data.SqlDbType.Int);
cmd.Parameters["@InsuranceId"].Value = insuranceId;
using (var myReader = cmd.ExecuteReader())
{
try
{
if (myReader.HasRows)
{
myReader.Read();
insurance = new Insurance(myReader);
}
}
catch (Exception ex)
{
// TODO Logg Error here
}
}
}
}
return(insurance);
}
internal void DeteleInsurance(Guid id)
{
Insurance cInsurance = Context.Insurance.FirstOrDefault(x => x.Id == id);
Context.Insurance.Remove(cInsurance);
Context.SaveChanges();
}
public bool AddInsurance(Insurance insurance)//
{
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(AddInsuranceSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@CompanyId", System.Data.SqlDbType.Int);
cmd.Parameters["@CompanyId"].Value = insurance.CompanyId;
cmd.Parameters.Add("@InsuranceName", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsuranceName"].Value = insurance.InsuranceName;
cmd.Parameters.Add("@InsuranceAddress", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsuranceAddress"].Value = insurance.InsuranceAddress;
cmd.Parameters.Add("@InsurancePhone", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsurancePhone"].Value = insurance.InsurancePhone;
cmd.Parameters.Add("@InsuranceWebsite", System.Data.SqlDbType.VarChar);
cmd.Parameters["@InsuranceWebsite"].Value = insurance.InsuranceWebsite;
//cmd.Parameters.Add("@CreatedBy", System.Data.SqlDbType.Int);
//cmd.Parameters["@CreatedBy"].Value = insurance.CreatedBy;
//cmd.Parameters.Add("@CreatedDate", System.Data.SqlDbType.Int);
//cmd.Parameters["@CreatedDate"].Value = DateTime.UtcNow;
return(Convert.ToBoolean(cmd.ExecuteScalar()));
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
ctx = new AriClinicContext("AriClinicContext");
// security control, it must be a user logged
if (Session["User"] == null)
Response.Redirect("Default.aspx");
else
{
user = CntAriCli.GetUser((Session["User"] as User).UserId, ctx);
Process proc = (from p in ctx.Processes
where p.Code == "ser"
select p).FirstOrDefault<Process>();
per = CntAriCli.GetPermission(user.UserGroup, proc, ctx);
btnAccept.Visible = per.Modify;
}
//
if (Request.QueryString["InsuranceId"] != null)
{
insuranceId = Int32.Parse(Request.QueryString["InsuranceId"]);
ins = CntAriCli.GetInsurance(insuranceId, ctx);
txtInsurance.Text = ins.Name;
}
//
if (Request.QueryString["InsuranceServiceId"] != null)
{
insuranceServiceId = Int32.Parse(Request.QueryString["InsuranceServiceId"]);
inser = CntAriCli.GetInsuranceService(insuranceServiceId, ctx);
LoadData(inser);
}
}
private Insurance setInsurance(DataTable dt)
{
Insurance cus1 = new Insurance();
if (dt.Rows.Count > 0)
{
//stf1.staff_id = dt.Rows[0][insr.staff_id].ToString();
cus1.insu_id = dt.Rows[0][insr.insu_id].ToString();
cus1.insu_code = dt.Rows[0][insr.insu_code].ToString();
cus1.insu_name_t = dt.Rows[0][insr.insu_name_t].ToString();
cus1.insu_name_e = dt.Rows[0][insr.insu_name_e].ToString();
cus1.active = dt.Rows[0][insr.active].ToString();
cus1.address_t = dt.Rows[0][insr.address_t].ToString();
cus1.address_e = dt.Rows[0][insr.address_e].ToString();
cus1.addr = dt.Rows[0][insr.addr].ToString();
cus1.amphur_id = dt.Rows[0][insr.amphur_id].ToString();
cus1.district_id = dt.Rows[0][insr.district_id].ToString();
cus1.province_id = dt.Rows[0][insr.province_id].ToString();
cus1.zipcode = dt.Rows[0][insr.zipcode].ToString();
cus1.sale_id = dt.Rows[0][insr.sale_id].ToString();
cus1.sale_name_t = dt.Rows[0][insr.sale_name_t].ToString();
cus1.fax = dt.Rows[0][insr.fax].ToString();
cus1.tele = dt.Rows[0][insr.tele].ToString();
cus1.email = dt.Rows[0][insr.email].ToString();
cus1.tax_id = dt.Rows[0][insr.tax_id].ToString();
cus1.remark = dt.Rows[0][insr.remark].ToString();
cus1.contact_name1 = dt.Rows[0][insr.contact_name1].ToString();
cus1.contact_name2 = dt.Rows[0][insr.contact_name2].ToString();
cus1.contact_name1_tel = dt.Rows[0][insr.contact_name1_tel].ToString();
cus1.contact_name2_tel = dt.Rows[0][insr.contact_name2_tel].ToString();
cus1.status_company = dt.Rows[0][insr.status_company].ToString();
cus1.status_vendor = dt.Rows[0][insr.status_vendor].ToString();
cus1.date_create = dt.Rows[0][insr.date_create].ToString();
cus1.date_modi = dt.Rows[0][insr.date_modi].ToString();
cus1.date_cancel = dt.Rows[0][insr.date_cancel].ToString();
cus1.user_create = dt.Rows[0][insr.user_create].ToString();
cus1.user_modi = dt.Rows[0][insr.user_modi].ToString();
cus1.user_cancel = dt.Rows[0][insr.user_cancel].ToString();
cus1.remark2 = dt.Rows[0][insr.remark2].ToString();
cus1.po_due_period = dt.Rows[0][insr.po_due_period].ToString();
cus1.taddr1 = dt.Rows[0][insr.taddr1].ToString();
cus1.taddr2 = dt.Rows[0][insr.taddr2].ToString();
cus1.taddr3 = dt.Rows[0][insr.taddr3].ToString();
cus1.taddr4 = dt.Rows[0][insr.taddr4].ToString();
cus1.eaddr1 = dt.Rows[0][insr.eaddr1].ToString();
cus1.eaddr2 = dt.Rows[0][insr.eaddr2].ToString();
cus1.eaddr3 = dt.Rows[0][insr.eaddr3].ToString();
cus1.eaddr4 = dt.Rows[0][insr.eaddr4].ToString();
}
return(cus1);
}
public ActionResult Index(Insurance objMotorModel)
{
string PolicyNo = objMotorModel.PolicyNo ?? "";
string CustCode = objMotorModel.CustomerCode ?? "";
string SourceCode = objMotorModel.SourceCode ?? "";
if (Session["UserName"] != null)
{
ViewBag.UserName = Session["UserName"].ToString();
}
if (Session["RoleId"] != null)
{
ViewBag.RoleId = Session["RoleId"];
}
DateTime PolicyFDate = objMotorModel.PolicyFromDate == Convert.ToDateTime("01-01-0001 12.00.00 AM") ? Convert.ToDateTime("01-01-1753 12.00.00 AM") : objMotorModel.PolicyFromDate;
DateTime PolicyTDate = objMotorModel.PolicyToDate == Convert.ToDateTime("01-01-0001 12.00.00 AM") ? Convert.ToDateTime("01-01-1753 12.00.00 AM") : objMotorModel.PolicyToDate;
List<Insurance> lst = new List<Insurance>();
if (!string.IsNullOrEmpty(PolicyNo) || DateValidation.isValidDate(PolicyFDate.Day, PolicyFDate.Month, PolicyFDate.Year)
|| !string.IsNullOrEmpty(CustCode) || !string.IsNullOrEmpty(SourceCode))
{
long returnCode = objMotorBAL.GetDelegateSearchData(PolicyNo, CustCode, SourceCode, PolicyFDate, PolicyTDate, out lst, 0, "");
}
return View(lst);
}
public IActionResult Post([FromBody] Insurance insurance)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var existingInsurance = (from a in _context.Insurance
where a.InsuranceProvider == insurance.InsuranceProvider &&
a.CustomerId == insurance.CustomerId
select a);
//if insurance exists, it won't create another
if (existingInsurance.Count <Insurance>() > 0)
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
_context.Insurance.Add(insurance);
try
{
_context.SaveChanges();
}
catch (DbUpdateException)
{
if (InsuranceExists(insurance.InsuranceId))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(Ok(insurance));
}
public IActionResult Put(int id, [FromBody] Insurance insurance)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != insurance.InsuranceId)
{
return(BadRequest());
}
_context.Entry(insurance).State = EntityState.Modified;
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!InsuranceExists(insurance.InsuranceId))
{
return(NotFound());
}
else
{
throw;
}
}
return(new StatusCodeResult(StatusCodes.Status204NoContent));
}
public void ReactiveObject_ForMultipleLevelNestedReactiveProperties_ComputesCorrectly()
{
var person = new Person {
Id = 0,
Age = 30,
Name = "John Doe",
Type = "VIP"
};
var personWrapper = new PersonWrapper
{
Person = person,
AdditionalRisk = 10
};
var personWrapperWrapper = new PersonWrapperWrapper {
PersonWrapper = personWrapper
};
var invoice = new Insurance {
Cost = R.Of(() => personWrapperWrapper.PersonWrapper.Person.Type == "VIP" ? personWrapper.Person.Age * 10 : personWrapper.Person.Age * 30 + personWrapper.AdditionalRisk)
};
Assert.AreEqual(person.Age * 10, invoice.Cost);
person.Age.Set(35);
Assert.AreEqual(person.Age * 10, invoice.Cost);
person.Type.Set("Regular");
Assert.AreEqual(personWrapper.Person.Age * 30 + personWrapper.AdditionalRisk, invoice.Cost);
}
public PatientAdmissionForm(Patient patient)
{
InitializeComponent();
using (WaitCursor wc = new WaitCursor())
{
this.patient = patient;
using (GmConnection conn = App.CreateConnection())
{
passport = patient.GetPassport(conn);
insurance = patient.GetInsurance(conn);
patientIdentification = patient.GetPatientIdentification(conn);
}
if (passport == null)
{
passport = new Passport();
}
if (insurance == null)
{
insurance = new Insurance();
}
if (patientIdentification == null)
{
patientIdentification = new PatientIdentification();
}
ucPassport.Init(passport);
ucInsurance.Init(insurance);
ucPatientIdentification.Init(patientIdentification);
ucPatientData.Init(patient);
ucPatientDescription.Init(patient.patientDescription);
ucPrescriptions.Init(patient);
ucDiagnoses.Init(patient);
ucAnalyses.Init(patient);
}
FormUtils.Init(this);
}
public ActionResult DeleteConfirmed(int id)
{
Insurance insurance = db.Insurances.Find(id);
db.Insurances.Remove(insurance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void CanSetTypeOfInsurance()
{
var insurance = new Insurance();
insurance.Type = InsuranceType.Php;
insurance.Type.ShouldBeEquivalentTo(InsuranceType.Php);
}
public void CanSetInsuranceNumberToInsurance()
{
var insurance = new Insurance();
insurance.InsuranceNumber = "12345";
insurance.InsuranceNumber.Should().Be("12345");
}
public void CanSetCancelledToInsurance()
{
var insurance = new Insurance();
insurance.Cancelled = true;
insurance.Cancelled.ShouldBeEquivalentTo(true);
}
public void CanSetEmployeeToInsurance()
{
var insurance = new Insurance();
insurance.Employee = "";
insurance.Employee.Should().NotBeNull();
}
public void CanSetLicensePlateToInsurance()
{
var insurance = new Insurance();
insurance.LicensePlate = "AB-ABC 123";
insurance.LicensePlate.ShouldBeEquivalentTo("AB-ABC 123");
}
public IActionResult DeleteConfirmed(int id)
{
Insurance insurance = _context.Insurances.Find(id);
_context.Insurances.Remove(insurance);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
public override global::System.Data.DataSet Clone()
{
Insurance cln = ((Insurance)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public IActionResult Add(int vehicleId)
{
Insurance insurance = new Insurance();
insurance.VehicleId = vehicleId;
insurance.Date = DateTime.Now;
return(View(insurance));
}
public static insuranceTypeDTO castToDTO(Insurance insuraneDAL)
{
return(new insuranceTypeDTO()
{
insuranceId = insuraneDAL.insuranceId,
insuranceName = insuraneDAL.insuranceName
});
}
private bool Validate(Insurance insurance)
{
if (insurance.Risk == Risks.Alto && insurance.CoverageAmt > 0.5)
{
return(false);
}
return(true);
}
public void EmployeesPermium()
{
var employees = EmployeesPermiumStub.Employees();
var result = Insurance.EmployeesPermium(employees);
Assert.IsTrue(result.Count == 2);
}
public void NoPermiumForEmployeeFound()
{
var employee = EmployeesPermiumStub.NoPermiumEmployee();
var result = Insurance.PermiumPicker(employee);
Assert.AreEqual(0, result);
}
public void CanSetContractDateOfInsurance()
{
var insurance = new Insurance();
insurance.ContractDate = DateTime.Today;
insurance.ContractDate.ShouldBeEquivalentTo(DateTime.Today);
}
public void CanSetInsurerToInsurance()
{
var insurance = new Insurance();
insurance.Company = InsuranceCompany.Vhv;
insurance.Company.ShouldBeEquivalentTo(InsuranceCompany.Vhv);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
if (int.TryParse(Request.QueryString["id"], out id))
{
insurance = InsuranceOperation.GetInsuranceById(id);
}
FormDataBind();
}
protected void btnCreate_Click(object sender, EventArgs e)
{
string strInsureWorth = Request.Form[txtInsureWorth.ID].Trim();
string strInsureCosts = Request.Form[txtInsureCosts.ID].Trim();
decimal insureWorth = 0;
if (string.IsNullOrEmpty(strInsureWorth) || !decimal.TryParse(strInsureWorth, out insureWorth))
{
lblMsg.Text = "投保价值不能为空，且只能为大于0的数字！";
return;
}
decimal insureCosts = 0;
if (string.IsNullOrEmpty(strInsureCosts) || !decimal.TryParse(strInsureCosts, out insureCosts))
{
lblMsg.Text = "报价费不能为空，且只能为大于0的数字！";
return;
}
if (insureCosts < 10)
{
insureCosts = 10;
}
if (insurance != null)
{
insurance.InsureWorth = insureWorth;
insurance.InsureCosts = insureCosts;
insurance.OrderDetailId = od.Id;
insurance.OrderId = id;
InsuranceOperation.UpdateInsurance(insurance);
}
else
{
insurance = new Insurance();
insurance.InsureWorth = insureWorth;
insurance.InsureCosts = insureCosts;
insurance.OrderDetailId = od.Id;
insurance.OrderId = id;
insurance.CreateTime = DateTime.Now;
insurance.CreateUserId = user.Id;
insurance.CarrierName = CarrierOperation.GetCarrierByEncode(od.CarrierEncode).Name;
insurance.ClientName = OrderOperation.GetOrderById(od.OrderId).Client.RealName;
InsuranceOperation.CreateInsurance(insurance);
}
Order order = OrderOperation.GetOrderById(od.OrderId);
order.Costs = order.Costs - od.TotalCosts;
od.TotalCosts = od.TotalCosts - od.InsureCosts + insureCosts;
od.InsureCosts = insureCosts;
OrderDetailOperation.UpdateOrderDetail(od);
order.Costs = order.Costs + od.TotalCosts;
OrderOperation.UpdateOrder(order);
Response.Write("<script language='javascript' type='text/javascript'>alert('提交成功！');location.href='AuditOrder.aspx?id="+od.OrderId+"';</script>");
}
protected void LoadData(Insurance ins)
{
txtInsuranceId.Text = ins.InsuranceId.ToString();
txtName.Text = ins.Name;
chkInternal.Checked = ins.Internal;
}
private void setInsDef(Insurance ins)
{
grdFee.DataSource = ins.InsuranceDefs;
insuranceBindingSource.DataSource = ins;
}
protected void UnloadData(Insurance ins)
{
ins.Name = txtName.Text;
ins.Internal = chkInternal.Checked;
}
private void clear(bool loadFromDB)
{
grdInsurance.CurrentRow = null;
Insurance ins = new Insurance();
ins.Context = DataLayer.GetContext();
ins.InsuranceDefs = new EntityCollection<InsuranceDef>();
Service[] srvs = DataLayer.GetServices(false);
for (int i = 0; i < srvs.Count(); i++)
{
InsuranceDef def = new InsuranceDef();
def.ServiceId = srvs[i].Id;
ins.InsuranceDefs.Add(def);
}
insuranceBindingSource.DataSource = ins;
txtInssuranceName.Focus();
btnAdd.Enabled = true;
}
protected bool CreateChange()
{
if (!DataOk())
return false;
if (inser == null)
{
inser = new InsuranceService();
UnloadData(inser);
ctx.Add(inser);
}
else
{
inser = CntAriCli.GetInsuranceService(insuranceServiceId, ctx);
ins = inser.Insurance;
UnloadData(inser);
}
ctx.SaveChanges();
return true;
}
protected void txtInsuranceServiceId_TextChanged(object sender, EventArgs e)
{
// check before go to search thats a policy selected
if (rdcbPolicy.SelectedValue == "")
{
lblMessage.Text = Resources.GeneralResource.PolicyNeeded;
return;
}
// insurance selected
policyId = Int32.Parse(rdcbPolicy.SelectedValue);
pol = CntAriCli.GetPolicy(policyId, ctx);
insurance = pol.Insurance;
// serach for Insurance Service
insuranceServiceId = Int32.Parse(txtInsuranceServiceId.Text);
insuranceService = CntAriCli.GetInsuranceService(insuranceServiceId,insurance, ctx);
if (insuranceService != null)
{
txtInsuranceServiceId.Text = insuranceService.InsuranceServiceId.ToString();
txtInsuranceServiceName.Text = insuranceService.Service.Name;
// Solo cambiamos la descripción si no había algo previamente
if (txtDescription.Text == "")
txtDescription.Text = insuranceService.Service.Name;
//txtAmount.Text = String.Format("{0:0.00}", insuranceService.Price);
if (txtAmount.Text == "")
txtAmount.Text = insuranceService.Price.ToString();
}
else
{
txtInsuranceServiceId.Text = "";
txtInsuranceServiceName.Text = Resources.GeneralResource.InsuranceServiceDoesNotExists;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int oId = 0;
if (int.TryParse(Request.QueryString["id"], out oId))
{
od = OrderDetailOperation.GetOrderDetailById(oId);
insurance = InsuranceOperation.GetInsuranceByOrderDetailId(od.Id);
id = od.OrderId;
}
AdminCookie cookie = (AdminCookie)RuleAuthorizationManager.GetCurrentSessionObject(Context, true);
user = UserOperation.GetUserByUsername(cookie.Username);
if (!IsPostBack)
{
FormDataBind();
}
}
private void Display(Insurance insurance)
{
Console.WriteLine();
Console.WriteLine(insurance.CompanyName);
DisplayAddressData(insurance.Address);
DisplayPhoneData(insurance.phoneNumbers);
Console.WriteLine(insurance.WebAddress);
Console.WriteLine();
Console.WriteLine(insurance.PrintTypes());
if (insurance.ExpirationDate == "99991231")
{
Console.WriteLine($"Currently active since {insurance.EffectiveDate}");
}
else
{
Console.WriteLine($"Active from {insurance.EffectiveDate} until {insurance.ExpirationDate}");
}
Console.WriteLine(insurance.ProductName);
Console.WriteLine($"Product ID: {insurance.ProductID}");
Console.WriteLine($"Payor ID: {insurance.PayorID}");
Console.WriteLine();
Console.WriteLine($"Plan name: {insurance.PlanName}");
Console.WriteLine($"Member ID: {insurance.MemberID}");
Console.WriteLine($"Group number: {insurance.GroupNumber}");
Console.WriteLine($"Prescription bin number: {insurance.BinNumber}");
}