public List <mUser> GetAllUser()
{
try
{
List <mUser> t_users = new List <mUser>();
SqlCommand comm = command;
conn.Open();
comm.CommandText = "SELECT * FROM " + TABLE_NAME;
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
mUser m = new mUser();
m.Id = int.Parse(reader["id"].ToString());
m.Ad = reader["ad"].ToString();
m.Kad = reader["kad"].ToString();
m.Eposta = reader["eposta"].ToString();
m.Sifre = reader["sifre"].ToString();
m.Yetki = int.Parse(reader["yetki"].ToString());
t_users.Add(m);
}
reader.Close();
return(t_users);
}
catch (Exception e)
{
global::System.Windows.Forms.MessageBox.Show("GetAllHata @::=>> ", e.Message);
}
finally
{
conn.Close();
}
return(null);
}
public ActionResult DoAddUser(mUser objUser, int groupID)
{
try
{
var db = DB.Entities;
var user = db.mUser.FirstOrDefault(m => m.ID == objUser.ID);
var group = db.mGroup.First(m => m.ID == groupID);
user.mGroup.Add(group);
db.SaveChanges();
return(RedirectToAction("UsersInGroup", new { id = groupID }));
}
catch (Exception ex)
{
#region SELECT OPTION
string dataUserName = "******";
foreach (var item in NationalIT.DB.Entities.mUser)
{
dataUserName += string.Format("<option value='{0}'>{1} ({2})</option>", item.ID, item.Name, item.UserName);
}
ViewBag.dataUserName = dataUserName;
#endregion
ModelState.AddModelError("", "Can not add this user to group.");
return(View("AddUser", objUser));
}
}
public List <mUser> SearchUser()
{
try
{
List <mUser> t_users = new List <mUser>();
SqlCommand comm = command;
conn.Open();
comm.CommandText = "select * from table_üye " +
"WHERE ad like '%" + user.Ad + "%' or kad like '%" + user.Kad + "%'" +
" order by ad ,kad";
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
mUser m = new mUser();
m.Id = int.Parse(reader["id"].ToString());
m.Ad = reader["ad"].ToString();
m.Kad = reader["kad"].ToString();
m.Eposta = reader["eposta"].ToString();
m.Sifre = reader["sifre"].ToString();
m.Yetki = int.Parse(reader["yetki"].ToString());
t_users.Add(m);
}
reader.Close();
return(t_users);
}
catch (Exception e)
{
global::System.Windows.Forms.MessageBox.Show("SearchUser @::=>> ", e.Source);
}
finally
{
conn.Close();
} return(null);
}
public ActionResult Create(mUser User)
{
if (HttpContext.Session["AID"] == null)
{
return(RedirectToAction("AdminLogin", "Portal", null));
}
try
{
using (Models.MerchantService db = new Models.MerchantService())
{
t_Users user = new t_Users();
user.StaffID = User.StaffID;
user.UserID = User.UserID;
user.Passwd = mUser.EncryptPassword(User.Passwd);
user.UserLevel = User.UserLevel;
user.AdminLogin = User.AdminLogin;
db.t_Users.Add(user);
db.SaveChanges();
TempData["StatusMessage"] = "Success";
TempData.Keep();
}
}
catch (Exception ex)
{
TempData["StatusMessage"] = ex.Message;
TempData.Keep();
}
return(View("Create"));
}
public bool InsertDataBoolean(mUser data)
{
try
{
GVNMESEntities dObjContext = new GVNMESEntities();
//cara 1
dObjContext.mUsers.Add(data);
dObjContext.SaveChanges();
//cara 2
mUser dtToInsert = new mUser();
dtToInsert.txtUsername = data.txtUsername;
dtToInsert.txtPassword = data.txtPassword;
dtToInsert.txtFullname = "";
dObjContext.mUsers.Add(dtToInsert);
dObjContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult UseUpdate(int seatId, string defineJson, string cache, string userstore)
{
UserIdentity user = (UserIdentity)ViewBag.UserModel;
mSeat seat = seat_get.SeatGet(seatId);
try {
if (seat.EditUserId != 0 && int.Parse(user.Id) != seat.EditUserId)
{
throw new ConcurrentException();
}
mSeat upseat = new mSeat {
Id = seatId,
DefineJson = defineJson,
Cache = cache
};
seat_sub.SeatUpdateByuser(upseat, int.Parse(user.Id));
mUser upuser = new mUser {
Id = int.Parse(user.Id),
StoreData = userstore
};
user_sub.UserUpdate(upuser);
} catch (Exception ex) {
return(Json(new { result = false, msg = ex.Message }));
}
return(Json(new { result = true }));
}
private void login_btn_login_Click(object sender, EventArgs e)
{
//SupplierSystemModel m = new SupplierSystemModel();
//SupplierSystemModel m2 = new SupplierSystemModel();
//List<SupplierSystemModel> listm = new List<SupplierSystemModel>();
//m.id = 1;
//m.name = "T";
//m.startdate = DateTime.Now;
//m.enddate = DateTime.Now;
//m.piece = 500;
//m.properties = "tttttttt 555555555";
//m.personid = 2;
//m.suppid = 1;
//m.isinvoice = true;
//m.agncyprice = 9999;
//m.price = 9999;
//m.logid = 1;
//listm = m.searchSupplierSystem();
//m2 = m.getSupplierSystem();
mUser loginedUser = new mUser();
loginedUser.Kad = login_txtbx_kad.Text;
loginedUser.Sifre = login_txtbx_sif.Text;
UserController control = new UserController(new UserView(this), loginedUser);
control.checkLogin();
}
public ActionResult LogOn(LogOnModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
mUser user = user_get.Login(model.UserName, model.Password);
if (user == null)
{
ModelState.AddModelError("", "提供的用户名或密码不正确。");
return(View(model));
}
var roles = user_get.RoleGetByuser(user.Id);
var auths = user_get.AuthGetByuser(user.Id);
authentication.SetAuthCookie(this.HttpContext, AuthenticationTicketBuilder.CreateTicket(user, roles, auths));
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1)
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Use", "Seat"));
}
}
public ActionResult Reset(string uid)
{
if (HttpContext.Session["AID"] == null)
{
return(RedirectToAction("AdminLogin", "Portal", null));
}
mUser User = new mUser();
try
{
using (Models.MerchantService db = new Models.MerchantService())
{
t_Users u = new t_Users();
u = db.t_Users.Where(x => x.UserID == uid).SingleOrDefault();
User.UserID = u.UserID;
//User.Passwd = u.Passwd;
}
}
catch (Exception ex)
{
TempData["StatusMessage"] = ex.Message;
TempData.Keep();
}
return(View(User));
}
public ActionResult Edit(mUser user)
{
if (HttpContext.Session["AID"] == null)
{
return(RedirectToAction("AdminLogin", "Portal", null));
}
try
{
using (SqlConnection consql = new SqlConnection(ConfigurationManager.ConnectionStrings["MerchantServiceDB"].ConnectionString))
{
consql.Open();
SqlCommand cmd = new SqlCommand("sp_u_update_user_right", consql);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@AdminLogin", user.AdminLogin);
cmd.Parameters.AddWithValue("@EnabledUser", user.UserLevel);
cmd.ExecuteNonQuery();
TempData["StatusMessage"] = "Success";
TempData.Keep();
}
}
catch (Exception ex)
{
TempData["StatusMessage"] = ex.Message;
TempData.Keep();
}
return(View());
}
public JsonResult GetUserJurisdiction(int roleId)
{
ResultBase result = new ResultBase();
mUser user = (mUser)Session["LoginUser"];
if (user != null)
{
if (user.UserRoleId == roleId)
{
result.Result = ResultCode.Ok;
}
else
{
result.Result = ResultCode.ClientError;
result.Msg = "对不起，您没有此模块权限!";
}
}
else
{
result.Result = ResultCode.ServerError;
result.Msg = "请您重新登录，您已经掉线!";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static mUser LoginUserInfo(string username, string password, int roleId)
{
mUser model = new mUser();
string sql = @"select UserId,UserName,UserRoleId,ur.RoleName,UserDepartId,
Passwrod,CreateDate,d.DepartName from m_User u
left join m_UserRole ur on u.UserRoleId=ur.Id
left join m_Depart d on u.UserDepartId=d.Id
where UserName=@userName and Passwrod=@passwrod";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@userName", username),
new SqlParameter("@passwrod", password)
};
SqlDataReader reade = SQLHelper.GetReader(sql, paras);
if (reade.Read())
{
model.UserId = Tool.ToInt(reade["UserId"].ToString());
model.UserName = reade["UserName"].ToString();
model.UserRoleId = Tool.ToInt(reade["UserRoleId"].ToString());
model.UserRoleName = reade["RoleName"].ToString();
model.UserDepartId = Tool.ToInt(reade["UserRoleId"].ToString());
model.UserDepartName = reade["DepartName"].ToString();
model.PassWord = reade["Passwrod"].ToString();
}
return(model);
}
private void pbxLogin_Click(object sender, EventArgs e)
{
//登陆
if (!IsNullJudge())
{
return;
}
string userName = wtbUsername.Text.Trim();
string userPass = Tool.MD5(wtbPassword.Text.Trim());
int roleId = 1;
SetMessageShow(true);
mUser umodel = ilogin.LoginUserInfo(userName, userPass, 1);
if (umodel.PassWord == userPass && umodel.UserName == userName)
{
if (umodel.UserRoleId == roleId)
{
UserInfo.RoleId = umodel.UserRoleId;
FrmMain frmmain = new FrmMain(umodel.UserName);
frmmain.Show();
Hide();
}
else
{
lblMessage.Text = "此账号没有权限登录审批版本";
}
}
else
{
lblMessage.Text = "用户名或者密码错误!";
}
}
public ActionResult LoginToAdmin(mUser user)
{
try
{
mUser muser = new mUser();
muser.UserID = user.UserID;
muser.Passwd = user.Passwd;
bool is_success = muser.AdminUserLogin();
if (is_success)
{
HttpContext.Session["AID"] = user.UserID;
HttpContext.Session["UID"] = user.UserID;
//Session["UID"] = user.UserID;
return(RedirectToAction("AdminDashboard"));
}
else
{
TempData["Message"] = "Invalid Login";
TempData.Keep();
return(RedirectToAction("AdminLogin"));
}
}
catch (Exception ex)
{
TempData["Message"] = ex.Message;
TempData.Keep();
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> RegistAsync([FromBody] LoginModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (string.IsNullOrWhiteSpace(model.PWD) || string.IsNullOrWhiteSpace(model.PhoneNumber))
{
return(BadRequest());
}
IQueryable <mUser> query = _context.sUser.Where(x => x.PhoneNumber == model.PhoneNumber).Take(1);
if (query.Count() > 0)
{
return(BadRequest());
}
var user = new mUser()
{
Password = model.PWD,
PhoneNumber = model.PhoneNumber
};
_context.sUser.Attach(user);
await _context.SaveChangesAsync();
return(Ok(new { Jwt = LocalJwt.Regist(_connectionMultiplexer.GetDatabase(), user.ID.ToString(), _configuration["jwt:Issuer"], int.Parse(_configuration["jwt:Overtime"])) }));
}
public ActionResult UpdateMerchantInfo(string id)
{
if (HttpContext.Session["UID"] == null)
{
return(RedirectToAction("Index", "Portal", null));
}
mUser u = new mUser();
if (!u.check_user_right(Session["UID"].ToString(), 1))
{
return(RedirectToAction("Denied", "Portal", null));
}
if (id == null)
{
return(new HttpStatusCodeResult(statusCode: 400));
}
//Business Category for dropdown
List <t_BusinessCategory> category_list = new List <t_BusinessCategory>();
using (Models.MerchantService db = new Models.MerchantService())
{
category_list = db.t_BusinessCategory.ToList();
}
ViewBag.Category = category_list;
//Get Merchant Info
mMerchant merchantinfo = new mMerchant();
try
{
using (Models.MerchantService db = new Models.MerchantService())
{
t_Merchant_Info merch_info = db.t_Merchant_Info.Where(x => x.MPU_Merchant_ID == id).FirstOrDefault();
merchantinfo.MPU_Merchant_ID = merch_info.MPU_Merchant_ID;
merchantinfo.Merchant_Name = merch_info.Merchant_Name;
merchantinfo.Merchant_Address = merch_info.Merchant_Address;
merchantinfo.Merchant_Email = merch_info.Merchant_Email;
merchantinfo.Merchant_Phone = merch_info.Merchant_Phone;
merchantinfo.OMPURate = merch_info.OMPURate;
merchantinfo.OJCBRate = merch_info.OJCBRate;
merchantinfo.OUPIRate = merch_info.OUPIRate;
merchantinfo.MPURate = merch_info.MPURate;
merchantinfo.JCBRate = merch_info.JCBRate;
merchantinfo.UPIRate = merch_info.UPIRate;
merchantinfo.Settlement_Acc = merch_info.Settlement_Acc;
merchantinfo.SettAccountName = merch_info.SettAccountName;
merchantinfo.BusinessCategoryID = merch_info.BusinessCategoryID;
}
return(View(merchantinfo));
}
catch (Exception ex)
{
TempData["Message"] = ex.Message;
TempData.Keep();
return(View());
}
}
public ActionResult EditUser(mUser user)
{
try
{
mUser users = new mUser();
users = (from u in db.mUsers.ToList()
where u.UserID == user.UserID
select u).FirstOrDefault();
users.FirstName = user.FirstName;
users.MiddleName = user.MiddleName;
users.LastName = user.LastName;
users.Approved = user.Approved;
users.Locked = user.Locked;
users.SuperUser = user.SuperUser;
users.Reversal = user.Reversal;
users.IsManager = user.IsManager;
user.Update_User = "******";
user.Update_Date = DateTime.Now;
db.Entry(users).State = EntityState.Modified;
db.SaveChanges();
}
catch (Exception err) { }
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult NewOrEdit(mUser model)
{
try
{
var db = DB.Entities;
if (model.ID == 0)
{
// Add new
var aspNewUserID = new UserDAL().CreateAspnetUser(model.UserName, "1");
model.AspnetUserID = aspNewUserID;
db.mUser.AddObject(model);
}
else
{
// Edit
db.AttachTo("mUser", model);
db.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
/// <summary>
/// 根据角色获取用户信息
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public static List <mUser> GetUserList(int roleId)
{
List <mUser> userList = new List <mUser>();
string sql = "select * from m_User where UserRoleId=@roleId";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@roleId", roleId),
};
mUser user = null;
using (SqlDataReader reader = SQLHelper.GetReader(sql, paras))
{
while (reader.Read())
{
user = new mUser();
user.UserId = Convert.ToInt32(reader["UserId"]);
user.UserName = reader["UserName"].ToString();
userList.Add(user);
}
}
return(userList);
}
public mUser checkAccount(string username, string password)
{
mUser user = new mUser();
user = (from c in db.mUsers where c.UserID == username && c.Password == password select c).FirstOrDefault();
return(user);
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new mUser {
UserName = model.UserName, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult CreateJavascript(mUser data)
{
clsMUserBussLogic logic = new clsMUserBussLogic();
data = logic.InsertData(data);
return(Json(data, string.Empty, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateUser(mUser user)
{
user.LastDateLoggedIn = DateTime.Now;
user.Customer_Flag = true;
user.Is_Deleted = false;
user.Create_Date = DateTime.Now;
user.Create_User = user.UserID;
user.Update_Date = DateTime.Now;
user.Update_User = user.UserID;
user.Password = EncodePasswordMd5(user.Password);
mSite checker = (from c in db.mSites
where c.SiteName == user.UserID && c.Is_Deleted == false
select c).FirstOrDefault();
if (checker == null)
{
try
{
db.mUsers.Add(user);
db.SaveChanges();
}
catch (Exception err) { }
}
else
{
return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
public mUser InsertData(mUser data)
{
data.dtCreated = DateTime.Now.AddDays(1);
data.dtUpdated = DateTime.Now;
GVNMESEntities dObjContext = new GVNMESEntities();
//cara 1
dObjContext.mUsers.Add(data);
dObjContext.SaveChanges();
//cara 2
mUser dtToInsert = new mUser();
dtToInsert.txtUsername = data.txtUsername;
dtToInsert.txtPassword = data.txtPassword;
dtToInsert.txtFullname = "";
dtToInsert.dtCreated = DateTime.Now;
dtToInsert.dtUpdated = DateTime.Now;
dObjContext.mUsers.Add(dtToInsert);
dObjContext.SaveChanges();
return(dtToInsert);
}
private void admn_datagrd_CellClick(object sender, DataGridViewCellEventArgs e)
{
mUser ccu = new mUser();
if (e.ColumnIndex > -1 && e.RowIndex > -1 && e.RowIndex < admn_datagrd.RowCount - 1)
{
lblSetVisible(true);
ccu.Id = int.Parse(admn_datagrd.Rows[e.RowIndex].Cells[0].Value.ToString());
ccu.Ad = admn_datagrd.Rows[e.RowIndex].Cells[1].Value.ToString();
ccu.Kad = admn_datagrd.Rows[e.RowIndex].Cells[2].Value.ToString();
ccu.Sifre = admn_datagrd.Rows[e.RowIndex].Cells[3].Value.ToString();
ccu.Eposta = admn_datagrd.Rows[e.RowIndex].Cells[4].Value.ToString();
ccu.Yetki = (int)admn_datagrd.Rows[e.RowIndex].Cells[5].Value;
UserController controller = new UserController(new UserView(this), ccu);
controller.setCellClicked();
List <string> tags = new List <string>();
tags.Add("ad");
tags.Add("kad");
tags.Add("eposta");
tags.Add("yetki");
controller.setLabelText(tags);
admn_btn_günc.Visible = true;
admn_btn_sil.Visible = true;
}
else
{
lblSetVisible(false);
}
}
public Inspectionitem(mUser user)
{
currentuser = user;
InitializeComponent();
loadStages();
newInspection.IsChecked = true;
GetUnfinishedLots();
namecurrentuser.Content = user.FirstName + " " + user.LastName;
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="Info"></param>
public void UserUpdate(mUser Info)
{
SqlParameter[] par = new SqlParameter[] {
new SqlParameter("@Id", Info.Id),
new SqlParameter("@GroupId", Info.GroupId),
new SqlParameter("@UserPwd", Info.UserPwd)
};
SQLHelper.ExecuteNonQuery("UserEdit", par);
}
public ActionResult Index(int id)
{
mUser user = user_get.UserGet(id);
UserModel usermod = new UserModel {
Name = user.Name
};
return(View(usermod));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="Info"></param>
public int UserInsert(mUser Info)
{
SqlParameter[] par = new SqlParameter[] {
new SqlParameter("@GroupId", Info.GroupId),
new SqlParameter("@UserName", Info.UserName),
new SqlParameter("@UserPwd", Info.UserPwd)
};
return(StringDeal.ToInt(SQLHelper.ExecuteScalar("UserInsert", par)));
}
/// <summary>
/// DATABASE ARA
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void admn_k_txt_ara_TextChanged(object sender, EventArgs e)
{
mUser user = new mUser();
user.Ad = admn_k_txt_ara.Text;
user.Kad = admn_k_txt_ara.Text;
UserController controller = new UserController(new UserView(this), user);
controller.searchUser();
}
