public void Insert(ClientPlan clientPlan)
{
Error erro = new Error();
Clients clients = (Clients)_pharmaContext.Clients.Select(x => x.idCliente == clientPlan.idCliente);
Plans plan = (Plans)_pharmaContext.Plans.Select(x => x.idPlan == clientPlan.idPlan);
if (plan.dtFinalVigencia < clients.dtCadastro)
{
erro.erro = "Não é permitido o relacionamento com um plano com vigência final menor que a data de vinculo";
erro.status = false;
}
else if (plan.permitePessoaJuridica == "N" && clients.cpfCnpj.Length <= 14)
{
erro.erro = "Não é permitido pessoa jurídica para o plano escolhido";
erro.status = false;
}
else
{
_pharmaContext.ClientPlans.Add(clientPlan);
_pharmaContext.SaveChanges();
}
}
public void Post([FromBody] ClientPlan clientPlan)
{
_clientPlan.Insert(clientPlan);
}
private void SaveClient()
{
//Add Client user
using (AxaContext ctx = new AxaContext())
{
var clientInfo = new Client
{
CLastName = tb_LastName.Text,
CMiddleName = tb_MiddleName.Text,
CFirstName = tb_FirstName.Text,
SpouseLastName = tb_SLastName.Text,
SpouseMiddleName = tb_SMiddleName.Text,
SpouseFirstName = tb_SFirstName.Text,
Gender = cb_Gender.Text,
CivilStatus = cb_CivilStatus.Text,
PolicyStatus = cb_PolicyStatus.Text,
CBirthday = dtp_Dob.Value,
Age = tb_Age.Text,
PlaceOfBirth = tb_PlaceOfBirth.Text,
Height = 11,
//Height = float.Parse(tb_Height.Text),
//Weight = float.Parse(tb_Weight.Text),
Weight = 11,
CAddress = tb_Address.Text,
CellphoneNo = tb_CellphoneNo.Text,
TelephoneNo = tb_TelephoneNo.Text,
EmailAddress = tb_EmailAddress.Text,
Occupation = tb_COccupation.Text,
//WorkSalary = float.Parse(tb_CWorkSalary.Text),
//BusinessIncome = float.Parse(tb_CBusinessIncome.Text),
//OtherSource = float.Parse(tb_COtherSource.Text),
WorkSalary = 11,
BusinessIncome = 11,
OtherSource = 11,
CompanyName = tb_CName.Text,
CompanyAddress = tb_CAddress.Text,
CompanyContact = tb_CompanyContactNo.Text,
NatureOfBusiness = tb_CNatureOfBusiness.Text,
TaxIdNumber = tb_TaxIdentication.Text,
Sss_gsisNumber = tb_SSSorGSIS_Number.Text,
ValidId1 = idPic1.Text,
ValidId2 = idPic2.Text,
// EmployeeId = tempEmployeeId
EmployeeId = 1
};
ctx.Clients.Add(clientInfo);
ctx.SaveChanges();
// save client plan
var clientPlan = new ClientPlan();
for (int row = 0; row < dataGridView_LoadPlans.Rows.Count; row++)
{
clientPlan.PolicyNo = dataGridView_LoadPlans.Rows[row].Cells["col_PolicyNo"].Value.ToString();
clientPlan.SumInsured = dataGridView_LoadPlans.Rows[row].Cells["col_SumInsured"].Value.ToString();
clientPlan.ModeOfPayment = dataGridView_LoadPlans.Rows[row].Cells["col_ModeOfPayment"].Value.ToString();
clientPlan.DueOfPayment = Int32.Parse(dataGridView_LoadPlans.Rows[row].Cells["col_DueOfPayment"].Value.ToString());
string tempPlanCategory = dataGridView_LoadPlans.Rows[row].Cells["col_PlanCategory"].Value.ToString();
string tempPlanAvail = dataGridView_LoadPlans.Rows[row].Cells["col_PlanAvail"].Value.ToString();
var tempPlanId = ctx.Plans.Where(x => x.Category == tempPlanCategory && x.Description == tempPlanAvail).Select(p => p.PlanId).FirstOrDefault().ToString();
clientPlan.PlanId = Convert.ToInt32(tempPlanId);
clientPlan.ClientId = clientInfo.ClientId;
ctx.ClientPlans.Add(clientPlan);
ctx.SaveChanges();
}
}
}