public static void generateInvoice() { int idx = idxH_Trans; H_Trans_ItemModel hti = new H_Trans_ItemModel(); DataRow row = hti.Table.Select($"ID ='{list_htrans[idx].ID}'").FirstOrDefault(); if (row["STATUS"].ToString() == "P") { CustomerInvoice customerInvoice = new CustomerInvoice(); ReportView rv = new ReportView(customerInvoice); rv.setParam("kodeH_Trans", row["KODE"].ToString()); if (row["ID_PROMO"].ToString() == "") { rv.setParam("kodePromo", "-"); } else { PromoModel pm = new PromoModel(); DataRow rowPromo = pm.Table.Select($"ID = '{row["ID_PROMO"]}'").First(); rv.setParam("kodePromo", rowPromo["KODE"].ToString()); } string path = (ImageHelper.getDebugPath() + "\\Resource\\Items\\"); rv.setParam("imagePath", path); rv.ShowDialog(); } else { MessageBox.Show("Transaksi yang belum dibayar!"); } }
private async Task UpsertPromoCodeAsync(PromoModel promo) { if (promo != null) { var existingPromo = await _context.Promos.FirstOrDefaultAsync(x => x.Id == promo.Id || x.Code == promo.Code); if (existingPromo != null) { existingPromo.ApplicableParts = promo.ApplicableParts; existingPromo.Code = promo.Code; existingPromo.DiscountAmount = promo.DiscountAmount; existingPromo.DiscountPercentage = promo.DiscountPercentage; existingPromo.Enabled = promo.Enabled; existingPromo.ExpirationDate = promo.ExpirationDate; existingPromo.TimesUsed = promo.TimesUsed; existingPromo.UsageLimit = promo.UsageLimit; _context.Promos.Update(existingPromo); } else { _context.Promos.Add(promo); } await _context.SaveChangesAsync(); } }
public PromoModel GeneratePromoModel() { PromoModel model = new PromoModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var tableList = from p in vdc.Promos.ToList() orderby p.PromoId ascending select p; if (tableList != null) { if (tableList.FirstOrDefault() != null) { model = new PromoModel(); model.PromoId = tableList.FirstOrDefault().PromoId; model.PromoTitle = tableList.FirstOrDefault().PromoTitle; model.PromoDescription = tableList.FirstOrDefault().PromoDescription; model.ImageString = tableList.FirstOrDefault().ImageString; } } return(model); } } catch (Exception ex) { throw ex; } }
public PromoModel GeneratePromoModel() { PromoModel model = new PromoModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var tableList = from p in vdc.Promos.ToList() orderby p.PromoId ascending select p; if (tableList != null) { if (tableList.FirstOrDefault() != null) { model = new PromoModel(); model.PromoId = tableList.FirstOrDefault().PromoId; model.PromoTitle = tableList.FirstOrDefault().PromoTitle; model.PromoDescription = tableList.FirstOrDefault().PromoDescription; model.ImageString = tableList.FirstOrDefault().ImageString; } } return model; } } catch (Exception ex) { throw ex; } }
private void btnAdd_Click(object sender, RoutedEventArgs e) { if (cmbPromos.Visibility != Visibility.Hidden) { if (verifySelection()) { PromoModel promo = cmbPromos.SelectedItem as PromoModel; addServiceToPromo(promo.ID); //label.Content = "Promo Name: " + promo.PromoName; loadDataGridServices(promo.ID); } } else { ServiceTypeModel selectService = cmbServices.SelectedItem as ServiceTypeModel; if (selectService != null) { addServiceToPromo(insertedPromoID); loadDataGridServices(insertedPromoID); } else { MessageBox.Show("Please select Service!"); } } }
public static void initPromotion(ComboBox comboBox, TextBlock discount, TextBlock tbError) { tbDiscount = discount; tbErrorPromotion = tbError; PromoModel pm = new PromoModel(); list_promo = new List <Promo>(); foreach (DataRow row in pm.Table.Select("STATUS = '1'")) { Promo p = new Promo( id: row["ID"].ToString(), kode: row["KODE"].ToString(), potongan: Convert.ToInt32(row["POTONGAN"]), potonganMax: Convert.ToInt32(row["POTONGAN_MAKS"]), hargaMin: Convert.ToInt32(row["HARGA_MIN"]), jenisPotongan: row["JENIS_POTONGAN"].ToString(), idJenisPromo: Convert.ToInt32(row["ID_JENIS_PROMO"]), tanggalAwal: Utility.dateParse(row["TANGGAL_AWAL"].ToString()), tanggalAkhir: Utility.dateParse(row["TANGGAL_AKHIR"].ToString()), status: row["STATUS"].ToString() ); list_promo.Add(p); } comboBox.ItemsSource = list_promo; comboBox.SelectedValuePath = "ID"; }
public PromoViewModel() { cm = new PromoModel(); forid = new PromoModel(); forcb = new PromoModel(); masaberlaku = new PromoModel(); reload(); }
// GET: /<controller>/ public async Task <IActionResult> Index() { var session = HttpContext.Session.GetString(sessionKey); var user = await _userManager.GetUserAsync(HttpContext.User); if (session == null) { return(View(new ShoppingCartViewModel())); } else { var cart = await Task.Factory.StartNew(() => JsonConvert.DeserializeObject <ShoppingCartViewModel>(session)); UserReferral referralCookie = null; PromoModel refPromo = null; if (HttpContext.Request.Cookies["Referral"] != null) { referralCookie = await Task.Factory.StartNew(() => JsonConvert.DeserializeObject <UserReferral>(HttpContext.Request.Cookies["Referral"])); if (referralCookie != null) { refPromo = await _context.Promos.FirstOrDefaultAsync(x => x.Code == referralCookie.ReferralCode); } } if (user != null) { var userRef = await _context.UserReferral.FirstOrDefaultAsync(x => x.UserId == user.Id); cart.UserReferral = userRef; } if (TempData["StoreCredit"] != null) { decimal StoreCredit = decimal.Parse(TempData["StoreCredit"].ToString()); decimal total = 0m; foreach (var product in cart.Products) { total += product.Price; } decimal newTotal = ((total - StoreCredit) <= 0) ? 0.01m : (total - StoreCredit); cart.NewTotal = newTotal; } else if (TempData["RefPromo"] == null && refPromo != null) { if ((user != null && referralCookie.UserId != user.Id) || user == null) { return(RedirectToAction("PromoCode", "ShoppingCart", new { promoCode = refPromo.Code })); } } return(View(cart)); } }
public async Task <IActionResult> UpsertPromo(PromoModel promo, IEnumerable <int> PartIds) { promo.Code = promo.Code.ToUpper(); promo.UsageLimit = (promo.UsageLimit != null && promo.UsageLimit == 0) ? null : promo.UsageLimit; if (promo.ExpirationDate.HasValue) { promo.ExpirationDate = promo.ExpirationDate.Value.ToUniversalTime(); } promo.ApplicableParts = new List <ProductModel>(); if (PartIds.Count() > 0) { foreach (var id in PartIds) { var part = await _context.Products.Include(x => x.Brand) .Include(x => x.CarProducts).Include(x => x.Images) .FirstOrDefaultAsync(x => x.PartId == id); promo.ApplicableParts.Add(part); } } var existing = await _context.Promos.Include(x => x.ApplicableParts).FirstOrDefaultAsync(x => x.Id == promo.Id); if (existing != null) { existing.Code = promo.Code; existing.Enabled = promo.Enabled; existing.ExpirationDate = promo.ExpirationDate; existing.ApplicableParts = promo.ApplicableParts; existing.DiscountPercentage = promo.DiscountPercentage; existing.DiscountAmount = promo.DiscountAmount; existing.UsageLimit = promo.UsageLimit; TempData["Message"] = "Promo successfully updated."; } else { if (await _context.Promos.AnyAsync(x => x.Code.ToUpper() == promo.Code)) { TempData["Message"] = $"A promo already exists with the code: {promo.Code.ToUpper()}"; ModelState.AddModelError("Promo Code", "Promo code already exists."); return(RedirectToAction("UpsertPromo")); } _context.Promos.Add(promo); TempData["Message"] = "Promo successfully added."; } await _context.SaveChangesAsync(); if (promo.Id == 0) { return(RedirectToAction("ManagePromos", "Admin")); } return(RedirectToAction("UpsertPromo", new { id = promo.Id })); }
public ActionResult Details(Guid?promotionId) { if (promotionId.HasValue) { this.AccountBase.SetupActionAccount(); var pm = new PromoModel(this.AccountBase, promotionId.Value); return(View(pm)); } else { return(View("Error")); } }
public async Task <PromoModel> GetPromoAsync(UserReferral userReferral) { var refPromo = await _context.Promos.FirstOrDefaultAsync(x => x.Code == userReferral.ReferralCode); PromoModel promo = null; if (refPromo != null) { promo = await GetPromoAsync(refPromo.Id); } return(promo); }
private void btnEdit_Click(object sender, RoutedEventArgs e) { PromoModel proMod = dgvPromos.SelectedItem as PromoModel; if (proMod != null) { PromoDetails promoDetails = new PromoDetails(this, proMod); promoDetails.ShowDialog(); } else { MessageBox.Show("No Records selected!"); } }
public async Task <IActionResult> UpsertPromo(int?id) { PromoModel promo; if (id == null) { promo = new PromoModel(); } else { promo = await _context.Promos.Include(x => x.ApplicableParts).FirstOrDefaultAsync(x => x.Id == id); } ViewData["AllParts"] = await _context.Products.ToListAsync(); return(View(promo)); }
private void fillPromoName() { PromoModel promo = new PromoModel(); queryString = "SELECT dbspa.tblpromo.ID, promoname FROM dbspa.tblpromo WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { promo.ID = reader["ID"].ToString(); promo.PromoName = reader["promoname"].ToString(); cmbPromos.Items.Add(promo); promo = new PromoModel(); } conDB.closeConnection(); }
public void OnGetPromo(PromoModel promo, AdaptyError error) { if (error != null) { Debug.Log("Error message: " + error.message + ", code: " + error.code); } else { if (promo != null) { Debug.Log("Promo promoType:" + promo.promoType + ", expiresAt:" + promo.expiresAt); } else { Debug.Log("No promo"); } } }
public void UpdatePromo(PromoModel model) { try { Promo table = new Promo(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.Promos.Single(a => a.PromoId == model.PromoId); table.PromoId = model.PromoId; table.PromoTitle = model.PromoTitle; table.PromoDescription = model.PromoDescription; table.ImageString = model.ImageString; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
private bool verifySelection() { bool ifAllCorrect = false; PromoModel selectPromo = cmbPromos.SelectedItem as PromoModel; ServiceTypeModel selectService = cmbServices.SelectedItem as ServiceTypeModel; if (selectPromo == null) { MessageBox.Show("Please select Promo Name!"); } else if (selectService == null) { MessageBox.Show("Please select Service!"); } else { ifAllCorrect = true; } return(ifAllCorrect); }
private void loadDataGridDetails() { PromoModel promo = new PromoModel(); List <PromoModel> lstPromos = new List <PromoModel>(); queryString = "SELECT ID, promoname, price, commission FROM dbspa.tblpromo WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { promo.ID = reader["ID"].ToString(); promo.PromoName = reader["promoname"].ToString(); promo.PromoPrice = Convert.ToDouble(reader["price"].ToString()); promo.Commission = reader["commission"].ToString(); lstPromos.Add(promo); promo = new PromoModel(); } conDB.closeConnection(); dgvPromos.ItemsSource = lstPromos; }
// GET: Promo public ActionResult Index() { PromoADM promos = new PromoADM(); List <Promocion> promociones = promos.obtenerPromos(); List <PromoModel> listPromo = new List <PromoModel>(); foreach (Promocion prom in promociones) { PromoModel promoModel = new PromoModel(); promoModel.id = prom.id; promoModel.articulo = prom.articulo; promoModel.cantidadLlevar = prom.cantidadLlevar; promoModel.cantLleva = prom.cantLleva; promoModel.cantPaga = prom.cantPaga; promoModel.descuento = prom.descuento; promoModel.descripcion = prom.descripcion; promoModel.tipo = prom.tipo; listPromo.Add(promoModel); } //var ret = Mapper.Map<IList< Promocion >,IList<PromoModel>>( promos.obtenerPromos()); return(View(listPromo.ToPagedList(1, paginaLargo))); }
private void loadDataGridServices() { PromoModel pm = cmbPromos.SelectedItem as PromoModel; List <PromoServicesModel> lstPromoServ = new List <PromoServicesModel>(); PromoServicesModel promoServ = new PromoServicesModel(); queryString = "SELECT dbspa.tblpromoservices.ID, dbspa.tblpromo.promoname, dbspa.tblservicetype.serviceType, " + "dbspa.tblservicetype.description FROM((dbspa.tblpromoservices INNER JOIN dbspa.tblpromo ON dbspa.tblpromoservices.promoID = dbspa.tblpromo.ID) " + "INNER JOIN dbspa.tblservicetype ON dbspa.tblpromoservices.serviceID = dbspa.tblservicetype.ID) " + "WHERE dbspa.tblpromoservices.isDeleted = 0 AND dbspa.tblpromoservices.promoID = ?"; parameters = new List <string>(); if (pm != null) { parameters.Add(pm.ID); } else { parameters.Add(""); } MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { promoServ.ID = reader["ID"].ToString(); promoServ.PromoName = reader["promoname"].ToString(); promoServ.ServiceName = reader["description"].ToString(); lstPromoServ.Add(promoServ); promoServ = new PromoServicesModel(); } conDB.closeConnection(); dgvPromoServices.ItemsSource = lstPromoServ; }
private void GetPromosIfAny(IIberObject chkObject, PosCheck posCheck) { try { var dicPromos = new Dictionary <long, PromoModel>(); foreach (IIberObject objInternal in chkObject.GetEnum(INTERNAL_CHECKS_PROMOS)) { var promoModel = new PromoModel { PromoEntryId = objInternal.GetLongVal("ID"), PromoTypeId = objInternal.GetLongVal("PROMOTION_ID") }; var lstEntries = (from IIberObject objElement in objInternal.GetEnum(INTERNAL_PROMOS_ITEMS) select objElement.GetLongVal("ID")).ToList(); promoModel.LstEntries = lstEntries; dicPromos.Add(promoModel.PromoEntryId, promoModel); } posCheck.Promos = dicPromos; } catch { //return null; } }
public async Task <IActionResult> UpdateRole(string email, string newRole) { if (!string.IsNullOrEmpty(email) && !string.IsNullOrEmpty(newRole)) { var user = await _userManager.FindByEmailAsync(email); var currentRoles = await _userManager.GetRolesAsync(user); var userRef = await _context.UserReferral.FirstOrDefaultAsync(x => x.UserId == user.Id); var refPromo = await _context.Promos.FirstOrDefaultAsync(x => x.Code == user.Email.Split('@')[0]); if (!currentRoles.Contains(newRole)) { // Change Roles var removeRoleResult = await _userManager.RemoveFromRolesAsync(user, currentRoles); if (removeRoleResult.Succeeded) { await _userManager.AddToRoleAsync(user, newRole); } await _context.SaveChangesAsync(); switch (newRole.ToUpper()) { case "SPONSOR": if (userRef == null) { userRef = new UserReferral { UserId = user.Id, Enabled = true, ReferralCode = user.Email.Split('@')[0], PayoutPercent = 100, StoreCreditPercent = 10 }; } if (refPromo == null) { refPromo = new PromoModel { Code = userRef.ReferralCode, DiscountPercentage = 3, Enabled = true }; } userRef.Enabled = true; userRef.PayoutPercent = 100; userRef.StoreCreditPercent = 3; refPromo.Enabled = true; await UpsertUserReferralAsync(userRef); await UpsertPromoCodeAsync(refPromo); break; case "DEFAULT": default: if (userRef != null) { userRef.Enabled = false; } if (refPromo != null) { refPromo.Enabled = false; } await UpsertUserReferralAsync(userRef); await UpsertPromoCodeAsync(refPromo); break; } } } return(RedirectToAction("ManageUsers", "Admin")); }
public ActionResult Details(Guid? promotionId) { if (promotionId.HasValue) { this.AccountBase.SetupActionAccount(); var pm = new PromoModel(this.AccountBase, promotionId.Value); return View(pm); } else { return View("Error"); } }
public void OnPromoReceived(PromoModel promo) { Debug.Log("Promo promoType:" + promo.promoType + ", expiresAt:" + promo.expiresAt); }
public PromoDetails(PromoWindow pw, PromoModel pm) { promoWindow = pw; promoModel = pm; InitializeComponent(); }