public void BindUnderWriterToUpdate()
{
UnderwriterModel model = client.SelectUnderwriterBypkid(UnderwriterId, ParlourId);
if ((model == null) || (model.Parlourid != ParlourId))
{
Response.Write("<script>alert('Sorry!you are not authorized to perform edit on this Plan.');</script>");
}
else
{
UnderwriterId = model.PkiUnderwriterId;
txtUnderwriterName.Text = model.UnderwriterName.ToString();
txtPlanName.Text = model.PlanName;
txtPremium.Text = model.Premium.ToString();
txtCover.Text = model.Cover.ToString("#,0.00");
ddlSpouse.Text = model.Spouse.ToString();
ddlChildren.Text = model.Children.ToString();
txtFirstYear.Text = model.Cover0to5year.ToString("#,0.00");
txtSecondYear.Text = model.Cover14to21year.ToString("#,0.00");
txtThirdYear.Text = model.Cover6to13year.ToString("#,0.00");
txtSpouseCover.Text = model.SpouseCover.ToString("#,0.00");
txtAdultCover1.Text = model.Cover22to40year.ToString("#,0.00");
txtAdultCover2.Text = model.Cover41to59year.ToString("#,0.00");
txtAdultCover3.Text = model.Cover60to65year.ToString("#,0.00");
txtAdultCover4.Text = model.Cover66to75year.ToString("#,0.00");
ddlAdults.Text = model.Adults.ToString();
btnSubmite.Text = "Update";
}
}
protected void btnSubmite_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
UnderwriterModel model;
model = client.SelectUnderwriterByName(txtUnderwriterName.Text, ParlourId);
if (model != null && UnderwriterId == 0)
{
ShowMessage(ref lblMessage, MessageType.Danger, "Underwriter Already Exists.");
}
else
{
model = new UnderwriterModel();
model.PkiUnderwriterId = UnderwriterId;
model.PlanName = txtPlanName.Text;
model.UnderwriterName = txtUnderwriterName.Text;
model.Cover = (txtCover.Text == string.Empty ? 0 : Convert.ToDecimal(txtCover.Text));
model.Spouse = Convert.ToInt32(ddlSpouse.Text);
model.Children = Convert.ToInt32(ddlChildren.Text);
model.Adults = Convert.ToInt32(ddlAdults.Text);
model.Premium = txtPremium.Text;
model.CoverAmount = txtCover.Text;
model.Cover22to40year = (txtAdultCover1.Text == string.Empty ? 0 : Convert.ToDecimal(txtAdultCover1.Text));
model.Cover41to59year = (txtAdultCover2.Text == string.Empty ? 0 : Convert.ToDecimal(txtAdultCover2.Text));
model.Cover60to65year = (txtAdultCover3.Text == string.Empty ? 0 : Convert.ToDecimal(txtAdultCover3.Text));
model.Cover66to75year = (txtAdultCover4.Text == string.Empty ? 0 : Convert.ToDecimal(txtAdultCover4.Text));
model.Cover0to5year = (txtFirstYear.Text == string.Empty ? 0 : Convert.ToDecimal(txtFirstYear.Text));
model.Cover14to21year = (txtFirstYear.Text == string.Empty ? 0 : Convert.ToDecimal(txtSecondYear.Text));
model.Cover6to13year = (txtFirstYear.Text == string.Empty ? 0 : Convert.ToDecimal(txtThirdYear.Text));
model.SpouseCover = (txtSpouseCover.Text == string.Empty ? 0 : Convert.ToDecimal(txtSpouseCover.Text));
model.AdultCover = model.Cover22to40year + model.Cover41to59year + model.Cover60to65year + model.Cover66to75year;
model.ChildCover = model.Cover0to5year + model.Cover14to21year + model.Cover6to13year;
model.LastModified = System.DateTime.Now;
model.Parlourid = ParlourId;
model.ModifiedUser = UserName;
model.CreateddDate = System.DateTime.Now;
model.CreatedUser = UserName;
//================================================================
int retID = client.SaveUnderwriter(model);
UnderwriterId = retID;
ShowMessage(ref lblMessage, MessageType.Success, "Plan Details successfully saved");
BindUndewriterList();
ClearControl();
}
lblMessage.Visible = true;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab512", "goToTab(5)", true);
}
}
public static int SaveUnderwriter(UnderwriterModel model)
{
try
{
string query = "SaveUnderwriter";
DbParameter[] ObjParam = new DbParameter[25];
ObjParam[0] = new DbParameter("@PkiUnderwriterId", DbParameter.DbType.Int, 0, model.PkiUnderwriterId);
ObjParam[1] = new DbParameter("@UnderwriterName", DbParameter.DbType.NVarChar, 0, model.UnderwriterName);
ObjParam[2] = new DbParameter("@PlanName", DbParameter.DbType.NVarChar, 0, model.PlanName);
ObjParam[3] = new DbParameter("@Premium", DbParameter.DbType.NVarChar, 0, model.Premium);
ObjParam[4] = new DbParameter("@CoverAmount", DbParameter.DbType.NVarChar, 0, model.CoverAmount);
ObjParam[5] = new DbParameter("@Spouse", DbParameter.DbType.Int, 0, model.Spouse);
ObjParam[6] = new DbParameter("@Children", DbParameter.DbType.Int, 0, model.Children);
ObjParam[7] = new DbParameter("@Adults", DbParameter.DbType.Int, 0, model.Adults);
ObjParam[8] = new DbParameter("@Cover", DbParameter.DbType.Decimal, 0, model.Cover);
ObjParam[9] = new DbParameter("@SpouseCover", DbParameter.DbType.Decimal, 0, model.SpouseCover);
ObjParam[10] = new DbParameter("@ChildCover", DbParameter.DbType.Decimal, 0, model.ChildCover);
ObjParam[11] = new DbParameter("@AdultCover", DbParameter.DbType.Decimal, 0, model.AdultCover);
ObjParam[12] = new DbParameter("@Parlourid", DbParameter.DbType.UniqueIdentifier, 0, model.Parlourid);
ObjParam[13] = new DbParameter("@PlanUnderwriter", DbParameter.DbType.NVarChar, 0, model.PlanUnderwriter);
ObjParam[14] = new DbParameter("@LastModified", DbParameter.DbType.DateTime, 0, model.LastModified);
ObjParam[15] = new DbParameter("@ModifiedUser", DbParameter.DbType.NVarChar, 0, model.ModifiedUser);
ObjParam[16] = new DbParameter("@CreateddDate", DbParameter.DbType.DateTime, 0, model.CreateddDate);
ObjParam[17] = new DbParameter("@CreatedUser", DbParameter.DbType.NVarChar, 0, model.CreatedUser);
ObjParam[18] = new DbParameter("@Cover0to5year", DbParameter.DbType.Decimal, 0, model.Cover0to5year);
ObjParam[19] = new DbParameter("@Cover6to13year", DbParameter.DbType.Decimal, 0, model.Cover6to13year);
ObjParam[20] = new DbParameter("@Cover14to21year", DbParameter.DbType.Decimal, 0, model.Cover14to21year);
ObjParam[21] = new DbParameter("@Cover22to40year", DbParameter.DbType.Decimal, 0, model.Cover22to40year);
ObjParam[22] = new DbParameter("@Cover41to59year", DbParameter.DbType.Decimal, 0, model.Cover41to59year);
ObjParam[23] = new DbParameter("@Cover60to65year", DbParameter.DbType.Decimal, 0, model.Cover60to65year);
ObjParam[24] = new DbParameter("@Cover66to75year", DbParameter.DbType.Decimal, 0, model.Cover66to75year);
return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, query, ObjParam)));
}
catch (Exception e)
{
throw e;
}
}
public static int SaveUnderwriter(UnderwriterModel model)
{
return(UnderwriterDAL.SaveUnderwriter(model));
}
