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);
}
