public void bindData(int policyID, int limitType)
{
List<PolicySubLimit> limits = null;
PolicySubLimit limit = null;
limits = PolicySublimitManager.GetAll(policyID, limitType);
if (limits != null && limits.Count == 0) {
switch (limitType) {
case 1: // property limits
limits = primePropertyLimits();
break;
default:
break;
}
}
else {
// add a blank entry to allow new entry
limit = new PolicySubLimit();
limit.LimitType = LimitType.LIMIT_TYPE_PROPERTY;
limits.Add(limit);
}
gvLimits.DataSource = limits;
gvLimits.DataBind();
}
public void bindData(int policyID, int limitType)
{
List <PolicySubLimit> limits = null;
PolicySubLimit limit = null;
limits = PolicySublimitManager.GetAll(policyID, limitType);
if (limits != null && limits.Count == 0)
{
switch (limitType)
{
case 1: // property limits
limits = primePropertyLimits();
break;
default:
break;
}
}
else
{
// add a blank entry to allow new entry
limit = new PolicySubLimit();
limit.LimitType = LimitType.LIMIT_TYPE_PROPERTY;
limits.Add(limit);
}
gvLimits.DataSource = limits;
gvLimits.DataBind();
}
public static PolicySubLimit Get(int id)
{
PolicySubLimit limit = null;
limit = (from x in DbContextHelper.DbContext.PolicySubLimit
where x.PolicySublimitID == id
select x).FirstOrDefault <PolicySubLimit>();
return(limit);
}
public static PolicySubLimit Save(PolicySubLimit limit)
{
if (limit.PolicySublimitID == 0)
{
DbContextHelper.DbContext.Add(limit);
}
DbContextHelper.DbContext.SaveChanges();
return(limit);
}
private List <PolicySubLimit> primePropertyLimits()
{
List <PolicySubLimit> limits = new List <PolicySubLimit>();
PolicySubLimit limit = new PolicySubLimit();
limit.LimitType = LimitType.LIMIT_TYPE_PROPERTY;
limits.Add(limit);
return(limits);
}
public void saveLimits(int policyID)
{
int policySubLimitID = 0;
int limitType = 0;
PolicySubLimit limit = null;
foreach (GridViewRow row in gvLimits.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
WebTextEditor txtCoverage = row.FindControl("txtCoverage") as WebTextEditor;
WebTextEditor txtSublimit = row.FindControl("txtSublimit") as WebTextEditor;
if (string.IsNullOrEmpty(txtCoverage.Text.Trim()) && string.IsNullOrEmpty(txtSublimit.Text.Trim()))
{
continue;
}
policySubLimitID = (int)gvLimits.DataKeys[row.RowIndex].Values[0];
limitType = (int)gvLimits.DataKeys[row.RowIndex].Values[1];
if (policySubLimitID == 0)
{
limit = new PolicySubLimit();
}
else
{
limit = PolicySublimitManager.Get(policySubLimitID);
}
limit.PolicyID = policyID;
limit.PolicySublimitID = policySubLimitID;
limit.LimitType = limitType;
limit.SublimitDescription = txtCoverage.Text;
limit.Sublimit = txtSublimit.Value == null ? 0 : Convert.ToDecimal(txtSublimit.Value);
try {
PolicySublimitManager.Save(limit);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
}
}
bindData(policyID, 1);
}
public static void Delete(int id)
{
// Create an entity to represent the Entity you wish to delete
// Notice you don't need to know all the properties, in this
// case just the ID will do.
PolicySubLimit limit = new PolicySubLimit {
PolicySublimitID = id
};
// Now attach the category stub object to the "Categories" set.
// This puts the Entity into the context in the unchanged state,
// This is same state it would have had if you made the query
DbContextHelper.DbContext.AttachTo("PolicySubLimits", limit);
// Do the delete the category
DbContextHelper.DbContext.DeleteObject(limit);
// Apply the delete to the database
DbContextHelper.DbContext.SaveChanges();
}
public void saveLimits(int policyID)
{
int policySubLimitID = 0;
int limitType = 0;
PolicySubLimit limit = null;
foreach (GridViewRow row in gvLimits.Rows) {
if (row.RowType == DataControlRowType.DataRow) {
WebTextEditor txtCoverage = row.FindControl("txtCoverage") as WebTextEditor;
WebTextEditor txtSublimit = row.FindControl("txtSublimit") as WebTextEditor;
if (string.IsNullOrEmpty(txtCoverage.Text.Trim()) && string.IsNullOrEmpty(txtSublimit.Text.Trim()))
continue;
policySubLimitID = (int)gvLimits.DataKeys[row.RowIndex].Values[0];
limitType = (int)gvLimits.DataKeys[row.RowIndex].Values[1];
if (policySubLimitID == 0)
limit = new PolicySubLimit();
else
limit = PolicySublimitManager.Get(policySubLimitID);
limit.PolicyID = policyID;
limit.PolicySublimitID = policySubLimitID;
limit.LimitType = limitType;
limit.SublimitDescription = txtCoverage.Text;
limit.Sublimit = txtSublimit.Value == null ? 0 : Convert.ToDecimal(txtSublimit.Value);
try {
PolicySublimitManager.Save(limit);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
}
}
bindData(policyID,1);
}
private List<PolicySubLimit> primePropertyLimits()
{
List<PolicySubLimit> limits = new List<PolicySubLimit>();
PolicySubLimit limit = new PolicySubLimit();
limit.LimitType = LimitType.LIMIT_TYPE_PROPERTY;
limits.Add(limit);
return limits;
}
