public async Task <IActionResult> Edit(int id, [Bind("DonateServiceId,PartnerId,Date,DonationRadiusMiles,Zipcode,Description")] DonateService donateService) { if (id != donateService.DonateServiceId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(donateService); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DonateServiceExists(donateService.DonateServiceId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(donateService)); }
public static async Task <DonateService> GetDonateServiceById(int id) { DonateService donateService = null; try { using (SqlConnection lin2worldDbConn = new SqlConnection(LIN2WORLD_CONN_STRING)) { lin2worldDbConn.Open(); using (SqlCommand cmd = lin2worldDbConn.CreateCommand()) { cmd.CommandText = "SELECT * FROM l2acp_donateservices WHERE serviceid=@SERVICE_ID"; cmd.Parameters.AddWithValue("@SERVICE_ID", id); using (SqlDataReader reader = await cmd.ExecuteReaderAsync()) { if (reader.Read()) { donateService = new DonateService(); donateService.ServiceId = reader.GetInt32(reader.GetOrdinal("serviceid")); donateService.ServiceName = reader["servicename"].ToString(); donateService.Price = reader.GetInt32(reader.GetOrdinal("price")); } } } } } catch (Exception) { donateService = null; } return(donateService); }
public ActionResult DonateList(int page = 1, int size = 10) { var list = DonateService.GetPagesFromCache <DateTime, DonateDto>(page, size, d => true, d => d.DonateTime, false); if (!CurrentUser.IsAdmin) { foreach (var item in list.Data) { item.QQorWechat = item.QQorWechat.Mask(); item.Email = item.Email.MaskEmail(); } } return(Ok(list)); }
public ActionResult DonateList(int page = 1, int size = 10) { var list = DonateService.GetPages(page, size, out int total, d => true, d => d.DonateTime, false).Select(d => new { d.NickName, d.EmailDisplay, d.QQorWechatDisplay, d.DonateTime, d.Amount, d.Via }).Cacheable().ToList(); var pageCount = Math.Ceiling(total * 1.0 / size).ToInt32(); return(PageResult(list, pageCount, total)); }
public async Task <ActionResult> DonateList(int page = 1, int size = 10) { var list = await DonateService.GetPagesFromCacheAsync <DateTime, DonateDto>(page, size, d => true, d => d.DonateTime, false); if (!CurrentUser.IsAdmin) { foreach (var item in list.Data.Where(item => !(item.QQorWechat + item.Email).Contains("匿名"))) { item.QQorWechat = item.QQorWechat?.Mask(); item.Email = item.Email?.MaskEmail(); } } return(Ok(list)); }
public async Task <IActionResult> Create(DonateService donateService, Partner partner) { if (ModelState.IsValid) { var userId = this.User.FindFirstValue(ClaimTypes.NameIdentifier); var viewerInDb = _context.Partners.Where(m => m.IdentityUserId == userId).FirstOrDefault(); var applicationDbContext = _context.Partners.Include(p => p.IdentityUser); donateService.PartnerId = viewerInDb.PartnerId; donateService.PartnerName = viewerInDb.FirstName; donateService.PartnerLat = viewerInDb.PartnerLat; donateService.PartnerLong = viewerInDb.PartnerLong; donateService.PhoneNumber = viewerInDb.PartnerPhone; _context.Add(donateService); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(donateService)); }
public static async Task <List <DonateService> > GetDonateServicesList() { List <DonateService> donateServices = new List <DonateService>(); try { using (SqlConnection lin2worldDbConn = new SqlConnection(LIN2WORLD_CONN_STRING)) { lin2worldDbConn.Open(); using (SqlCommand cmd = lin2worldDbConn.CreateCommand()) { cmd.CommandText = "SELECT * FROM l2acp_donateservices"; using (SqlDataReader reader = await cmd.ExecuteReaderAsync()) { while (reader.Read()) { DonateService donateService = new DonateService(); donateService.ServiceId = reader.GetInt32(reader.GetOrdinal("serviceid")); donateService.ServiceName = reader["servicename"].ToString(); donateService.Price = reader.GetInt32(reader.GetOrdinal("price")); donateServices.Add(donateService); } } } } } catch (Exception) { donateServices = null; } return(donateServices); }
public ActionResult DonateList(int page = 1, int size = 10) { var list = DonateService.GetPagesFromCache <DateTime, DonateDtoBase>(page, size, d => true, d => d.DonateTime, false); return(Ok(list)); }
public async Task <IActionResult> Create(DonateServicePartners donateServicePartners, Partner partner, DonateService donateService, int id) { if (ModelState.IsValid) { var userId = this.User.FindFirstValue(ClaimTypes.NameIdentifier); var viewerInDb = _context.Partners.Where(m => m.IdentityUserId == userId).FirstOrDefault(); var applicationDbContext = _context.Partners.Include(p => p.IdentityUser); donateServicePartners.PartnerId = viewerInDb.PartnerId; var donateServicee = _context.DonateServices.FindAsync(id); donateServicePartners.DonateServiceId = id; donateService.DonateServiceId = id; var phone = _context.DonateServices.Where(p => p.DonateServiceId == id).First(); var number = phone.PhoneNumber; SendSms(number).Wait(); _context.Add(donateServicePartners); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(donateServicePartners)); }
public DonateController(DonateService donateService, UserService userService) { _donateService = donateService; _userService = userService; }
public DonateController(DonateService donateService) { _donateService = donateService; }