public static void SaveAccount(DataAccount data)
{
PlayerPrefs.SetString(
$"{Application.companyName}.account",
JsonUtility.ToJson(data));
PlayerPrefs.Save();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtUsername.Text.Trim() == "" || txtPassword.Text.Trim() == "")
{
MessageBox.Show("Thiếu Username, Password!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
try {
DataTable tb;
if (rbtnNhanVien.Checked)
{
//tb = dp.Fillbang("select ID, Ma, Ten, IDChiNhanh, IDChucVu from NhanVien where Username = N'" + txtUsername.Text.Trim() + "' and Pass = N'" + txtPassword.Text.Trim() + "'");
string[] str = new string[2];
object[] val = new object[2];
str[0] = "@username";
str[1] = "@pass";
val[0] = txtUsername.Text.Trim();
val[1] = txtPassword.Text.Trim();
//Unrepeatable read
if (DataAccount._fix)
{
tb = dp.ReadDataAddPram("sp_ReadLogin_NhanVien_Fix", str, val, 100);
}
else
{
tb = dp.ReadDataAddPram("sp_ReadLogin_NhanVien", str, val, 100);
}
}
else
{
tb = dp.Fillbang(" select ID, Ma, Ten, IDChiNhanh, 3 as IDChucVu from KhachHang where Username = N'" + txtUsername.Text.Trim() + "' and Pass = N'" + txtPassword.Text.Trim() + "'");
}
if (tb.Columns.Count < 1)
{
MessageBox.Show("Username, Password không đúng!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int idUser = Convert.ToInt16(tb.Rows[0]["ID"].ToString());
int idChiNhanh = Convert.ToInt16(tb.Rows[0]["IDChiNhanh"].ToString());
int idChucVu = Convert.ToInt16(tb.Rows[0]["IDChucVu"].ToString());
DataAccount.SetDataAccount(idUser, txtUsername.Text.Trim(), tb.Rows[0]["Ma"].ToString(), tb.Rows[0]["Ten"].ToString(), idChiNhanh, idChucVu);
MessageBox.Show("Thành công", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Dispose();
}
catch (Exception ex) {
DataAccount.ResetDataAccount();
MessageBox.Show("Lỗi Username, Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Auto increment voor unit test data
public int Insert(DataAccount account)
{
int id = GetId();
account.UserID = id;
Accounts.Add(account);
return(id);
}
private void Handler_DataAccount(DataAccount msg)
{
Kills = msg.Kills;
Deaths = msg.Deaths;
Battles = msg.Battles;
GameTime = msg.Time;
State = StatesAccountModel.Initiliazed;
CreateChangeModel(TypesChangeAccountModel.Data);
}
protected void Page_PreRender(object sender, EventArgs e)
{
DataRemember objRemember = new DataRemember();
userOnline = objRemember.getCountOnline();
DataAccount objAccount = new DataAccount();
userRegis = objAccount.getCountAccout();
}
public VariableData GetOrCreateVariable(DataAccount account, string name)
{
var result = account.Variables.Where(x => x.Name == name).FirstOrDefault();
if (result == null)
{
result = new VariableData()
{
Name = name
};
account.Variables.Add(result);
}
return(result);
}
public DataAccount GetOrCreateAccount(string slug)
{
var result = Accounts.Where(x => x.Slug == slug).FirstOrDefault();
if (result == null)
{
result = new DataAccount()
{
Slug = slug
};
Accounts.Add(result);
}
return(result);
}
public TransactionResultTypes ConsumeTransaction(DataTransaction transaction, bool addExtraTime = false)
{
if (transaction.IsExpired(addExtraTime))
{
return(TransactionResultTypes.Expired);
}
if (!transaction.IsDataTransactionValid)
{
return(TransactionResultTypes.InvalidContent);
}
var transactionResult = _dataChain.BlockStorage.HistoryContainsTransactionOrRegistration(transaction);
if (transactionResult != TransactionResultTypes.Ok)
{
return(transactionResult);
}
var accountId = transaction.AccountId;
var dataAccount = _dataChain.GetDataAccount(accountId, false);
if (dataAccount == null)
{
dataAccount = new DataAccount(accountId);
}
var type = transaction.TransactionType;
switch (type)
{
case DataTransactionTypes.FeatureRequest:
case DataTransactionTypes.Data:
case DataTransactionTypes.Attachement:
var(result, _, _) = _featureGenerator.AddTransaction(BlockTransactionGeneratorMode.Preprocess, _dataChain, transaction, dataAccount);
if (result == TransactionResultTypes.Ok)
{
_transactions.Add(transaction);
}
return(result);
}
return(TransactionResultTypes.InvalidTransaction);
}
private void button1_Click(object sender, EventArgs e)
{
if (txtPassOld.Text.Trim() == "" || txtPassNew.Text.Trim() == "")
{
MessageBox.Show("Thiếu thông tin", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
try {
DataTable tb;
if (rbtnNhanVien.Checked)
{
tb = dp.Fillbang("select ID from NhanVien where ID = " + DataAccount._idUser + " and Pass = N'" + txtPassOld.Text.Trim() + "'");
}
else
{
tb = dp.Fillbang("select ID from KhachHang where ID = " + DataAccount._idUser + " and Pass = N'" + txtPassOld.Text.Trim() + "'");
}
if (tb.Rows.Count < 1)
{
MessageBox.Show("Mật khẩu cũ không đúng!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (rbtnNhanVien.Checked)
{
dp.MyExecuteNonQuery("update NhanVien set Pass = N'" + txtPassNew.Text.Trim() + "' where ID = " + DataAccount._idUser);
}
else
{
dp.MyExecuteNonQuery("update KhachHang set Pass = N'" + txtPassNew.Text.Trim() + "' where ID = " + DataAccount._idUser);
}
DataAccount.ResetDataAccount();
MessageBox.Show("Thành công, vui lòng đăng nhập lại...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Dispose();
}
catch (Exception ex) {
MessageBox.Show("Lỗi...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Login(String acct, String pass, bool remember = false, int group = 0)
{
DataAccount objAccount = new DataAccount();
DataRow objData = objAccount.getAccount(acct);
if (objData == null)
{
Message = "Không tìm thấy tài khoản!";
return(false);
}
if (group != 0 && (int)objData["ACCT_GROUP"] != group) // Kiểm tra nhóm admin
{
Message = "Quyền hạn của bạn không đủ!";
return(false);
}
if (objData["ACCT_PASS"].ToString() != pass)
{
Message = "Mật khẩu không đúng!";
return(false);
}
//context.Session["Login"] = (int)objData["ACCT_ID"];
//context.Session["LoginPass"] = pass;
//context.Session["LoginTime"] = DateTime.Now;
//context.Session["LoginGroup"] = group;
HttpCookie loginCookie = new HttpCookie("LoginCookie");
// Lưu vào Cookie
String key = objDataRemember.addLogin((int)objData["ACCT_ID"], pass, group, remember);
loginCookie.Value = key;
loginCookie.HttpOnly = true;
//Message = key;
context.Response.Cookies.Add(loginCookie);
return(true);
}
private void mnuDX_Click(object sender, EventArgs e)
{
DataAccount.ResetDataAccount();
BlockMenu(false);
}
private async Task ProcessAccount(Credentials imapCreds, DataAccount account)
{
var mail2db = new Client(imapCreds);
var converter = new MailTypeConverter(mail2db);
var availableFolders = await mail2db.GetMailFolders();
var folders = mailFolders.IntersectCaseIgnore(availableFolders).ToList();
var filter = new ImapFilter();
foreach (var mailFolder in folders)
{
if (InvalidMailfolder(mailFolder))
{
continue;
}
try {
mail2db.SetMailFolder(mailFolder);
var countInFolder = await mail2db.GetTotalMailCount();
if (mail2db.OpenedMailFolder.IsNullOrEmpty())
{
continue;
}
Console.WriteLine($"{account.EmailAddress} mail folder: '{mail2db.OpenedMailFolder}'");
Console.WriteLine($"Total Count: {countInFolder}");
var savedMessages = await db.Query(SqlBase <DataMessage> .TableName)
.Select(nameof(DataMessage.EmailAccountId), nameof(DataMessage.UId), nameof(DataMessage.MailFolder))
.Where(new { EmailAccountId = account.Id, MailFolder = mailFolder })
.GetAsync <DataMessage>();
Console.WriteLine("Existing Uids: {0}", savedMessages.Count());
Console.WriteLine("===================\n");
converter.UIdsToExclude = savedMessages.Select(x => x.UId).ToArray();
async Task ProcessImapMessage(ImapMessage item)
{
//var TA = db.Connection.BeginTransaction();
Console.WriteLine("Saving: {0}\t{1}\"{2}\"", item?.ReceivedAtLocal,
SpacePadding(item?.From?.EmailAddress),
item?.Subject);
try {
if (!savedMessages.MessageExists(item.UId, item.MailFolder, account.Id))
{
var msgId = await db.Query(SqlBase <DataMessage> .TableName).InsertGetIdAsync <uint>(item.ToData(account.Id));
foreach (var contact in item.ToDataContact(msgId))
{
await db.Query(SqlBase <DataContact> .TableName).InsertAsync(contact);
}
if (item.HasAttachments)
{
foreach (var file in item.ToAttachment(msgId))
{
Console.WriteLine("Saving Attachment: {0}", file.Filename);
await db.Query(SqlBase <DataAttachment> .TableName).InsertAsync(file);
}
}
}
//TA.Commit();
} catch (Exception ex) {
//TA.Rollback();
Console.WriteLine(ex.Message);
}
}
await converter.GetMessagesAsync(ProcessImapMessage, filter);
} catch (Exception ex2) {
Console.WriteLine(ex2.Message);
}
GC.Collect();
Console.WriteLine("\n");
}
}
public bool isLogin(int group = 0)
{
if (context.Items["islogin"] != null)
{
if ((int)context.Items["islogin"] == 2)
{
return(false);
}
if (group != 0 && group != (int)context.Items["loginGroup"])
{
return(false);
}
return(true);
}
DataRow objData = objDataRemember.getData(SessionKey);
if (objData != null)
{
DataAccount objAccount = new DataAccount();
DataRow objDataAcct = objAccount.getAccount((int)objData["USERID"]);
if (objDataAcct != null)
{
if (objDataAcct["ACCT_PASS"].ToString() == objData["PASS"].ToString())
{
context.Items["loginAcct"] = objDataAcct;
context.Items["islogin"] = 1;
context.Items["loginGroup"] = objData["LGROUP"];
context.Items["login"] = (int)objData["USERID"];
objDataRemember.updateOnline(SessionKey);
//Message = objData["ACCT_PASS"].ToString();
return(true);
}
Logout();
}
}
context.Items["islogin"] = 2;
return(false);
//if (context.Session["Login"] == null)
//{
// if (SessionKey != null && SessionKey != "")
// {
// DataRow objData = objDataRemember.getData(SessionKey);
// if(objData != null)
// {
// context.Session["Login"] = objData["USERID"];
// context.Session["LoginPass"] = objData["PASS"];
// context.Session["LoginGroup"] = objData["LGROUP"];
// }
// }
//}
//if (context.Session["Login"] != null)
//{
// if (group == 0 || group != 0 && context.Session["LoginGroup"] != null && (int)context.Session["LoginGroup"] == group)
// {
// DataAccount objAccount = new DataAccount();
// DataRow objData = objAccount.getAccount((int)context.Session["Login"]);
// if(objData != null)
// {
// if (objData["ACCT_PASS"].ToString() == context.Session["LoginPass"].ToString())
// {
// context.Items["login"] = (int)context.Session["Login"];
// context.Items["loginAcct"] = objData;
// context.Items["islogin"] = 1;
// context.Items["loginGroup"] = group;
// if (SessionKey != null && SessionKey != "") objDataRemember.updateOnline(SessionKey);
// Message = objData["ACCT_PASS"].ToString();
// return true;
// }
// Logout();
// }
// }
//}
//context.Items["islogin"] = 2;
//return false;
}
