public void CreateOrUpdateCodes(CodeDto input) { if (input.tableIndex == 1)//Currency { var client = new CountryandCurrency() { Id = input.Id, CountryAndCurrency = input.Description, CurrencyCode = input.Code, LastModificationTime = DateTime.Now }; _countryandcurrency.InsertOrUpdate(client); } else if (input.tableIndex == 1)//Countries { var client = new Countries() { Id = input.Id, Country = input.Description, Code = input.Code, LastModificationTime = DateTime.Now }; _countries.InsertOrUpdate(client); } }
public ActionResult Index(CodeDto search) { IQueryable <PrivacyGroupDto> results; // privacys.OrderByDescending(pv => pv.PCMSID).Skip(search.startIndex * search.pageSize).Take(search.pageSize).ToList(); if (string.IsNullOrEmpty(search.searchname)) { if (search.onekey == null || search.onekey.Length == 0) { results = from p in db.Privacies where p.OneKey != null && p.status == Status.PrivacyStatus.GRANTED group p by p.OneKey into g select new PrivacyGroupDto { OneKey = g.Key, Count = g.Count(), Name = g.OrderBy(p => p.IND_FULL_NAME).FirstOrDefault().IND_FULL_NAME, Privacies = g.OrderBy(p => p.IND_FULL_NAME) } } ; else { results = from p in db.Privacies where p.OneKey.Contains(search.onekey) && p.status == Status.PrivacyStatus.GRANTED group p by p.OneKey into g select new PrivacyGroupDto { OneKey = g.Key, Count = g.Count(), Name = g.OrderBy(p => p.IND_FULL_NAME).FirstOrDefault().IND_FULL_NAME, Privacies = g.OrderBy(p => p.IND_FULL_NAME) } } ; } else { if (search.onekey == null || search.onekey.Length == 0) { results = from p in db.Privacies where p.OneKey != null && p.status == Status.PrivacyStatus.GRANTED && p.IND_FULL_NAME.Contains(search.searchname) group p by p.OneKey into g select new PrivacyGroupDto { OneKey = g.Key, Count = g.Count(), Name = g.OrderBy(p => p.IND_FULL_NAME).FirstOrDefault().IND_FULL_NAME, Privacies = g.OrderBy(p => p.IND_FULL_NAME) } } ; else { results = from p in db.Privacies where p.OneKey.Contains(search.onekey) && p.status == Status.PrivacyStatus.GRANTED && p.IND_FULL_NAME.Contains(search.searchname) group p by p.OneKey into g select new PrivacyGroupDto { OneKey = g.Key, Count = g.Count(), Name = g.OrderBy(p => p.IND_FULL_NAME).FirstOrDefault().IND_FULL_NAME, Privacies = g.OrderBy(p => p.IND_FULL_NAME) } } ; } search.totalCount = results.Count(); search.list = results.OrderBy(r => r.OneKey).Skip(search.startIndex * search.pageSize).Take(search.pageSize).ToList(); ViewBag.CompaniesList = GetCompanyList.GetCompany(); return(View(search)); }
public void CreateOrUpdateBank(CodeDto input) { var client = new Banks() { Id = input.Id, BankName = input.Description, CountryID = input.CountryID, LastModificationTime = DateTime.Now }; _bank.InsertOrUpdate(client); }
protected override void Act() { Returned = Sut.Create(UnhandledCode); }
protected override void Act() { Returned = Sut.Map(UnhandledCode); }
public async Task <IActionResult> Authenticate([FromBody] CodeDto authorizationCode) { return(await _authenticationService.Authenticate(authorizationCode.Code)); }
public ActionResult XlsDownload(CodeDto search) { // Data var privacys = db.Privacies.Where(p => p.OneKey != null && p.status == Status.PrivacyStatus.GRANTED); if (!string.IsNullOrEmpty(search.onekey)) { privacys = privacys.Where(p => p.OneKey.Contains(search.onekey)); } if (!string.IsNullOrEmpty(search.searchname)) { privacys = privacys.Where(p => p.IND_FULL_NAME.Contains(search.searchname)); } privacys = privacys.OrderBy(p => p.OneKey).OrderBy(p => p.NucleusKey); // Xls export var wb = new XLWorkbook(); var sheetname = DateTime.UtcNow.ToString("yyyyMMddHHmmss"); var ws = wb.Worksheets.Add("CodeMatch" + sheetname); ws.Cell("A1").Value = "NucleusKey"; ws.Cell("B1").Value = "OneKey"; ws.Cell("C1").Value = "PCMSID"; ws.Cell("D1").Value = "근무처(병원명)"; ws.Cell("E1").Value = "근무처연락처"; ws.Cell("F1").Value = "우편번호"; ws.Cell("G1").Value = "주소"; ws.Cell("H1").Value = "진료과"; ws.Cell("I1").Value = "직위"; ws.Cell("J1").Value = "고객명"; ws.Cell("K1").Value = "이메일"; ws.Cell("L1").Value = "핸드폰"; ws.Cell("M1").Value = "수신거부여부"; ws.Cell("N1").Value = "수집/이용동의"; ws.Cell("O1").Value = "위탁동의"; ws.Cell("P1").Value = "국외이전동의"; ws.Cell("Q1").Value = "서명여부"; ws.Cell("R1").Value = "동의서 버전"; ws.Cell("S1").Value = "동의일자"; ws.Cell("T1").Value = "동의채널"; List <Privacy> list = privacys.ToList(); int row = 2; foreach (Privacy p in list) { ws.Cell(row, 1).Value = p.NucleusKey; ws.Cell(row, 2).Value = p.OneKey; ws.Cell(row, 3).Value = p.PCMSID; ws.Cell(row, 4).Value = p.WKP_NAME; ws.Cell(row, 5).Value = p.WKP_TEL; ws.Cell(row, 6).Value = p.ZIP; ws.Cell(row, 7).Value = p.FULL_ADDR; ws.Cell(row, 8).Value = p.IND_SP; ws.Cell(row, 9).Value = p.TITLE; ws.Cell(row, 10).Value = p.IND_FULL_NAME; ws.Cell(row, 11).Value = p.EMAIL; ws.Cell(row, 12).Value = p.MOBILE; ws.Cell(row, 13).Value = p.Unsubscribe; ws.Cell(row, 14).Value = p.CONSENT_USE; ws.Cell(row, 15).Value = p.CONSENT_TRUST; ws.Cell(row, 16).Value = p.CONSENT_ABROAD; ws.Cell(row, 17).Value = p.CONSENT_SIGN; ws.Cell(row, 18).Value = p.CONSENT.CONSENT_VERSION; ws.Cell(row, 19).Value = p.CONSENT.CONSENT_DATE_KOREA; ws.Cell(row, 20).Value = p.CONSENT.CONSENT_SOURCE; row++; } Stream fs = new MemoryStream(); wb.SaveAs(fs); fs.Position = 0; var cd = new System.Net.Mime.ContentDisposition { FileName = "pcms_code_" + sheetname + ".xlsx", Inline = true, }; Response.AppendHeader("Content-Disposition", cd.ToString()); return(File(fs, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")); }