private void BindUserSchemeDetails()
{
try
{
PanelTransactionVisibility(true, false);
#region UserScheme
SchemeMaster objUserScheme = UserSchemeMasterController.GetUserSchemeMasterByID(UserSchemeID);
ddlPckgName.SelectedValue = Convert.ToString(objUserScheme.PackageId);
txtSchemeName.Text = objUserScheme.SchemeName;
lblSchJoin.Text = "Joining Fee:- " + Convert.ToString(objUserScheme.JoiningFee);
lblSchAdmin.Text = "Admin Fee:- " + Convert.ToString(objUserScheme.AdminFee);
lblSchMem.Text = "Membership Fee:- " + Convert.ToString(objUserScheme.MemberFee);
lblSchPers.Text = "Personal Traning Fee:- " + Convert.ToString(objUserScheme.PTFee);
lblSchService.Text = "ServiceTax:- " + Convert.ToString(objUserScheme.SGST);
lblSchService.Text = "ServiceTax:- " + Convert.ToString(objUserScheme.CGST);
#endregion
#region Packages
PackageMaster objPckMst = UserSchemeMasterController.GetPackagesByID(Convert.ToInt64(ddlPckgName.SelectedValue));
//lblAdminFee.Text = "Admin Fee:- " + Convert.ToString(objPckMst.adminFee);
//lblJoinFee.Text = "Joining Fee:- " + Convert.ToString(objPckMst.joiningFee);
//lblMembrFee.Text = "Membership Fee:- " + Convert.ToString(objPckMst.membershipFee);
//lblPrsnltrngFee.Text = "Personal Traning Fee:- " + Convert.ToString(objPckMst.personalTrainingPack);
//lblSrvcTax.Text = "ServiceTax:- " + Convert.ToString(objPckMst.serviceTaxInPercentage);
#endregion
BindTransGrid();
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateSchemeMaster(SchemeMaster schemeMaster)
{
_context.Entry(schemeMaster).Property(x => x.Status).IsModified = true;
var result = _context.SaveChanges();
return(result > 0);
}
public bool AddSchemeMaster(SchemeMaster schemeMaster)
{
//var connectionString = _configuration.GetConnectionString("DatabaseConnection");
_context.SchemeMaster.Add(schemeMaster);
var result = _context.SaveChanges();
return(result > 0);
}
public bool AddSchemeMaster(SchemeMaster schemeMaster)
{
_context.SchemeMaster.Add(schemeMaster);
var result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateSchemeMaster(SchemeMaster schemeMaster)
{
_context.Entry(schemeMaster).Property(x => x.Status).IsModified = true;
_context.Entry(schemeMaster).Property(x => x.SchemeName).IsModified = true;
var result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddSchemeMaster(SchemeMaster schemeMaster)
{
//var connectionString = _configuration["SQLConnString_PRD:DBConnGymDB_PRD"];
_context.SchemeMaster.Add(schemeMaster);
var result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
private void BindUserSchemeValues()
{
try
{
SchemeMaster objUserScheme = UserSchemeMasterController.GetUserSchemeMasterByID(UserSchemeID);
ddlPackageS.SelectedValue = objUserScheme.PackageId.ToString();
txtUserschemeName.Text = objUserScheme.SchemeName;
txtJoinFee.Text = Convert.ToString(objUserScheme.JoiningFee);
txtMemFee.Text = Convert.ToString(objUserScheme.MemberFee);
txtAdminFee.Text = Convert.ToString(objUserScheme.AdminFee);
txtPersTraining.Text = Convert.ToString(objUserScheme.PTFee);
txtService.Text = Convert.ToString(objUserScheme.SGST);
txtService.Text = Convert.ToString(objUserScheme.CGST);
txtTotAmt.Text = Convert.ToString(objUserScheme.TotalAmount);
txtAdditionalExpense.Text = Convert.ToString(objUserScheme.AdditionalExpense);
txtDwnGrdDays.Text = Convert.ToString(objUserScheme.DowngradeDays);
txtUpgrdDays.Text = Convert.ToString(objUserScheme.UpgradeDays);
txtStrDate.Text = ((DateTime)objUserScheme.StartDate).ToString("dd/MM/yyyy");
txtEndDate.Text = ((DateTime)objUserScheme.EndDate).ToString("dd/MM/yyyy");
ddlStartTime.SelectedValue = Convert.ToString(objUserScheme.StartTime);
ddlEndTime.SelectedValue = Convert.ToString(objUserScheme.EndTime);
if (chkAllowCancelation.Checked)
{
pnlCancellation.Visible = true;
txtCanclDays.Text = Convert.ToString(objUserScheme.CancelDays);
CancellationMaster objCancel = UserSchemeMasterController.GetCancellationBySchemeId(UserSchemeID);
chkJoining.Checked = (bool)objCancel.joiningFee;
chkAdmin.Checked = (bool)objCancel.adminFee;
chkMembership.Checked = (bool)objCancel.membershipFee;
chkPTP.Checked = (bool)objCancel.personalTrainingPack;
}
else
{
pnlCancellation.Visible = false;
txtCanclDays.Text = "";
chkJoining.Checked = chkAdmin.Checked = chkMembership.Checked = chkPTP.Checked = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public SchemeMaster UpdateUserScheme(SchemeMaster objScheme)
{
try
{
objScheme.updateDate = DateTime.Now;
using (var context = new FitnessCenterEntities())
{
context.SchemeMasters.Attach(context.SchemeMasters.Single(varU => varU.ID == objScheme.ID));
context.SchemeMasters.ApplyCurrentValues(objScheme);
context.SaveChanges();
return(objScheme);
}
}
catch (Exception ex)
{
throw ex;
}
}
public SchemeMaster InsertUserScheme(SchemeMaster objScheme)
{
try
{
objScheme.insertDate = DateTime.Now;
objScheme.isActive = true;
objScheme.isDeleted = false;
using (var context = new FitnessCenterEntities())
{
context.SchemeMasters.AddObject(objScheme);
context.SaveChanges();
return(objScheme);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void UpdateUserScheme()
{
try
{
SchemeMaster objUserScheme = UserSchemeMasterController.GetUserSchemeMasterByID(UserSchemeID);
objUserScheme.PackageId = Convert.ToInt64(ddlPackageS.SelectedValue);
objUserScheme.SchemeName = txtUserschemeName.Text;
objUserScheme.JoiningFee = Convert.ToDecimal(txtJoinFee.Text);
objUserScheme.AdminFee = Convert.ToDecimal(txtAdminFee.Text);
objUserScheme.MemberFee = Convert.ToDecimal(txtMemFee.Text);
objUserScheme.PTFee = Convert.ToDecimal(txtPersTraining.Text);
objUserScheme.SGST = Convert.ToDecimal(txtService.Text);
objUserScheme.CGST = Convert.ToDecimal(txtService.Text);
objUserScheme.TotalAmount = Convert.ToDecimal(txtTotAmt.Text);
objUserScheme.AdditionalExpense = Convert.ToDecimal(0);
objUserScheme.StartDate = UtillController.ConvertDateTime(txtStrDate.Text);
objUserScheme.EndDate = UtillController.ConvertDateTime(txtEndDate.Text);
objUserScheme.StartTime = ddlStartTime.SelectedValue;
objUserScheme.EndTime = ddlEndTime.SelectedValue;
if (txtCanclDays.Text.Equals(""))
{
objUserScheme.CancelDays = null;
}
else
{
objUserScheme.CancelDays = Convert.ToInt32(txtCanclDays.Text);
}
objUserScheme.DowngradeDays = Convert.ToInt32(txtDwnGrdDays.Text);
objUserScheme.UpgradeDays = Convert.ToInt32(txtUpgrdDays.Text);
new UserSchemeMasterController().UpdateUserScheme(objUserScheme);
if (chkAllowCancelation.Checked)
{
CancellationMaster objCancel = UserSchemeMasterController.GetCancellationBySchemeId(UserSchemeID);
if (objCancel != null)
{
objCancel.schemeId = UserSchemeID;
objCancel.joiningFee = chkJoining.Checked;
objCancel.adminFee = chkAdmin.Checked;
objCancel.membershipFee = chkMembership.Checked;
objCancel.personalTrainingPack = chkPTP.Checked;
new UserSchemeMasterController().UpdateCancelMaster(objCancel);
}
else
{
objCancel = new CancellationMaster();
objCancel.schemeId = UserSchemeID;
objCancel.joiningFee = chkJoining.Checked;
objCancel.adminFee = chkAdmin.Checked;
objCancel.membershipFee = chkMembership.Checked;
objCancel.personalTrainingPack = chkPTP.Checked;
new UserSchemeMasterController().InsertCancelMaster(objCancel);
}
}
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "succ_msg", "MessageBox('Success','Data Updated');", true);
}
catch (Exception ex)
{
throw ex;
}
}
