public DatabaseProvider()
{
Users = new UsersData();
Roles = new RolesData();
Households = new HouseholdsData();
Audits = new AuditData();
Permissions = new PermissionsData();
}
private void AddNewRow()
{
try
{
//从3000以后的作为临时用户
//todo 权限控制
DataRow newRow = UsersData.NewRow();
txt_ID.Text = "00123";
if (txt_ID.Text.Trim() != "00")
{
string extraCodeLong = txt_ID.Text.Trim().Insert(0, "000000");
string strLoginCode = extraCodeLong.Substring(extraCodeLong.Length - 6, 6);
newRow["ID"] = strLoginCode;
}
newRow["Name"] = txt_Name.Text;
newRow["DEPTID"] = m_App.User.CurrentDeptId;
newRow["WARDID"] = m_App.User.CurrentWardId;
//newRow["NarcosisMark"] = DBNull.Value;
DateTime now = DateTime.Now;
string encryptDateTime = now.ToString("yyyyMMdd") + now.ToString("T");
newRow["Passwd"] = HisEncryption.EncodeString(
encryptDateTime, HisEncryption.PasswordLength, txt_Pswd.Text.Trim().ToString());
newRow["RegDate"] = encryptDateTime;
newRow["JOBID"] = m_App.User.GWCodes;
newRow["Operator"] = m_App.User.Id;
//string regdate = string.Empty;
//CreateUserPassword(txt_Pswd.Text, out regdate, out pswd);
//newRow["Passwd"] = pswd;
//newRow["RegDate"] = regdate;
//newRow["Operator"] = m_App.User.ID;
newRow["Valid"] = 1;
newRow["Status"] = 0;
UsersData.Rows.Add(newRow);
DataRow newTpRow = TempUsers.NewRow();
if (txt_ID.Text.Trim() != "00")
{
string extraCodeLong = txt_ID.Text.Trim().Insert(0, "000000");
string strLoginCode = extraCodeLong.Substring(extraCodeLong.Length - 6, 6);
newTpRow["UserID"] = strLoginCode;
}
// newTpRow["Name"] = txt_Name.Text;
newTpRow["MasterID"] = m_App.User.Id;
newTpRow["StartDate"] = dateEditstart.Text;
newTpRow["EndDate"] = dateEditend.Text;
TempUsers.Rows.Add(newTpRow);
}
catch (Exception ex)
{
throw ex;
}
}
public UsersData loadNonManagers()
{
UsersData ds = new UsersData();
string query = "select *,ltrim(rtrim([name]))+' '+ltrim(rtrim([family]))as nameFamily from users where usertype =1";
dp.select(query, ds, UsersData.users_TABLE);
//dp.loadToDataSet(UsersData.users_TABLE, ds);
fillRadif(ds);
return(ds);
}
/// <summary>
/// Delete user
/// </summary>
/// <param name="id">user's id</param>
/// <returns>ok</returns>
public async Task DeleteUser(int id)
{
UsersData existed = UsersData.FirstOrDefault(x => x.Id == id);
if (existed != null)
{
existed.IsDeleted = true;
await SaveChangesAsync();
}
}
public ActionResult <UsersData> GetById(long id)
{
UsersData item = _context.Items.Find(id);
if (item == null)
{
return(NotFound());
}
return(item);
}
public ActionResult DeleteConfirmed(int id)
{
var assigned = (from v in db.ValveSection where v.BuilderID == id || v.QCID == id || v.EngineerID == id
select new { found = v.ValveSectionID }).ToList();
if (assigned.Count != 0)
{
ModelState.AddModelError("", "User is assigned to a Valve Section and cannot be deleted.");
UsersData userdata = new UsersData();
var user = (from u in db.Users
where u.UserID == id
select new { userdata = u }).First();
if (user == null)
{
return(HttpNotFound());
}
userdata.UserData = user.userdata;
userdata.UserTypesCheckBoxes = new List <CheckBoxes>();
var GCmodel = db.GroupClassifications.ToList();
foreach (var item in GCmodel)
{
var userstypes = (from u in db.UsersTypes
where u.UserID == id && u.GroupClassificationID == item.GroupClassificationID
select new { usertype = u });
userdata.UserTypesCheckBoxes.Add(new CheckBoxes
{
Text = item.GroupClassificationItem,
Value = Convert.ToInt32(item.GroupClassificationID),
Selected = (userstypes.Count() == 0 ? false : true)
});
}
return(View(userdata));
}
else
{
User user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
var deleteUsersTypes =
from u in db.UsersTypes
where u.UserID == id
select u;
foreach (var item in deleteUsersTypes)
{
db.UsersTypes.Remove(item);
}
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
private void BindRepeater()
{
try
{
UsersData udata = new UsersData();
DataSet ds = udata.getUsersData("select * from users");
rpUsers.DataSource = ds;
rpUsers.DataBind();
}
catch (Exception ex) { }
}
private void BindRepeater()
{
try
{
UsersData udata = new UsersData();
DataSet ds = udata.getUsersData("select users.id,users.name,users.mobile,users.courses,users.email,fee.user_id,fee.payment,fee.remain_payment from users join fee on users.id=fee.user_id ");
RpViewUsers.DataSource = ds;
RpViewUsers.DataBind();
}
catch (Exception ex) { }
}
public int Delete(UsersData UsersData)
{
DbParameter[] Parameters = CreateAddParameters(UsersData);
ExecuteNonQuery(CommandType.StoredProcedure, "UsersDelete", Parameters);
//ExecuteCommand("UsersDelete", Parameters);
return(UsersData.ID);
//List<DbParameter> Parameters = new List<DbParameter>();
//Parameters.Add(CreateParameter("@ID", UsersData.ID));
//this.ExecuteNonQuery(CommandType.StoredProcedure, "UsersDelete", Parameters.ToArray());
}
public JsonResult AddUser(UserRegisterValidation user)
{
if (ModelState.IsValid)
{
using (UsersData db = new UsersData())
{
return(Json(db.Register(user)));
}
}
return(Json(false));
}
public void Start()
{
if (SaverScript.LoadUser() != null)
{
UsersData data = SaverScript.LoadUser();
userField.text = data.user;
passwordField.text = data.pass;
StartCoroutine(LoginEnum());
}
}
public async Task <ActionResult <UsersData> > PostUsersData(UsersDataPost usersDataPost)
{
var newUsersData = new UsersData {
Address = usersDataPost.Address, FullName = usersDataPost.FullName, Phone = usersDataPost.Phone, AdditionalPhone = usersDataPost.AdditionalPhone, HandlingReason = usersDataPost.HandlingReason, Coment = usersDataPost.Coment, SelectedTariffs = usersDataPost.SelectedTariffs
};
_context.UsersDatas.Add(newUsersData);
await _context.SaveChangesAsync();
return(Ok());
}
public static void SaveUser(string user, string pass)
{
BinaryFormatter formatter = new BinaryFormatter();
string path = Application.persistentDataPath.ToString() + "/users.bin";
FileStream stream = new FileStream(path, FileMode.Create);
UsersData data = new UsersData(user, pass);
formatter.Serialize(stream, data);
stream.Close();
}
public ActionResult Remove(UsersData userModel)
{
string Username = userModel.Username;
using (portaldatabaseEntities db = new portaldatabaseEntities())
{
//sql query to delete user from db
db.Database.ExecuteSqlCommand("Delete from dbo.Accounts where Username = '******'");
return(RedirectToAction("Index", "Users_Management"));
}
}
// GET: Purchase
public ActionResult MyPurchase(string sessionId)
{
User user = UsersData.GetUserBySessionId("abc123");
if (user == null)
{
RedirectToAction("Login", "LoginUser");
}
ViewData["purchasedList"] = PurchaseData.GetPurchasedList(user.UserName);
ViewData["sessionId"] = sessionId;
return(View());
}
public ActionResult Get(RegisterUsers user)
{
try
{
if (ModelState.IsValid)
{
Random r = new Random();
int salt = r.Next(0, 100);
int res = salt / 2;
string cryptedPassword = user.Password + res.ToString();
user.CryptedPassword = cryptedPassword;
user.PasswordSalt = salt.ToString();
var newUser = new Users
{
Name = user.Name,
Email = user.Email,
Surname = user.Surname,
CryptedPassword = user.CryptedPassword,
PasswordSalt = salt.ToString(),
Mobile = user.Mobile
};
int?result = crud.AddUser(newUser);
if (result != null)
{
FormsAuthentication.SetAuthCookie(newUser.Email, false);
var createduser = crud.GetInfo(result, null);
UsersData usersData = new UsersData()
{
Surname = createduser.Surname,
Name = createduser.Name,
Email = createduser.Email,
Mobile = createduser.Mobile,
UserId = createduser.UserId
};
return(View("Get", usersData));
}
else
{
ViewBag.Message = "Пользователь уже существует";
return(View("Registration"));
}
}
else
{
return(View("Registration"));
}
}
catch (Exception ex)
{
logger.Info("Error to save user - ", ex.Message);
return(null);
}
}
private List <AspNetUser> GenerateUserData(List <AspNetUser> userData = null)
{
if (userData != null)
{
return(userData);
}
var personUserData = UsersData.GenerateData(5, PERSONUSERID);
var groupUserData = UsersData.GenerateData(1, GROUPUSERID, "Group");
return(personUserData.Concat(groupUserData).ToList());
}
public override async Task DoAsync()
{
await LogInfo("Loading user data from the following Rocket sources:" +
"\n" + "* Permissions");
RocketPermissions rocketPermissions = await LoadRocketPermissionsAsync();
if (rocketPermissions == null)
{
await LogInfo("Could not load Rocket permissions");
return;
}
UsersData openMod = new UsersData {
Users = new List <UserData>()
};
await LogInfo("Preparing user data");
foreach (RocketPermissionsGroup group in rocketPermissions.Groups)
{
foreach (string user in group.Members)
{
//TODO: Check what user id actually is
if (openMod.Users.All(u => u.Id != user))
{
openMod.Users.Add(new UserData()
{
Roles = new HashSet <string>()
{
group.Id
},
Type = "player",
Data = new Dictionary <string, object>(),
FirstSeen = DateTime.Now,
LastSeen = DateTime.Today,
Id = user,
LastDisplayName = user,
Permissions = new HashSet <string>()
});
}
else if (openMod.Users.Any(u => u.Id == user))
{
openMod.Users.FirstOrDefault(u => u.Id == user)?.Roles.Add(group.Id);
}
}
}
await LogInfo("Saving user data");
await SaveAsync(openMod);
}
public override bool IsValid(object value)
{
string username = (string)value;
if (value != null)
{
using (UsersData db = new UsersData())
{
return(!db.Contains(username));
}
}
return(false);
}
public ActionResult Register(UserRegisterValidation user, string returnUrl)
{
if (ModelState.IsValid)
{
using (UsersData db = new UsersData())
{
db.Register(user);
return(RedirectToAction("Login"));
}
}
return(View(user));
}
public override BasicData GetFromReader(DbDataReader reader)
{
UsersData UsersData = new UsersData();
UsersData.ID = this.ReadInt32(reader, "Users_ID");
UsersData.Users_Code = this.ReadString(reader, "Users_Code");
UsersData.Users_ArabicName = this.ReadString(reader, "Users_ArabicName");
UsersData.Users_EnglishName = this.ReadString(reader, "Users_EnglishName");
UsersData.Users_Password = this.ReadString(reader, "Users_Password");
return(UsersData);
}
public IHttpActionResult GetUsers()
{
try
{
UsersData usersData = new UsersData();
var users = usersData.GetUsers();
return(Ok(users));
}
catch (Exception ex)
{
return(BadRequest("Could not fetch Users"));
}
}
/// <summary>
/// Loads all users and presents them to the UsersList
/// </summary>
public void RefreshUsers()
{
UsersList_users.Items.Clear();
DeleteUser_Users.Enabled = false;
UsersData users = SaveLoad.users;
foreach (UserData u in users.usersData)
{
string[] row = new string[] { u.Sign, u.EmployeeNumber.ToString(), u.FirstName, u.LastName, u.Domain };
UsersList_users.Items.Add(new ListViewItem(row));
}
}
public IHttpActionResult GetSelectedUser(int iUSERID)
{
try
{
UsersData usersData = new UsersData();
var users = usersData.GetSeletedUser(iUSERID);
return(Ok(users));
}
catch (Exception ex)
{
return(BadRequest("Could not fetch roles"));
}
}
public IActionResult Delete(long id)
{
UsersData data = _context.Items.Find(id);
if (data == null)
{
return(NotFound());
}
_context.Items.Remove(data);
_context.SaveChanges();
return(NoContent());
}
/// <summary>
/// Searches the users data and returns a user's inventory for a specified AppId.
/// </summary>
/// <param name="users"></param>
/// <param name="userId"></param>
/// <param name="appid"></param>
/// <returns></returns>
/// <exception cref="KeyNotFoundException"></exception>
public static Inventory GetUserInventoryForApp(UsersData users, string userId, string appid)
{
if (!users.Users.ContainsKey(userId))
{
throw new KeyNotFoundException("Cannot find user with the specified SteamId64.");
}
if (!users.Users[userId].Inventory.ContainsKey(appid))
{
throw new KeyNotFoundException("Cannot find an inventory for the specified AppId");
}
return(users.Users[userId].Inventory[appid]);
}
public JsonResult UpdateUser(UserUpdateValidation user, string id, byte permission)
{
if (ModelState.IsValid)
{
using (UsersData db = new UsersData())
{
User updatedUser = user;
updatedUser.permission = permission;
bool update = db.Update(_user => _user.id == id, updatedUser);
return(Json(update));
}
}
return(Json(false));
}
public User ReadUserById(int userId)
{
UsersData data = new UsersData(CurrentDataContext);
User user = data.ReadUserById(userId);
if (user != null)
{
return(user.StripSecurity());
}
else
{
return(user);
}
}
public static void InserIntoUsers(BillsPaymentSystemContext context)
{
var users = new UsersData().GetUsers();
for (int i = 0; i < users.Length; i++)
{
if (StartUp.IsValid(users[i]) == true)
{
context.Add(users[i]);
}
}
context.SaveChanges();
}
public ActionResult Get(int?userid)
{
Users targetUser = crud.GetInfo(userid, null);
UsersData usersData = new UsersData()
{
UserId = targetUser.UserId,
Email = targetUser.Email,
Mobile = targetUser.Mobile,
Name = targetUser.Name,
Surname = targetUser.Surname
};
return(View("Get", usersData));
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string check = checkData();
if (check != null)
{
MessageBox.Show(check);
return;
}
if (dataGridView1.RowCount <= 0)
{
dataMode = NEW_MODE;
}
UsersBS isb = new UsersBS();
UsersData inData = new UsersData();
DataRow dr = inData.Tables[UsersData.users_TABLE].NewRow();
dr[UsersData.name_FIELD] = txtName.Text;
dr[UsersData.family_FIELD] = txtFamily.Text;
dr[UsersData.userName_FIELD] = txtUserName.Text;
dr[UsersData.password_FIELD] = txtPassword.Text;
dr[UsersData.userType_FIELD] = cmbUserType.SelectedIndex;
if (!dataMode.Equals(NEW_MODE))
{
dr[UsersData.id_FIELD] = _gridTools.getCurrentRowValue(UsersData.id_FIELD);
}
object id = _gridTools.getCurrentRowValue(UsersData.id_FIELD);
inData.Tables[UsersData.users_TABLE].Rows.Add(dr);
int count;
if (dataMode.Equals(NEW_MODE))
{
count = isb.add(inData);
}
else if (dataMode.Equals(EDIT_MODE))
{
count = isb.update(inData);
}
dataMode = EDIT_MODE;
btnRefresh_Click(null, null);
fillGrid();
}
public void LoadGameLocal()
{
userHighScoresData = new UsersData[maxUserNum];
int[] scores = new int[maxUserNum];
for(int i = 0; i < maxUserNum; i++)
{
UsersData user = new UsersData();
user.LoadLocal(i);
userHighScoresData[i] = user;
scores[i] = userHighScoresData[i].GetScore();
}
minScore = Mathf.Min(scores);
}
public void SaveGame(int score)
{
LoadGameLocal();
ArrayList newData;
if (score >= minScore)
{
newData = new ArrayList(userHighScoresData);
//추가할 new UsersData
UsersData obj_user = new UsersData();
obj_user.Init(UsersData.DEFAULT_NAME, score);
// Add to newData Array List
newData.Add(obj_user);
// Sort Users By Scores
newData.Sort(new ScoreComparer());
// UserScoresData = newData 형식에 맞게
userHighScoresData = newData.ToArray(typeof(UsersData)) as UsersData[];
}
for(int i = 0; i < maxUserNum; i++) // PlayerPrefs 값들이 계속 바뀌는 거.
{
if(userHighScoresData[i].GetScore() >= 0) userHighScoresData[i].SaveLocal(i);
}
}
