public string getOrderEmail() { DbWithBasicFunction dbc = new DbWithBasicFunction(); if (this.isRegisteredOrder) { var userItem = dbc.db.tbl_user.Where(a => a.userId == this.userId).FirstOrDefault(); if (userItem != null) { return userItem.email; } } else { var trackInfo = dbc.db.tbl_trackInfo.Where(a => a.trackInfoId == this.trackInfoId).FirstOrDefault(); if (trackInfo != null) { return trackInfo.email; } } return ""; }
public override object BindModel(System.Web.Mvc.ControllerContext controllerContext, System.Web.Mvc.ModelBindingContext bindingContext) { Models.tbl_bankPosOption item = ((Models.tbl_bankPosOption)base.BindModel(controllerContext, bindingContext)); HttpRequestBase request = controllerContext.HttpContext.Request; var enUsCulture = CultureInfo.CreateSpecificCulture("en-US"); var trCulture = CultureInfo.CreateSpecificCulture("tr-TR"); DbWithBasicFunction dbc = new DbWithBasicFunction(); bindingContext.ModelState.Remove("paymentCount"); bindingContext.ModelState.Remove("minBasketAmount"); bindingContext.ModelState.Remove("additionalAmount"); if (dbc.db.tbl_bankPosOption.Where(a => a.bankPosId == item.bankPosId && a.bankPosOptionId != item.bankPosOptionId && a.paymentCount == item.paymentCount).Count() > 0) { bindingContext.ModelState.AddModelError("paymentCount", "Taksit sayısı işlem yapılan sanal pos için mevcut.Başka bir taksit sayısı giriniz."); return item; } #region minBasketAmount string minBasketAmount = request.Form.Get("minBasketAmount"); decimal decMinBasketAmount = 0; if (!decimal.TryParse(minBasketAmount, NumberStyles.AllowDecimalPoint, enUsCulture, out decMinBasketAmount)) { bindingContext.ModelState.AddModelError("minBasketAmount", "Uygun formatta değil. Örnek giriş 99.99"); return item; } item.minBasketAmount = decMinBasketAmount; #endregion #region additionalAmount string additionalAmount = request.Form.Get("additionalAmount"); decimal decAdditionalAmount = 0; if (!decimal.TryParse(additionalAmount, NumberStyles.AllowDecimalPoint, enUsCulture, out decAdditionalAmount)) { bindingContext.ModelState.AddModelError("additionalAmount", "Uygun formatta değil. Örnek giriş 99.99"); return item; } item.additionalAmount = decAdditionalAmount; #endregion return item; }
public Dictionary<string, string> productIdList() { var list = new Dictionary<string, string>(); DbWithBasicFunction dbf = new DbWithBasicFunction(); var productList = dbf.db.tbl_product.OrderBy(a => a.name).Select(a => new { a.productId, a.name }).ToList(); foreach (var item in productList) { list.Add(item.productId.ToString(), item.name); } return list; }
public Dictionary<int, string> bankIdList() { DbWithBasicFunction dbc = new DbWithBasicFunction(); var db = dbc.db; var list = new Dictionary<int, string>(); var dataList = db.tbl_bank.ToList(); foreach (var item in dataList) { list.Add(item.bankId, item.name); } return list; }
public Dictionary<int, string> businessList() { var list = new Dictionary<int, string>(); DbWithBasicFunction dbc = new DbWithBasicFunction(); var db = dbc.db; list.Add(0, "Bayi Seçili Değil"); var dbList = db.tbl_business.ToList(); foreach (var item in dbList) { list.Add(item.businessId, item.name); } return list; }
public Dictionary<int, string> carBrandList(int langId) { var list = new Dictionary<int, string>(); DbWithBasicFunction dbc = new DbWithBasicFunction(); var db = dbc.db; int langIdGenerated = 1; if (langId != 0) { langIdGenerated = langId; } var brandList = db.tbl_carBrand.Where(a => a.langId == langIdGenerated).AsEnumerable(); foreach (var item in brandList) { list.Add(item.carBrandId, item.name); } return list; }
public DbWithControllerWithoutMetod() { dbWithBasicFunction = new DbWithBasicFunction(); db = dbWithBasicFunction.db; }