private void InsertUserSchemeTrans()
{
try
{
int valid = 0;
valid = UserSchemeMasterController.GetTransactionBySchemeIDAndUserType(UserSchemeID, Convert.ToInt64(ddlUsers.SelectedValue)).Count;
if (valid > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "err_msg", "MessageBox('Error','Transaction of same UserType Already Exists.');", true);
}
else
{
UserSchemeTransaction objscmTran = new UserSchemeTransaction();
objscmTran.userSchemeId = UserSchemeID;
objscmTran.joiningFee = Convert.ToDecimal(txtJFee.Text);
objscmTran.adminFee = Convert.ToDecimal(txtAFee.Text);
objscmTran.membershipFee = Convert.ToDecimal(txtMmbrFee.Text);
objscmTran.personalTrainingPack = Convert.ToDecimal(txtPTFee.Text);
objscmTran.serviceTaxInPercentage = Convert.ToDecimal(txtSTax.Text);
objscmTran.totalAmount = Convert.ToDecimal(txtTAmt.Text);
objscmTran.userTypeId = Convert.ToInt32(ddlUsers.SelectedValue);
objscmTran = new UserSchemeMasterController().InsertUserSchemeTransaction(objscmTran);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void BindUserSchemeTransValues()
{
PanelTransactionVisibility(false, true);
UserSchemeTransaction objUserSchTrans = UserSchemeMasterController.GetUserSchemeTransactionByID(UserSchemeTransID);
ddlUsers.SelectedValue = Convert.ToString(objUserSchTrans.userTypeId);
txtJFee.Text = Convert.ToString(objUserSchTrans.joiningFee);
txtAFee.Text = Convert.ToString(objUserSchTrans.adminFee);
txtMmbrFee.Text = Convert.ToString(objUserSchTrans.membershipFee);
txtPTFee.Text = Convert.ToString(objUserSchTrans.personalTrainingPack);
txtSTax.Text = Convert.ToString(objUserSchTrans.serviceTaxInPercentage);
txtTAmt.Text = Convert.ToString(objUserSchTrans.totalAmount);
}
private void UpdateUserSchemeTrans()
{
try
{
UserSchemeTransaction objUserSchTrans = UserSchemeMasterController.GetUserSchemeTransactionByID(UserSchemeTransID);
objUserSchTrans.userSchemeId = UserSchemeID;
objUserSchTrans.joiningFee = Convert.ToDecimal(txtJFee.Text);
objUserSchTrans.adminFee = Convert.ToDecimal(txtAFee.Text);
objUserSchTrans.membershipFee = Convert.ToDecimal(txtMmbrFee.Text);
objUserSchTrans.personalTrainingPack = Convert.ToDecimal(txtPTFee.Text);
objUserSchTrans.serviceTaxInPercentage = Convert.ToDecimal(txtSTax.Text);
objUserSchTrans.totalAmount = Convert.ToDecimal(txtTAmt.Text);
objUserSchTrans.userTypeId = Convert.ToInt32(ddlUsers.SelectedValue);
objUserSchTrans = new UserSchemeMasterController().UpdateUserSchemeTransaction(objUserSchTrans);
}
catch (Exception ex)
{
throw ex;
}
}
public UserSchemeTransaction UpdateUserSchemeTransaction(UserSchemeTransaction objSchemeTrans)
{
try
{
objSchemeTrans.updateDate = DateTime.Now;
using (var context = new FitnessCenterEntities())
{
context.UserSchemeTransactions.Attach(context.UserSchemeTransactions.Single(varU => varU.ID == objSchemeTrans.ID));
context.UserSchemeTransactions.ApplyCurrentValues(objSchemeTrans);
context.SaveChanges();
return(objSchemeTrans);
}
}
catch (Exception ex)
{
throw ex;
}
}
public UserSchemeTransaction InsertUserSchemeTransaction(UserSchemeTransaction objSchemeTran)
{
try
{
objSchemeTran.insertDate = DateTime.Now;
objSchemeTran.isActive = true;
objSchemeTran.isDelete = false;
using (var context = new FitnessCenterEntities())
{
context.UserSchemeTransactions.AddObject(objSchemeTran);
context.SaveChanges();
return(objSchemeTran);
}
}
catch (Exception ex)
{
throw ex;
}
}
