public ActionResult Add(PackageMasterAddViewModel packageMasterVM)
{
if (!ModelState.IsValid)
{
ModelState.AddModelError(string.Empty, "Please enter correct values");
}
packageMasterVM.CreatedBy = GetSessionObject().UserID;
packageMasterVM.CreatedDateTime = DateTime.Now;
PackageMaster packageMaster = packageMasterVM.GetObject();
SetSessionVariables();
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(Common.Instance.ApiPackageMasterControllerName);
var postTask = client.PostAsJsonAsync <PackageMaster>(Common.Instance.ApiPackageMasterAdd, packageMaster);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
var rs = result.Content.ReadAsAsync <ServiceResult <PackageMaster> >().Result;
}
}
return(RedirectToAction("List"));
}
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;
}
}
private void InsertPackage()
{
PackageMaster objPackage = new PackageMaster();
objPackage.ClubId = LoginUser.ClubId;
objPackage.PackageName = txtPackagName.Text;
objPackage = new PackageMasterController().InsertPackage(objPackage);
}
public static List <PackageMaster> GetPackageTypesForDowngrade(PackageMaster objPackage)
{
try
{
return(new FitnessCenterEntities().PackageMasters.Where(x => x.isDeleted == false && x.isActive == true).ToList());
}
catch (Exception ex)
{
throw ex;
}
}
private void BindPackageValues()
{
try
{
PackageMaster objPackage = PackageMasterController.GetPackageById(PackageId);
txtPackagName.Text = objPackage.PackageName;
}
catch (Exception ex)
{
throw ex;
}
}
public PackageMaster GetObeject()
{
PackageMaster packageMaster = new PackageMaster();
packageMaster.ID = ID;
packageMaster.PackageName = PackageName;
packageMaster.SeatReduction.Reduction = SeatReduction;
packageMaster.SpaceReduction.Reduction = SpaceReduction;
packageMaster.ModifyBy = ModifyBy;
packageMaster.ModifyDateTime = ModifyDateTime;
packageMaster.IsActive = IsActive;
return(packageMaster);
}
internal void Update(PackageViewModel model)
{
PackageMaster newobj = objData.PackageMasters.Where(p => p.PackageId == model.PackageId).FirstOrDefault(); //GetVendorTypes().Where(p => p.VendorTypeId == model.VendorTypeId).FirstOrDefault();
if (newobj != null)
{
newobj.PackageName = model.PackageName;
newobj.Price = model.Price;
newobj.Gender = model.Gender;
newobj.Validity = 1;
objData.SaveChanges();
}
}
public int Edit_PackageMaster(PackageMaster _user)
{
SqlParameter[] param = { new SqlParameter("@packageid ", _user.PackageId),
new SqlParameter("@packagename", _user.PackageName),
new SqlParameter("@packagedesc", _user.PackageDesc),
new SqlParameter("@packageduration", _user.PackageDuration),
new SqlParameter("@no_ofInvoice", _user.NoOfInvoice),
new SqlParameter("@no_ofItem", _user.NoOfItem),
new SqlParameter("@price", _user.Price),
new SqlParameter("@term", _user.Term),
new SqlParameter("@modifiedDate", _user.ModifiedDate) };
return(_da.Execute("Update_PackageMaster", param));
}
private void UpdatePackage()
{
try
{
PackageMaster objPackage = PackageMasterController.GetPackageById(PackageId);
objPackage.PackageName = txtPackagName.Text;
new PackageMasterController().UpdatePackage(objPackage);
}
catch (Exception ex)
{
throw ex;
}
}
public PackageMaster GetObject()
{
PackageMaster packageMaster = new PackageMaster();
packageMaster.PackageName = PackageName;
packageMaster.SeatReduction.Reduction = SeatReduction;
packageMaster.SeatReduction.SeatReductionType = SeatReductionType;
packageMaster.SpaceReduction.Reduction = SpaceReduction;
packageMaster.SpaceReduction.SpaceReductionType = SpaceReductionType;
packageMaster.CreatedBy = CreatedBy;
packageMaster.CreatedDateTime = CreatedDateTime;
packageMaster.IsActive = IsActive;
return(packageMaster);
}
protected void ddlPackageS_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlPackageS.SelectedIndex == 0)
{
lblAdmin.Text = lblJoin.Text = lblMember.Text = lblPTP.Text = lblSerTax.Text = "";
}
else
{
PackageMaster objPckg = UserSchemeMasterController.GetPackagesByID(Convert.ToInt64(ddlPackageS.SelectedValue));
//lblJoin.Text = Convert.ToString(objPckg.joiningFee);
//lblAdmin.Text = Convert.ToString(objPckg.adminFee);
//lblMember.Text = Convert.ToString(objPckg.membershipFee);
//lblPTP.Text = Convert.ToString(objPckg.personalTrainingPack);
//lblSerTax.Text = Convert.ToString(objPckg.serviceTaxInPercentage);
}
}
private List <PackageFactorMaster> BindFactorByPackage(DataTable datatable)
{
var objPackageFactorList = new List <PackageFactorMaster>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
var objPackageFactor = new PackageFactorMaster();
var objPackage = new PackageMaster();
var objFactorMasterList = new List <PackageFactor>();
var objPackageFactorID = new List <int>();
objPackage.PackageId = (datatable.Rows[0]["AjPackageId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[0]["AjPackageId"]);
objPackage.PackageName = (datatable.Rows[0]["PackageName"] is DBNull) ? "" : Convert.ToString(datatable.Rows[0]["PackageName"]);
objPackage.PackageAmount = (datatable.Rows[0]["PackageAmount"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[0]["PackageAmount"]);
objPackage.IsChargeable = (datatable.Rows[0]["IsPackageChargeable"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[0]["IsPackageChargeable"]);
objPackage.IsVisible = (datatable.Rows[0]["IsVisible"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[0]["IsVisible"]);
objPackage.courseId = (datatable.Rows[0]["AjCourseId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[0]["AjCourseId"]);
objPackage.CourseName = (datatable.Rows[0]["AjCourseName"] is DBNull) ? null : Convert.ToString(datatable.Rows[0]["AjCourseName"]);
objPackageFactor.objPackage = objPackage;
for (var j = 0; j < datatable.Rows.Count; j++)
{
var packageFactorId = (datatable.Rows[j]["AjPackageFactorId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjPackageFactorId"]);
var objPackageMaster = new PackageFactor();
objPackageMaster.FactorID = (datatable.Rows[j]["FactorId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["FactorId"]);
objPackageMaster.FactorName = (datatable.Rows[j]["AjFactorName"] is DBNull) ? "" : Convert.ToString(datatable.Rows[j]["AjFactorName"]);
objPackageFactorID.Add(packageFactorId);
objFactorMasterList.Add(objPackageMaster);
}
objPackageFactor.ObjPackageFactor = objFactorMasterList;
objPackageFactor.PackageFactorId = objPackageFactorID;
objPackageFactorList.Add(objPackageFactor);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindFactorByPackage in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objPackageFactorList);
}
public long Save(PackageViewModel tbl)
{
PackageMaster vendortype = new PackageMaster()
{
AccessUsers = tbl.AccessUsers,
Gender = tbl.Gender,
IsDelete = false,
PackageName = tbl.PackageName,
Price = tbl.Price,
Validity = tbl.Validity
};
//tbl.IsDelete = false;
objData.PackageMasters.Add(vendortype);
objData.SaveChanges();
return(vendortype.PackageId.Value);
}
public PackageMaster UpdatePackage(PackageMaster objPackage)
{
try
{
objPackage.updateDate = DateTime.Now;
using (var context = new FitnessCenterEntities())
{
context.PackageMasters.Attach(context.PackageMasters.Single(varP => varP.ID == objPackage.ID));
context.PackageMasters.ApplyCurrentValues(objPackage);
context.SaveChanges();
return(objPackage);
}
}
catch (Exception ex)
{
throw ex;
}
}
public PackageMaster InsertPackage(PackageMaster objPackage)
{
try
{
objPackage.isActive = true;
objPackage.isDeleted = false;
objPackage.insertDate = DateTime.Now;
using (var context = new FitnessCenterEntities())
{
context.PackageMasters.AddObject(objPackage);
context.SaveChanges();
return(objPackage);
}
}
catch (Exception ex)
{
throw ex;
}
}
private List <PackageMaster> BindPackageDetails(DataTable datatable)
{
var objPackageFactorList = new List <PackageMaster>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objPackageFactor = new PackageMaster
{
PackageId = (datatable.Rows[j]["AjPackageId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjPackageId"]),
PackageName = (datatable.Rows[j]["PackageName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["PackageName"]),
PackageAmount = (datatable.Rows[j]["PackageAmount"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["PackageAmount"]),
IsChargeable = (datatable.Rows[j]["IsPackageChargeable"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[j]["IsPackageChargeable"]),
IsVisible = (datatable.Rows[j]["IsVisible"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[j]["IsVisible"]),
courseId = (datatable.Rows[j]["AjCourseId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjCourseId"]),
CourseName = (datatable.Rows[j]["AjCourseName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCourseName"])
};
objPackageFactorList.Add(objPackageFactor);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindPackageDetails in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objPackageFactorList);
}
public ActionResult Update(PackageMasterUpdateViewModel packageMasterVM)
{
packageMasterVM.ModifyBy = GetSessionObject().UserID;
packageMasterVM.ModifyDateTime = DateTime.Now;
SetSessionVariables();
PackageMaster packageMaster = packageMasterVM.GetObeject();
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(Common.Instance.ApiPackageMasterControllerName);
var postTask = client.PostAsJsonAsync <PackageMaster>(Common.Instance.ApiPackageMasterUpdate, packageMaster);
postTask.Wait();
var rs = postTask.Result;
if (rs.IsSuccessStatusCode)
{
var readtask = rs.Content.ReadAsAsync <ServiceResult <PackageMaster> >().Result;
}
}
return(RedirectToAction("List"));
}
public int Remove_PackageMaster(PackageMaster _user)
{
SqlParameter[] param = { new SqlParameter("@PackageId ", _user.PackageId), };
return(_da.Execute("Delete_PackageMaster", param));
}
public DataTable Select_PackageByID(PackageMaster _user)
{
SqlParameter[] param = { new SqlParameter("@PackageId", _user.PackageId) };
return(_da.GetFromDataTable("Select_PackageByID", param));
}
