public IActionResult UpdateProduct(MembershipProperty model)
{
model.Code = AppGlobal.Product;
string note = AppGlobal.InitString;
int result = 0;
model.Initialization(InitType.Update, RequestUserID);
result = _membershipPropertyRepository.Update(model.ID, model);
if (result > 0)
{
note = AppGlobal.Success + " - " + AppGlobal.EditSuccess;
}
else
{
note = AppGlobal.Error + " - " + AppGlobal.EditFail;
}
return(Json(note));
}
public ApiMembership(DataRow dataRow)
{
this.name = dataRow["Name"].ToString();
this.color = dataRow["Color"].ToString();
this.properties = new List <KeyValuePair <string, string> >();
var hiddenProperties = MembershipProperty.GetPropsToHideForClient();
var columnNames = dataRow.Table.Columns.Cast <DataColumn>()
.Select(x => new KeyValuePair <string, int>(x.ColumnName, x.Ordinal)).ToList();
foreach (var columnName in columnNames)
{
if (columnName.Key != "Name" && columnName.Key != "Color" && !hiddenProperties.Contains(columnName.Key))
{
properties.Add(
new KeyValuePair <string, string>(MembershipProperty.GetResourceLabel(columnName.Key),
MembershipProperty.Format(columnName.Value, dataRow[columnName.Key].ToString(), false))
);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var targetFeature = PurchaseOption.Features.Upgrade;
var purchaseOption = PurchaseOption.Get(targetFeature);
if (purchaseOption.PurchaseBalanceEnabled)
{
UpgradeFromAdBalance.Visible = true;
}
else
{
UpgradeFromAdBalance.Visible = false;
adBalanceInfo.Visible = false;
}
if (AppSettings.Payments.CashBalanceEnabled && purchaseOption.CashBalanceEnabled)
{
UpgradeFromCashBalance.Visible = true;
}
else
{
UpgradeFromCashBalance.Visible = false;
cashBalanceInfo.Visible = false;
}
AccessManager.RedirectIfDisabled(AppSettings.TitanFeatures.UpgradeEnabled);
User = Member.CurrentInCache;
if (!Page.IsPostBack)
{
//Lang
LangAdder.Add(UpgradeFromAdBalance, U6012.PAYVIAPURCHASEBALANCE);
LangAdder.Add(UpgradeFromCashBalance, U6005.PAYVIACASHBALANCE);
LangAdder.Add(UpgradeViaPaymentProcessor, U6005.PAYVIAPAYMENTPROCESSOR);
//Bind the data dor DDL
BindDataToDDL();
//Visibility
UpgradeViaPaymentProcessorPlaceHolder.Visible = PaymentAccountDetails.AreIncomingPaymentProcessorsAvailable();
}
if (TitanFeatures.IsRofriqueWorkMines)
{
UpgradeFromAdBalancePlaceHolder.Visible = false;
UpgradeViaPaymentProcessorPlaceHolder.Visible = false;
}
HideCashBalanceDepositCommissionColumn = AreAllCashBalanceDepositCommissionsZero();
ddlOptions.Attributes.Add("onchange", "updatePrice();");
autopayHelpArray = new Dictionary <string, bool>();
Label10.Text = AppSettings.Memberships.TenPointsValue.ToClearString();
LabelIle.Text = AppSettings.Memberships.UpgradePointsDiscount.ToString();
//Display warning
string WarningMessage = UpgradePageHelper.GetWarningMessage(User);
WarningPanel.Visible = !String.IsNullOrEmpty(WarningMessage);
WarningLiteral.Text = WarningMessage;
AdBalanceLiteral.Text = User.PurchaseBalance.ToString();
CashBalanceLiteral.Text = User.CashBalance.ToString();
if (AppSettings.Points.LevelMembershipPolicyEnabled)
{
BuyUpgradePlaceHolder.Visible = false;
}
hiddenProperties = MembershipProperty.GetPropsToHideForClient();
TypesMembershipProperties.Text = AdPackTypeMembershipMapper.Mapper.GetHtmlFromCache();
AdPackPropsPlaceHolder.Visible = AppSettings.TitanFeatures.AdvertAdPacksEnabled;
PaymentProcessorsButtonPlaceholder.Visible = false;
}
protected void UpgradeGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//Create an instance of the datarow
var rowData = e.Row.Cells[1].Text;
//Set proper width
//e.Row.Cells[0].ControlStyle.Width = Unit.Pixel(230);
foreach (TableCell tc in e.Row.Cells)
{
if (tc != e.Row.Cells[0])
{
//tc.ControlStyle.Width = Unit.Pixel(50);
tc.ControlStyle.CssClass = "text-center";
}
}
if (hiddenProperties.Any(p => p == e.Row.Cells[0].Text))
{
e.Row.CssClass = "displaynone";
}
//Add image to index 1 (name)
if (e.Row.RowIndex == 1)
{
int indexOfUpgrade = 0;
foreach (TableCell tc in e.Row.Cells)
{
if (tc != e.Row.Cells[0])
{
string upgradeName = tc.Text;
string imageName = "standardbox";
if (upgradeName != Membership.Standard.Name)
{
//Because max premiumimagename is 7
//I know it is shitty work
imageName = (indexOfUpgrade > 7) ? "premiumbox7" : "premiumbox" + indexOfUpgrade.ToString();
}
tc.Text = "<div class=\"text-center\"><p><strong>" + upgradeName + "</strong></p><img src=\"Images/OneSite/Upgrade/" + imageName + ".png\" /></div>";
indexOfUpgrade++;
}
}
}
e.Row.Cells[0].Text = MembershipProperty.GetResourceLabel(e.Row.Cells[0].Text);
foreach (TableCell tc in e.Row.Cells)
{
if (tc != e.Row.Cells[0])
{
tc.Text = MembershipProperty.Format(e.Row.RowIndex, tc.Text);
}
}
//Add color
if (e.Row.RowIndex == 12)
{
foreach (TableCell tc in e.Row.Cells)
{
if (tc != e.Row.Cells[0])
{
tc.Text = "<div class=\"upgrade-table-label\" style=\"background-color:" + tc.Text + ";\"> </div>";
}
}
}
//Hide AutoPay price if no autopay
if (e.Row.RowIndex == 15)
{
foreach (TableCell tc in e.Row.Cells)
{
if (tc != e.Row.Cells[0] && tc.Text.Contains("$0.000"))
{
tc.Text = " ";
}
}
}
}
else if (e.Row.RowType == DataControlRowType.Header)
{
foreach (TableCell tc in e.Row.Cells)
{
tc.Text = " ";
}
}
}
public ActionResult UploadInvoice(BaseViewModel viewModel)
{
int result = 0;
string action = "Upload";
string controller = "Membership";
try
{
if (Request.Form.Files.Count > 0)
{
var file = Request.Form.Files[0];
if (file == null || file.Length == 0)
{
}
if (file != null)
{
string fileExtension = Path.GetExtension(file.FileName);
string fileName = Path.GetFileNameWithoutExtension(file.FileName);
fileName = "Invoice";
fileName = fileName + "-" + AppGlobal.DateTimeCode + fileExtension;
var physicalPath = Path.Combine(_hostingEnvironment.WebRootPath, AppGlobal.FTPUploadExcel, fileName);
using (var stream = new FileStream(physicalPath, FileMode.Create))
{
file.CopyTo(stream);
FileInfo fileLocation = new FileInfo(physicalPath);
if (fileLocation.Length > 0)
{
if ((fileExtension == ".xlsx") || (fileExtension == ".xls"))
{
using (ExcelPackage package = new ExcelPackage(stream))
{
if (package.Workbook.Worksheets.Count > 0)
{
ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
if (workSheet != null)
{
int totalRows = workSheet.Dimension.Rows;
for (int i = 2; i <= totalRows; i++)
{
Membership model = new Membership();
if (workSheet.Cells[i, 7].Value != null)
{
model.TaxCode = workSheet.Cells[i, 7].Value.ToString().Trim();
model.TaxCode = model.TaxCode.Replace(@" ", @"");
model = _membershipRepository.GetByTaxCode(model.TaxCode);
if (model != null)
{
MembershipProperty membershipProperty = new MembershipProperty();
membershipProperty.MembershipID = model.ID;
if (workSheet.Cells[i, 1].Value != null)
{
membershipProperty.PaymentCode = workSheet.Cells[i, 1].Value.ToString().Trim();
}
if (workSheet.Cells[i, 2].Value != null)
{
membershipProperty.ProductCode = workSheet.Cells[i, 2].Value.ToString().Trim();
}
decimal valueContract = 0;
if (workSheet.Cells[i, 3].Value != null)
{
try
{
valueContract = decimal.Parse(workSheet.Cells[i, 3].Value.ToString().Trim());
}
catch
{
}
}
membershipProperty = _membershipPropertyRepository.GetByMembershipIDAndPaymentCodeAndProductCode(membershipProperty.MembershipID.Value, membershipProperty.PaymentCode, membershipProperty.ProductCode);
if (membershipProperty == null)
{
membershipProperty = new MembershipProperty();
membershipProperty.MembershipID = model.ID;
if (workSheet.Cells[i, 1].Value != null)
{
membershipProperty.PaymentCode = workSheet.Cells[i, 1].Value.ToString().Trim();
}
if (workSheet.Cells[i, 2].Value != null)
{
membershipProperty.ProductCode = workSheet.Cells[i, 2].Value.ToString().Trim();
}
Config product = new Config();
if (workSheet.Cells[i, 4].Value != null)
{
product.Title = workSheet.Cells[i, 4].Value.ToString().Trim();
product = _configResposistory.GetByGroupNameAndCodeAndTitle(AppGlobal.CRM, AppGlobal.Product, product.Title);
if (product == null)
{
product = new Config();
product.Initialization(InitType.Insert, RequestUserID);
product.GroupName = AppGlobal.CRM;
product.Code = AppGlobal.Product;
product.Title = workSheet.Cells[i, 4].Value.ToString().Trim();
_configResposistory.Create(product);
}
membershipProperty.ProductID = product.ID;
}
if (membershipProperty.MembershipID > 0)
{
membershipProperty.Code = AppGlobal.Product;
membershipProperty.ValueContract = valueContract;
membershipProperty.DateBegin = DateTime.Now;
membershipProperty.DateEnd = DateTime.Now;
membershipProperty.DateContract = DateTime.Now;
membershipProperty.Address = model.Address;
membershipProperty.Initialization(InitType.Insert, RequestUserID);
_membershipPropertyRepository.Create(membershipProperty);
}
}
if (membershipProperty != null)
{
Invoice invoice = new Invoice();
invoice.ContractID = membershipProperty.ID;
invoice.Year = viewModel.YearFinance;
invoice.Month = viewModel.MonthFinance;
invoice = _invoiceRepository.GetByContractIDAndYearAndMonth(invoice.ContractID.Value, invoice.Year.Value, invoice.Month.Value);
if (invoice == null)
{
invoice = new Invoice();
invoice.ContractID = membershipProperty.ID;
invoice.Year = viewModel.YearFinance;
invoice.Month = viewModel.MonthFinance;
invoice.Initialization(InitType.Insert, RequestUserID);
invoice.ContractID = membershipProperty.ID;
invoice.Year = viewModel.YearFinance;
invoice.Month = viewModel.MonthFinance;
invoice.DateInvoice = new DateTime(invoice.Year.Value, invoice.Month.Value, 28);
invoice.Total = valueContract;
_invoiceRepository.Create(invoice);
}
if (invoice != null)
{
InvoiceProperty invoiceProperty = _invoicePropertyRepository.GetByInvoiceIDAndProductID(invoice.ID, membershipProperty.ProductID.Value);
if (invoiceProperty == null)
{
invoiceProperty = new InvoiceProperty();
invoiceProperty.Initialization(InitType.Insert, RequestUserID);
invoiceProperty.InvoiceID = invoice.ID;
invoiceProperty.ProductID = membershipProperty.ProductID;
invoiceProperty.UnitID = AppGlobal.UnitID;
invoiceProperty.Quantity = 1;
invoiceProperty.UnitPrice = valueContract;
invoiceProperty.Total = invoiceProperty.Quantity * invoiceProperty.UnitPrice;
_invoicePropertyRepository.Create(invoiceProperty);
}
}
}
}
}
}
result = 1;
}
}
}
}
}
}
}
}
}
catch (Exception e)
{
}
if (result > 0)
{
action = "Customer";
controller = "Membership";
}
return(RedirectToAction(action, controller, new { ID = result }));
}
