private void btnSubmit_Click(object sender, EventArgs e) { var devoteeObj = new Devotee { Id = Convert.ToInt32(txtDevoteeId.Text), DevoteeName = txtDevoteeName.Text, Prefix = Convert.ToInt32(txtPrefixId.Text), Gothram = txtGothram.Text, PhoneNumber = txtPhoneNumber.Text, EmailId = txtEmail.Text, DoorNumber = txtDoorNumber.Text, AreaName = txtAreaName.Text, City = txtCity.Text, MandalName = txtMandalName.Text, DistrictName = txtDistrictName.Text, StateName = txtStateName.Text, OtherDetails = txtOtherDetails.Text }; var devoteeDao = new DevoteesDao(); int devoteeId = devoteeDao.Update(devoteeObj); var tokenDAO = new TokenDao(); tkn.ServicePerformDate = Convert.ToDateTime(dtpPerformDate.Value); tkn.TokenStatus = cmbTokenStatus.Text; tokenDAO.UpdateToken(tkn); }
private void btnSubmit_Click(object sender, EventArgs e) { if (cmbServiceID.Text != null && fldName.Text != "" && dtValue.Text != null) { int ServiceID = (cmbServiceID.SelectedItem as Service).Id; String fldNameValue = fldName.Text; String dtval = string.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(dtValue.Text)); var tokenDao = new TokenDao(); dgvServiceReport.AutoGenerateColumns = false; var data = tokenDao.GetServiceReport(ServiceID, fldNameValue, dtval); var totals = new Token(); totals.DevoteeName = "Totals"; //totals.SoldQuantity = data.Sum(x => x.SoldQuantity); totals.TotalCost = data.Sum(x => x.TotalCost); data.Add(totals); dgvServiceReport.DataSource = data; } else { if (cmbServiceID.Text != null) { MessageBox.Show("Select Service"); } else if (fldName.Text != null) { MessageBox.Show("Select CreatedOn / ServicePerformDate"); } else if (dtValue.Text != null) { MessageBox.Show("Select Date"); } } }
public static string Login(string username, string password) { TokenDao dao = new TokenDao(); UnitOfWork unitOfWork = new UnitOfWork(new Context()); Employee employee = unitOfWork.Employees.Find(e => e.EmployeeUserName.Equals(username) && e.EmployeePassword.Equals(password)).FirstOrDefault(); if (employee != null) // means employee exits in the database { Token token = unitOfWork.Tokens.Find(t => t.UserName.Equals(username) && t.Password.Equals(password)).FirstOrDefault(); string tokenUserName = TokenManager.ValidateToken(token.TokenValue); if (tokenUserName.Equals(username)) { return(token.TokenValue); } else { return(" "); } // we find the entire token for the respective employee } else { return(" "); } }
public async Task RefreshToken() { try { TokenDao dao = new TokenDao(connectionString); var token = dao.GetAvaliableToken(); if (token == null) { return; } if (DateTime.Now > token.ExpiresIn) { return;//已经过期的token无效 } if (DateTime.Now.AddDays(1) > token.ExpiresIn) {// 一天内到期 if (token.RefreshTimes >= 5) { return;//最多刷新5次 } await TokenRefreshRequest(token); } } catch (Exception err) { logger.LogError("刷新Token失败", err); } }
public async Task <bool> TokenRefreshRequest(TokenEntity token) { try { using (var client = HttpClientFactory.Create()) { string url = $"{domain}/oauth/renew_refresh_token?client_key={clientKey}&refresh_token={token.RefreshToken}"; var response = await client.SendAsync(new HttpRequestMessage(HttpMethod.Get, url)); var content = await response.Content.ReadAsStringAsync(); var tokenResponse = JsonConvert.DeserializeObject <TokenResponseModel>(content); if (tokenResponse?.data.error_code != 0) { return(false); } var refreshToken = tokenResponse.data.refresh_token; var expiresIn = DateTime.Now.AddSeconds(tokenResponse.data.expires_in); TokenDao dao = new TokenDao(connectionString); return(dao.RefreshToken(token.TokenId, refreshToken, expiresIn)); } } catch (Exception err) { logger.LogError("获取Token失败", err); return(false); } }
public async Task <bool> TokenRequest(string code) { using (var client = HttpClientFactory.Create()) { string url = $"{domain}/oauth/access_token?client_key={clientKey}&client_secret={clientSecret}&code={code}&grant_type={grantType}"; var response = await client.SendAsync(new HttpRequestMessage(HttpMethod.Get, url)); var content = await response.Content.ReadAsStringAsync(); var tokenResponse = JsonConvert.DeserializeObject <TokenResponseModel>(content); if (tokenResponse?.data.error_code != 0) { return(false); } var token = new TokenEntity() { AccessToken = tokenResponse.data.access_token, OpenId = tokenResponse.data.open_id, RefreshToken = tokenResponse.data.refresh_token, RefreshTimes = 0, ExpiresIn = DateTime.Now.AddSeconds(tokenResponse.data.expires_in), CreatedTime = DateTime.Now, UpdatedTime = DateTime.Now }; TokenDao dao = new TokenDao(connectionString); return(dao.CreateToken(token)); } }
/** * @author Anthony Scheeres */ private string validateRegisterUser(string username, string password, string email) { string failResponse = ResponseR.fail.ToString(); string response = failResponse; bool isValideInput = isValideUsernamePasswordEmail(username, password, email); //validate the input if so register user in the database if (isValideInput) { registerUser(username, password, email); TokenDao tokenDao = new TokenDao(); string token = tokenDao.getTokenByUsernameExtremelyClassified(username); new Thread(() => { Thread.CurrentThread.IsBackground = true; MailService mailService = new MailService(email); mailService.validateAUsersEmailUsingAValidationEmaill(username, token); }).Start(); response = ResponseR.success.ToString(); } return(response); }
private void btnSubmit_Click(object sender, EventArgs e) { int tId = 0; int.TryParse(txtId.Text, out tId); double amt = 0; amt = Convert.ToDouble(txtTotalCost.Text); var tokenDAO = new TokenDao(); if (tId == 0) { sdailyNumber = tokenDAO.getHighestDailyNumber(serviceId) + 1; dailyNumber = tokenDAO.getMaxDailyNumber(DateTime.Now) + 1; } var tokenObj = new Token { Id = tId, ServiceId = serviceId, Quantity = 1, TotalCost = amt, ServicePerformDate = Convert.ToDateTime(dtpPerformDate.Value), Status = 1, ServiceDailyNumber = sdailyNumber, DailyNumber = dailyNumber, CreatedOn = DateTime.Now, CreatedBy = App.LoggedInEmployee.Id }; tokenDAO.SaveToken(tokenObj); ShowHundials(); }
internal static TokenDao getToken() { if (tokenDao == null) { tokenDao = new TokenDao(); } return(tokenDao); }
internal static TokenDao getToken() { if (tokenDao == null) { tokenDao = new TokenDao(ConnectionProvider.getProvide()); } return(tokenDao); }
private void BatchDetailsReport_Load(object sender, EventArgs e) { //List<Token> = new BatchDao().GetBatchDetails(this.BatchId); //dgvBatchDetails var tokenObj = new TokenDao(); dgvBatchDetails.AutoGenerateColumns = false; dgvBatchDetails.DataSource = tokenObj.GetSelectedServiceDevotees(StartDailyNumberVal, LastDailyNumberVal, ServiceIDVal); }
private void ShowMiscIncomes() { var serviceDaoObj = new ServiceDao(); serviceId = serviceDaoObj.GetMiscIncomes(); var tokenDaoObj = new TokenDao(); dgvMiscIncomes.AutoGenerateColumns = false; dgvMiscIncomes.DataSource = tokenDaoObj.GetMiscIncomeDetails(); }
private void ShowHundials() { var serviceDaoObj = new ServiceDao(); serviceId = serviceDaoObj.GetHundials(); var tokenDaoObj = new TokenDao(); dgvHundial.AutoGenerateColumns = false; dgvHundial.DataSource = tokenDaoObj.GetHundialsDetails(); }
public Token GetToken(string token) { var mapper = Common.GetMapper(); TokenDao tokendao = new TokenDao(mapper); var tokens = tokendao.Query(new TokenQueryForm { AccessToken = token }); if (tokens == null || tokens.Count == 0) { return(null); } return(tokens[0]); }
private void ServicesPrintForm_Load(object sender, EventArgs e) { var tokenDao = new TokenDao(); dgvServiceReport.AutoGenerateColumns = false; var data = tokenDao.GetServiceReport(ServiceID, fldNameValue, dtval); var totals = new Token(); totals.DevoteeName = "Totals"; //totals.SoldQuantity = data.Sum(x => x.SoldQuantity); totals.TotalCost = data.Sum(x => x.TotalCost); data.Add(totals); dgvServiceReport.DataSource = data; }
private void btnSubmit_Click(object sender, EventArgs e) { long startuniid = 0; long lastuniid = 0; int serviceId = (cmbServiceName.SelectedItem as Service).Id; startuniid = new BatchDao().GetLastBatchDailyNumberByService(serviceId); int dailyBID = new BatchDao().GetDailyBatchByService(serviceId, cdtval); var tokenObj = new TokenDao(); if (startuniid == 0) { startuniid = tokenObj.getLeastDailyNumber(serviceId); lastuniid = tokenObj.getHighestDailyNumber(serviceId); } else { startuniid = startuniid + 1; lastuniid = tokenObj.getHighestDailyNumber(serviceId); } if (startuniid < lastuniid) { var batchObj = new Batch { ServiceId = serviceId, StartDailyNumber = startuniid, LastDailyNumber = lastuniid, CreatedOn = DateTime.Now, DailyBatchId = dailyBID, CreatedBy = App.LoggedInEmployee.Id }; var batchDaoObject = new BatchDao(); batchDaoObject.SaveBatch(batchObj); //batchDaoObject.GetLastBatchByService(serviceId); dgvBatchTokens.DataSource = batchDaoObject.GetAllBatches(); //dgvBatchTokens.DataSource = tokenObj.GetSelectedServiceDevotees(startuniid, lastuniid, serviceId); MessageBox.Show("Batch Data Generated Successfully."); } else { MessageBox.Show("There is no new data to generate Batch"); } }
public void RefreshToken(string token) { var mapper = Common.GetMapper(); TokenDao tokendao = new TokenDao(mapper); tokendao.Update(new TokenUpdateForm { Entity = new Token { ExpiredTime = DateTime.Now.AddHours(expiredHours) }, QueryForm = new TokenQueryForm { AccessToken = token }, }); }
private void btnSubmit_Click(object sender, EventArgs e) { var tokens = new TokenDao().ProcessTokens(_selectedTokens.ToList(), _selectedDevotees.ToList()); PrintTokens(tokens); }
/// <summary> /// 保存Ticket /// </summary> /// <param name="ticket"></param> private static void SaveTicket(TokenInfo ticket) { TokenDao.InsertOrUpdate(ticket); }
/// <summary> /// 从存储获取Ticket /// </summary> /// <param name="account"></param> /// <param name="ticketType"></param> /// <returns></returns> private static TokenInfo GetTicketFromStorage(AppAccountInfo account, string ticketType) { var result = TokenDao.Get(account.AppId + account.AppSecret + ticketType); return(result); }
public async Task DownloadVideoList() { try { TokenDao tokenDao = new TokenDao(connectionString); var token = tokenDao.GetAvaliableToken(); if (token == null) { logger.LogWarning("没有可用的Token"); return; } using (var client = HttpClientFactory.Create()) { string url = $"{domain}/video/list?open_id={token.OpenId}&access_token={token.AccessToken}&cursor={0}&count={pageCount}"; var response = await client.SendAsync(new HttpRequestMessage(HttpMethod.Get, url)); var content = await response.Content.ReadAsStringAsync(); var videoListResponse = JsonConvert.DeserializeObject <VideoListResponseModel>(content); if (videoListResponse?.data.error_code != 0) { logger.LogError($"请求Token失败:{videoListResponse?.data?.error_code} {videoListResponse?.data?.description}"); return; } List <VideoEntity> entities = new List <VideoEntity>(); var dao = new VideoDao(connectionString); videoListResponse?.data?.list?.ForEach(t => { entities.Add(new VideoEntity() { ItemId = t.item_id, VideoStatus = t.video_status, Title = t.title, CreateTime = StampToDateTime(t.create_time), Cover = t.cover, ShareUrl = t.share_url, CommentCount = t.statistics.comment_count, DiggCount = t.statistics.digg_count, DownloadCount = t.statistics.download_count, ForwardCount = t.statistics.forward_count, PlayCount = t.statistics.play_count, ShareCount = t.statistics.share_count, ReceiveTime = DateTime.Now }); }); if (entities.Count == 0) { return; } var existIds = dao.GetVideosByItemIds(entities.Select(t => t.ItemId).ToArray()) .Select(t => t.ItemId) .ToArray(); var newEntities = entities .Where(t => !existIds.Contains(t.ItemId)) .ToList(); dao.CreateVideo(newEntities); } } catch (Exception err) { logger.LogError("获取视频列表失败", err); } }
public LoginResult Login(string userName, string password) { var mapper = Common.GetMapper(); UserDao userdao = new UserDao(mapper); TokenDao tokendao = new TokenDao(mapper); UserPasswordDao updao = new UserPasswordDao(mapper); var ups = updao.Query(new UserPasswordQueryForm { UserName = userName, Password = password }); if (ups == null || ups.Count == 0) { throw new XinLuClubException(102, "账号或者密码错误"); } var users = userdao.Query(new UserQueryForm { Name = userName }); if (users == null || users.Count == 0) { throw new XinLuClubException(103, "账号信息不存在"); } var user = users[0]; var userid = user.ID; var tokens = tokendao.Query(new TokenQueryForm { UserID = userid }); IIDGenerator generator = IDGeneratorFactory.Create(GeneratorType.GUID); string tokenstring = generator.Generate(); Token token = null; if (tokens == null || tokens.Count == 0) { token = new Token { ExpiredTime = DateTime.Now.AddHours(expiredHours), UserID = userid, AccessToken = tokenstring, }; tokendao.Add(token); } else { token = tokens[0]; token.ExpiredTime = DateTime.Now.AddHours(expiredHours); token.AccessToken = tokenstring; tokendao.Update(new TokenUpdateForm { Entity = new Token { AccessToken = token.AccessToken, ExpiredTime = token.ExpiredTime, }, QueryForm = new TokenQueryForm { ID = token.ID, } }); } SaveMe(user); LoginResult result = new LoginResult { Token = token, User = user, }; return(result); }
/// <summary> /// 从存储获取Token /// </summary> /// <param name="account"></param> /// <returns></returns> private static TokenInfo GetTokenFromStorage(AppAccountInfo account) { var result = TokenDao.Get(account.AppId + account.AppSecret); return(result); }
public async Task <string> GetVideoUrl(string itemId) { try { TokenDao tokenDao = new TokenDao(connectionString); var token = tokenDao.GetAvaliableToken(); if (token == null) { logger.LogWarning("没有可用的Token"); return(null); } using (var client = HttpClientFactory.Create()) { string url = $"{domain}/video/data?open_id={token.OpenId}&access_token={token.AccessToken}"; //var response = await client.SendAsync(new HttpRequestMessage(HttpMethod.Post, url)); var str = JsonConvert.SerializeObject(new { item_ids = new[] { itemId } }); HttpContent requestContent = new StringContent(str); requestContent.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json"); var response = await client.PostAsync(url, requestContent); var content = await response.Content.ReadAsStringAsync(); var videoListResponse = JsonConvert.DeserializeObject <VideoListResponseModel>(content); if (videoListResponse?.data.error_code != 0) { logger.LogError($"请求Token失败:{videoListResponse?.data?.error_code} {videoListResponse?.data?.description}"); return(null); } List <VideoEntity> entities = new List <VideoEntity>(); var dao = new VideoDao(connectionString); videoListResponse?.data?.list?.ForEach(t => { entities.Add(new VideoEntity() { ItemId = t.item_id, VideoStatus = t.video_status, Title = t.title, CreateTime = StampToDateTime(t.create_time), Cover = t.cover, ShareUrl = t.share_url, CommentCount = t.statistics.comment_count, DiggCount = t.statistics.digg_count, DownloadCount = t.statistics.download_count, ForwardCount = t.statistics.forward_count, PlayCount = t.statistics.play_count, ShareCount = t.statistics.share_count, ReceiveTime = DateTime.Now }); }); if (entities.Count == 0) { return(null); } return(entities.FirstOrDefault()?.ShareUrl); } } catch (Exception err) { logger.LogError("获取视频列表失败", err); return(null); } }
/// <summary> /// 保存Token /// </summary> /// <param name="token"></param> private static void SaveToken(TokenInfo token) { TokenDao.InsertOrUpdate(token); }
private void button1_Click(object sender, EventArgs e) { var VIPDaoObj = new VIPPrasadamDao(); var abc = VIPDaoObj.GetDaycount(this.dtpFromDate.Value); var dt1 = String.Format("{0:dd-MM-yyyy}", this.dtpFromDate.Value); int i = 0; String VIPContent = "అతిధి సత్కారం కొరకు " + dt1 + " తేదిన వినియోగించిన సరుకు వివరములు : "; while (i < abc.Count) { var xyz = abc[i] as VIPPrasadam; VIPContent = VIPContent + xyz.ServiceName + " " + xyz.Qty; i = i + 1; if (i < abc.Count) { VIPContent = VIPContent + ", "; } } if (abc.Count == 0) { VIPContent = ""; } DateTime cdatetime = DateTime.Now; var cdt = String.Format("{0:dd-MM-yyyy h:mm tt}", cdatetime); var DCRGenDT = "Generated on : " + cdt; var reportViewer = new ReportViewer(); reportViewer.HeaderWidthPercent = 100; reportViewer.ContentWidthPercent = 100; reportViewer.RowsPerPage = 30; var duration = dtpToDate.Value - dtpFromDate.Value; if (duration.Days > 0) { reportViewer.HeaderContent = string.Format("<center><h2>Daily Collection Report from {0:dd/MM/yyyy} to {1:dd/MM/yyyy}</h2></center>", this.dtpFromDate.Value, this.dtpToDate.Value); } else { reportViewer.HeaderContent = string.Format("<center><h2>Daily Collection Report for the Date of {0:dd/MM/yyyy}</h2></center>", this.dtpFromDate.Value); } if (VIPContent != "") { reportViewer.FooterContent = string.Format("<span><br />{0}</span>", VIPContent); } var tokenDAO = new TokenDao(); Double CashDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "Cash"); Double CardDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "Credit/Debit Card"); Double DDDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "DD"); Double ChequeDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "Cheque"); var DCRCashDT = "Amount from Cash Transactions : Rs." + CashDt + "/-"; var DCRCardDT = "Amount from Card Transactions : Rs." + CardDt + "/-"; var DCRDDDT = "Amount from DD Transactions : Rs." + DDDt + "/-"; var DCRChequeDT = "Amount from Cheque Transactions : Rs." + ChequeDt + "/-"; reportViewer.FooterContent = reportViewer.FooterContent + string.Format("<span><br />{0}</span>", DCRGenDT); reportViewer.FooterContent = reportViewer.FooterContent + string.Format("<span><br />{0} {1}</span>", DCRCashDT, DCRCardDT); reportViewer.FooterContent = reportViewer.FooterContent + string.Format("<span><br />{0} {1}</span>", DCRDDDT, DCRChequeDT); reportViewer.GenerateFromGridView(this.dgvReport, false); reportViewer.Show(this); }