static public CarrierInvoiceProfileFeeItemized Get(int id)
{
CarrierInvoiceProfileFeeItemized item = null;
item = (from x in DbContextHelper.DbContext.CarrierInvoiceProfileFeeItemized
where x.ID == id
select x).FirstOrDefault <CarrierInvoiceProfileFeeItemized>();
return(item);
}
static public CarrierInvoiceProfileFeeItemized Save(CarrierInvoiceProfileFeeItemized item)
{
if (item.ID == 0)
{
DbContextHelper.DbContext.Add(item);
}
DbContextHelper.DbContext.SaveChanges();
return(item);
}
protected void btnAddService_save_Click(object sender, EventArgs e)
{
CarrierInvoiceProfileFeeItemized item = null;
Page.Validate("service");
if (!Page.IsValid)
{
return;
}
int profileID = Convert.ToInt32(ViewState["profileID"]);
int id = Convert.ToInt32(ViewState["ID"]);
if (id == 0)
{
item = new CarrierInvoiceProfileFeeItemized();
item.CarrierInvoiceProfileID = profileID;
item.IsActive = true;
}
else
{
item = CarrierInvoiceProfileFeeItemizedManager.Get(id);
}
if (item != null)
{
item.ServiceTypeID = Convert.ToInt32(ddlServices.SelectedValue);
item.ItemDescription = txtItemDescription.Text;
item.ItemPercentage = txtServicePercentage.ValueDecimal;
item.ItemRate = txtServiceRate.ValueDecimal;
//new fields OC 10/9/14
item.AdjusterPayroll = txtSerPayrollFee.Text == null ? 0 : txtSerPayroll.ValueDecimal;
item.AdjusterPayrollFlatFee = txtSerPayrollFee.Text == null ? 0 : txtSerPayrollFee.ValueDecimal;
//
try {
CarrierInvoiceProfileFeeItemizedManager.Save(item);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
pnlAddService.Visible = false;
pnlGrid.Visible = true;
bindItems(profileID);
}
}
private void copyProfileItemizedItems(List <CarrierInvoiceProfileFeeItemized> itemizedItems, int carrierInvoiceProfileID)
{
if (itemizedItems != null && itemizedItems.Count > 0)
{
foreach (CarrierInvoiceProfileFeeItemized sourceItem in itemizedItems)
{
CarrierInvoiceProfileFeeItemized copyItem = new CarrierInvoiceProfileFeeItemized();
copyItem.CarrierInvoiceProfileID = carrierInvoiceProfileID;
copyItem.IsActive = true;
copyItem.ItemDescription = sourceItem.ItemDescription;
copyItem.ItemPercentage = sourceItem.ItemPercentage;
copyItem.ItemRate = sourceItem.ItemRate;
CarrierInvoiceProfileFeeItemizedManager.Save(copyItem);
}
}
}
protected void gvItems_RowDataBound(object sender, GridViewRowEventArgs e)
{
CarrierInvoiceProfileFeeItemized item = null;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (e.Row.DataItem != null)
{
item = e.Row.DataItem as CarrierInvoiceProfileFeeItemized;
Label lblServiceDescription = e.Row.FindControl("lblServiceDescription") as Label;
if (item.InvoiceServiceType != null)
{
lblServiceDescription.Text = item.InvoiceServiceType.ServiceDescription;
}
else if (item.ExpenseType != null)
{
lblServiceDescription.Text = item.ExpenseType.ExpenseDescription;
}
}
}
}
private void copyProfileItemizedItems(List<CarrierInvoiceProfileFeeItemized> itemizedItems, int carrierInvoiceProfileID)
{
if (itemizedItems != null && itemizedItems.Count > 0) {
foreach (CarrierInvoiceProfileFeeItemized sourceItem in itemizedItems) {
CarrierInvoiceProfileFeeItemized copyItem = new CarrierInvoiceProfileFeeItemized();
copyItem.CarrierInvoiceProfileID = carrierInvoiceProfileID;
copyItem.IsActive = true;
copyItem.ItemDescription = sourceItem.ItemDescription;
copyItem.ItemPercentage = sourceItem.ItemPercentage;
copyItem.ItemRate = sourceItem.ItemRate;
CarrierInvoiceProfileFeeItemizedManager.Save(copyItem);
}
}
}
protected void btnAddExpense_save_Click(object sender, EventArgs e)
{
CarrierInvoiceProfileFeeItemized item = null;
ExpenseType expense = null; //NEW to account for rate pointing to correct place
Page.Validate("expense");
if (!Page.IsValid)
return;
int profileID = Convert.ToInt32(ViewState["profileID"]);
int id = Convert.ToInt32(ViewState["ID"]);
if (id == 0) {
item = new CarrierInvoiceProfileFeeItemized();
item.CarrierInvoiceProfileID = profileID;
item.IsActive = true;
}
else {
item = CarrierInvoiceProfileFeeItemizedManager.Get(id);
}
if (item != null) {
item.ExpenseTypeID = Convert.ToInt32(ddlExpenses.SelectedValue);
item.ItemDescription = txtExpenseDescription.Text;
item.ItemPercentage = txtExpensePercentage.ValueDecimal;
item.ItemRate = txtExpenseRate.ValueDecimal;
item.AdjusterPayroll = txtExpPayroll.Text == null ? 0 : txtExpPayroll.ValueDecimal;
item.AdjusterPayrollFlatFee = txtExpPayrollFee.Text == null ? 0 : txtExpPayrollFee.ValueDecimal;
if (ddlConditionalOperator.SelectedIndex > 0) {
item.LogicalOperator = Convert.ToInt32(ddlConditionalOperator.SelectedValue);
item.LogicalOperatorOperand = txtOperand.ValueDecimal;
}
else {
item.LogicalOperator = null;
item.LogicalOperatorOperand = 0;
}
try {
CarrierInvoiceProfileFeeItemizedManager.Save(item);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
//new OC to save the expense rate into the expense type table 10/8/14
try
{
using (ExpenseTypeManager repository = new ExpenseTypeManager())
{
int expenseID = Convert.ToInt32(ddlExpenses.SelectedValue);
if (expenseID == 0)
{
expense = new ExpenseType();
expense.ClientID = Core.SessionHelper.getClientId();
expense.IsActive = true;
}
else
{
expense = repository.Get(expenseID);
}
if (expense != null)
{
expense.ExpenseRate = txtExpenseRate.ValueDecimal; //txtRateAmount.ValueDecimal;
expense = repository.Save(expense);
}
}
}
catch (Exception ex)
{
Core.EmailHelper.emailError(ex);
}
pnlAddExpense.Visible = false;
pnlGrid.Visible = true;
bindItems(profileID);
}
}
protected void btnAddService_save_Click(object sender, EventArgs e)
{
CarrierInvoiceProfileFeeItemized item = null;
Page.Validate("service");
if (!Page.IsValid)
return;
int profileID = Convert.ToInt32(ViewState["profileID"]);
int id = Convert.ToInt32(ViewState["ID"]);
if (id == 0) {
item = new CarrierInvoiceProfileFeeItemized();
item.CarrierInvoiceProfileID = profileID;
item.IsActive = true;
}
else {
item = CarrierInvoiceProfileFeeItemizedManager.Get(id);
}
if (item != null) {
item.ServiceTypeID = Convert.ToInt32(ddlServices.SelectedValue);
item.ItemDescription = txtItemDescription.Text;
item.ItemPercentage = txtServicePercentage.ValueDecimal;
item.ItemRate = txtServiceRate.ValueDecimal;
//new fields OC 10/9/14
item.AdjusterPayroll = txtSerPayrollFee.Text == null ? 0 : txtSerPayroll.ValueDecimal;
item.AdjusterPayrollFlatFee = txtSerPayrollFee.Text == null ? 0 : txtSerPayrollFee.ValueDecimal;
//
try {
CarrierInvoiceProfileFeeItemizedManager.Save(item);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
pnlAddService.Visible = false;
pnlGrid.Visible = true;
bindItems(profileID);
}
}
protected void gvItems_RowCommand(object sender, GridViewCommandEventArgs e)
{
CarrierInvoiceProfileFeeItemized item = null;
int id = 0;
int profileID = Convert.ToInt32(ViewState["profileID"]);
if (e.CommandName == "DoEdit")
{
id = Convert.ToInt32(e.CommandArgument);
ViewState["ID"] = id.ToString();
item = CarrierInvoiceProfileFeeItemizedManager.Get(id);
if (item != null)
{
if (item.InvoiceServiceType != null)
{
pnlAddService.Visible = true;
pnlGrid.Visible = false;
bindInvoiceServices();
ddlServices.SelectedValue = (item.ServiceTypeID ?? 0).ToString();
txtServicePercentage.Value = item.ItemPercentage;
txtServiceRate.Value = item.ItemRate;
txtItemDescription.Text = item.ItemDescription;
//NEW OC 10/9/14
txtSerPayroll.Value = item.AdjusterPayroll;
txtSerPayrollFee.Value = item.AdjusterPayrollFlatFee;
}
else if (item.ExpenseType != null)
{
pnlAddExpense.Visible = true;
pnlGrid.Visible = false;
bindInvoiceExpenses();
ddlExpenses.SelectedValue = (item.ExpenseTypeID ?? 0).ToString();
txtExpenseDescription.Text = item.ItemDescription;
txtExpensePercentage.Value = item.ItemPercentage;
txtExpenseRate.Value = item.ItemRate;
//NEW OC 10/9/14
txtExpPayroll.Value = item.AdjusterPayroll;
txtExpPayrollFee.Value = item.AdjusterPayrollFlatFee;
if (item.LogicalOperator != null)
{
ddlConditionalOperator.SelectedValue = item.LogicalOperator.ToString();
tr_percentage.Visible = false;
}
else
{
tr_percentage.Visible = true;
}
txtOperand.Value = item.LogicalOperatorOperand;
}
}
}
else if (e.CommandName == "DoDelete")
{
id = Convert.ToInt32(e.CommandArgument);
CarrierInvoiceProfileFeeItemizedManager.Delete(id);
refreshGrid();
}
}
protected void btnAddExpense_save_Click(object sender, EventArgs e)
{
CarrierInvoiceProfileFeeItemized item = null;
ExpenseType expense = null; //NEW to account for rate pointing to correct place
Page.Validate("expense");
if (!Page.IsValid)
{
return;
}
int profileID = Convert.ToInt32(ViewState["profileID"]);
int id = Convert.ToInt32(ViewState["ID"]);
if (id == 0)
{
item = new CarrierInvoiceProfileFeeItemized();
item.CarrierInvoiceProfileID = profileID;
item.IsActive = true;
}
else
{
item = CarrierInvoiceProfileFeeItemizedManager.Get(id);
}
if (item != null)
{
item.ExpenseTypeID = Convert.ToInt32(ddlExpenses.SelectedValue);
item.ItemDescription = txtExpenseDescription.Text;
item.ItemPercentage = txtExpensePercentage.ValueDecimal;
item.ItemRate = txtExpenseRate.ValueDecimal;
item.AdjusterPayroll = txtExpPayroll.Text == null ? 0 : txtExpPayroll.ValueDecimal;
item.AdjusterPayrollFlatFee = txtExpPayrollFee.Text == null ? 0 : txtExpPayrollFee.ValueDecimal;
if (ddlConditionalOperator.SelectedIndex > 0)
{
item.LogicalOperator = Convert.ToInt32(ddlConditionalOperator.SelectedValue);
item.LogicalOperatorOperand = txtOperand.ValueDecimal;
}
else
{
item.LogicalOperator = null;
item.LogicalOperatorOperand = 0;
}
try {
CarrierInvoiceProfileFeeItemizedManager.Save(item);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
//new OC to save the expense rate into the expense type table 10/8/14
try
{
using (ExpenseTypeManager repository = new ExpenseTypeManager())
{
int expenseID = Convert.ToInt32(ddlExpenses.SelectedValue);
if (expenseID == 0)
{
expense = new ExpenseType();
expense.ClientID = Core.SessionHelper.getClientId();
expense.IsActive = true;
}
else
{
expense = repository.Get(expenseID);
}
if (expense != null)
{
expense.ExpenseRate = txtExpenseRate.ValueDecimal; //txtRateAmount.ValueDecimal;
expense = repository.Save(expense);
}
}
}
catch (Exception ex)
{
Core.EmailHelper.emailError(ex);
}
pnlAddExpense.Visible = false;
pnlGrid.Visible = true;
bindItems(profileID);
}
}
