public static string GetUserName(Guid UserID)
{
NSIADataContext dc = new NSIADataContext();
USERINFO employee = (from a in dc.USERINFOs where a.usernameid.Value.Equals(UserID) select a).SingleOrDefault();
return(employee.NAMELOCAL);
}
public bool UpdateUSERINFO(USERINFO uSERINFO)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateUSERINFO", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@USERINFOID", SqlDbType.Int).Value = uSERINFO.USERINFOID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = uSERINFO.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = uSERINFO.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = uSERINFO.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = uSERINFO.ModifyBy;
cmd.Parameters.Add("@Type", SqlDbType.NVarChar).Value = uSERINFO.Type;
cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = uSERINFO.UserName;
cmd.Parameters.Add("@Agent_LocationID", SqlDbType.Int).Value = uSERINFO.Agent_LocationID;
cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = uSERINFO.FirstName;
cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = uSERINFO.LastName;
cmd.Parameters.Add("@MiddleName", SqlDbType.NVarChar).Value = uSERINFO.MiddleName;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = uSERINFO.Address;
cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = uSERINFO.City;
cmd.Parameters.Add("@State", SqlDbType.NVarChar).Value = uSERINFO.State;
cmd.Parameters.Add("@Country", SqlDbType.NVarChar).Value = uSERINFO.Country;
cmd.Parameters.Add("@PostalCode", SqlDbType.NVarChar).Value = uSERINFO.PostalCode;
cmd.Parameters.Add("@ExpDate", SqlDbType.DateTime).Value = uSERINFO.ExpDate;
cmd.Parameters.Add("@Status", SqlDbType.Int).Value = uSERINFO.Status;
cmd.Parameters.Add("@HomePhone", SqlDbType.NVarChar).Value = uSERINFO.HomePhone;
cmd.Parameters.Add("@WorkPhone", SqlDbType.NVarChar).Value = uSERINFO.WorkPhone;
cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = uSERINFO.Mobile;
cmd.Parameters.Add("@Comm", SqlDbType.NVarChar).Value = uSERINFO.Comm;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public EmpCheckDay(USERINFO emp, CHECKINOUT obj)
{
Emp = emp;
CheckDate = obj.CHECKTIME.Date;
RawChecks.Add(obj);
Checks = RawChecks;
}
public static USERINFO GetUserByID(Guid UserID)
{
NSIADataContext dc = new NSIADataContext();
USERINFO Result = (from x in dc.USERINFOs where x.usernameid == UserID select x).SingleOrDefault();
return(Result);
}
private void reLoadSession()
{
if (Session["userType"] == null || Session["aGENT"] != null || Session["lOCATION"] != null)
{
USERINFO userInfo = new USERINFO();
userInfo = USERINFOManager.GetUSERINFOByUserNameType("Agent", User.Identity.Name);//"Agent" is dami in database i have not use the
if (userInfo != null)
{
Session["userType"] = userInfo.Type.ToString();
Session["userInfoID"] = userInfo.USERINFOID.ToString();
Session["userName"] = userInfo.UserName.ToString();
//if (userInfo.Agent_LocationID.ToString() == ddlAgent.SelectedItem.Value.ToString())
if (userInfo.Type == "Agent")
{
Session["aGENT"] = AGENTManager.GetAGENTByID(userInfo.Agent_LocationID);
Session["role"] = "Agent";
}
else if (userInfo.Type == "Location")
{
Session["lOCATION"] = LOCATIONGROUPManager.GetLOCATIONGROUPByID(userInfo.Agent_LocationID);
Session["role"] = "Location";
}
}
}
}
public ActionResult Index(FormCollection post)
{
Session["USERID"] = string.Empty;
Session["LEVEL"] = string.Empty;
Session["AREAID"] = string.Empty;
USERINFO USER = new USERINFO()
{
ID = post["ACCOUNT"],
PASSWORD = post["PASSWORD"]
};
if (USER.ID != string.Empty && USER.PASSWORD != string.Empty)
{
string sql = $"select * from userinfo where ID='{USER.ID}' and PASSWORD='******' AND (STATUS=1 or STATUS is null)";
DataTable DT = CommonTools.GetDataTable(sql, connStr);
if (DT != null && DT.Rows.Count > 0)
{
Session["USERID"] = DT.Rows[0]["USERID"].ToString();
Session["LEVEL"] = DT.Rows[0]["LEVEL"].ToString();
Session["AREAID"] = DT.Rows[0]["AREAID"].ToString();
return(RedirectToAction("UserList", "Home", null));
}
else
{
TempData["message"] = "帳號或密碼錯誤!";
}
}
else
{
TempData["message"] = "請輸入帳號密碼!";
}
return(View());
}
public async Task <IHttpActionResult> PutUSERINFO(int id, USERINFO uSERINFO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != uSERINFO.ID)
{
return(BadRequest());
}
db.Entry(uSERINFO).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
//if (!USERINFOExists(id))
//{
// return NotFound();
//}
//else
//{
// throw;
//}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static USERINFO GetUSERINFOByUserNameType(string type, string userName)
{
USERINFO uSERINFO = new USERINFO();
SqlUSERINFOProvider sqlUSERINFOProvider = new SqlUSERINFOProvider();
uSERINFO = sqlUSERINFOProvider.GetUSERINFOByUserNameType(type, userName);
return(uSERINFO);
}
public static USERINFO GetUSERINFOByID(int id)
{
USERINFO uSERINFO = new USERINFO();
SqlUSERINFOProvider sqlUSERINFOProvider = new SqlUSERINFOProvider();
uSERINFO = sqlUSERINFOProvider.GetUSERINFOByID(id);
return(uSERINFO);
}
public void CreateUserInfo(string idUser, string name, string firstname, string street, string zipcode, string city, string phone)
{
USERINFO info = new USERINFO {
userId = idUser, nameUser = name, firstname = firstname, street = street, zipCode = zipcode, city = city, phone = phone, creationDate = DateTime.Now
};
db.USERINFOs.Add(info);
db.SaveChanges();
}
/// <summary>
/// 根据用户名 密码进行登录
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public ActionResult Logins(string userID)
{
USERINFO_BN user = new USERINFO_BN();
USERINFO dtuser = (USERINFO)user.GetModel(userID);
Session["userInfo"] = dtuser;
return(RedirectToAction("Index"));
}
public ActionResult AddUserInfo(USERINFO userInfo)
{
userInfo.ID = userInfo.ID;
userInfo.DELFLAG = 0;
userInfo.MODIFIEDON = DateTime.Now;
userInfo.SUBTIME = DateTime.Now;
UserInfoService.AddEntity(userInfo);
return(Content("ok"));
}
public USERINFO GetUserInfo(string CARDID)
{
USERINFO userinfo = new USERINFO
{
CARDID = CARDID,
USERNAME = "******",
ID = "",
BIRTHDAY = "",
GENDER = "",
ISSUEDDATE = "",
PHONE = "",
ECONTACT = "",
EPHONE = "",
AREAID = "",
LEVEL = "",
COL1 = "",
COL2 = "",
COL3 = "",
STATUS = "200",
MESSAGE = "Search Success"
};
try
{
MySqlConnection conn = new MySqlConnection(connStr);
MySqlCommand command = conn.CreateCommand();
conn.Open();
command.CommandText = "select * from cardlist C left join userinfo U on C.USERID=U.USERID WHERE CARDID='" + CARDID + "'";
DataTable DT = new DataTable();
MySqlDataAdapter MDA = new MySqlDataAdapter(command.CommandText, conn);
MDA.Fill(DT);
if (DT != null && DT.Rows.Count > 0 && DT.Rows[0]["USERID"].ToString() != "")
{
userinfo.USERNAME = DT.Rows[0]["USERNAME"].ToString();
userinfo.ID = DT.Rows[0]["ID"].ToString();
userinfo.BIRTHDAY = DT.Rows[0]["BIRTHDAY"].ToString();
userinfo.GENDER = DT.Rows[0]["GENDER"].ToString();
userinfo.ISSUEDDATE = DT.Rows[0]["ISSUEDDATE"].ToString();
userinfo.PHONE = DT.Rows[0]["PHONE"].ToString();
userinfo.ECONTACT = DT.Rows[0]["ECONTACT"].ToString();
userinfo.EPHONE = DT.Rows[0]["EPHONE"].ToString();
userinfo.AREAID = DT.Rows[0]["AREAID"].ToString();
userinfo.LEVEL = DT.Rows[0]["LEVEL"].ToString();
userinfo.COL1 = DT.Rows[0]["COL1"].ToString();
userinfo.COL2 = DT.Rows[0]["COL2"].ToString();
userinfo.COL3 = DT.Rows[0]["COL3"].ToString();
}
conn.Close();
}
catch (Exception EX)
{
userinfo.STATUS = "500";
userinfo.MESSAGE = EX.Message;
}
return(userinfo);
}
protected void OnAuthenticate(object sender, AuthenticateEventArgs e)
{
lblMessage.Text = "";
e.Authenticated = false;
Login masterLogin = (Login)masterview.FindControl("masterLogin");
string userName = masterLogin.UserName.ToString();
string password = masterLogin.Password.ToString();
//if (Membership.ValidateUser(userName, password) && (userName.Equals("admin")))
//{
// masterLogin.DestinationPageUrl = "Default.aspx";
// Session["role"] = "Admin";
// e.Authenticated = true;
//}
//else
//{
if (Membership.ValidateUser(userName, password))
{
USERINFO userInfo = new USERINFO();
userInfo = USERINFOManager.GetUSERINFOByUserNameType("Agent", userName);//"Agent" is dami in database i have not use the
if (userInfo != null)
{
Session["userType"] = userInfo.Type.ToString();
Session["userInfoID"] = userInfo.USERINFOID.ToString();
Session["userName"] = userInfo.UserName.ToString();
e.Authenticated = true;
//if (userInfo.Agent_LocationID.ToString() == ddlAgent.SelectedItem.Value.ToString())
if (userInfo.Type == "Agent")
{
Session["aGENT"] = AGENTManager.GetAGENTByID(userInfo.Agent_LocationID);
Session["role"] = "Agent";
}
else if (userInfo.Type == "Location")
{
Session["lOCATION"] = LOCATIONGROUPManager.GetLOCATIONGROUPByID(userInfo.Agent_LocationID);
Session["role"] = "Location";
}
//Response.Redirect("Default.aspx");
masterLogin.DestinationPageUrl = "~/Default.aspx";
}
else
{
lblMessage.Text = "Password incorrect!!!";
}
}
else
{
//Response.Redirect("~/Forgetpassword.aspx");
}
//}
}
public async Task <IHttpActionResult> GetUSERINFO(int id)
{
USERINFO userInfoObj = await db.USERINFOes.FindAsync(id);
if (userInfoObj == null)
{
return(NotFound());
}
return(Ok(userInfoObj));
}
public ActionResult EditUserInfo(USERINFO userInfo)
{
userInfo.MODIFIEDON = DateTime.Now;
if (UserInfoService.EditEntity(userInfo))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
private USERINFO GetUserByToken(string Token)
{
string[] arr = GetToKenInfo(Token);
USERINFO user = null;
if (arr != null)
{
string UserName = arr[0], Password = arr[1];
user = UserHelper.Login(UserName, Password);
}
return(user);
}
public async Task <IHttpActionResult> PostUSERINFO(USERINFO uSERINFO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.USERINFOes.Add(uSERINFO);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = uSERINFO.ID }, uSERINFO));
}
public ReturnResult Logins(USERINFO user)
{
ReturnResult result = new ReturnResult();
USERINFO_BN userBN = new USERINFO_BN();
DataTable dt = userBN.GetUserList(user);
if (dt.Rows.Count > 0)
{
result.success = true;
result.data = dt;
}
return(result);
}
public async Task <IHttpActionResult> DeleteUSERINFO(int id)
{
USERINFO uSERINFO = await db.USERINFOes.FindAsync(id);
if (uSERINFO == null)
{
return(NotFound());
}
db.USERINFOes.Remove(uSERINFO);
await db.SaveChangesAsync();
return(Ok(uSERINFO));
}
public Task <int> updateUserInfo([FromUri] string oldUserName, [FromBody] USERINFO value)
{
//var data = db.USERINFOes.Where(s => s.LOGIN.UID == value.LOGIN.UID).Select(s => s).FirstOrDefault();
var data = db.USERINFOes.Where(s => s.USER_NAME == oldUserName).Select(s => s).FirstOrDefault();
if (data != null)
{
data.USER_NAME = value.USER_NAME;
db.Entry(data).State = EntityState.Modified;
return(db.SaveChangesAsync());
}
return(Task.FromResult(0));
}
public string DelUser(string Token, string UserId)
{
USERINFO user = GetUserByToken(Token); // 登陆
if (null != user)
{
int count = UserHelper.DelUser(UserId);
if (count > 0)
{
return("{\"State\":\"Success\"}");
}
}
return("{\"State\":\"Fail\", \"Message\":\"无此用户\"}");
}
public static void Query(USERINFO updateCheckbox, string queryUpdateCheckbox, SettingsDbContent nameofDatabaseSettings, string machineName)
{
SqlConnection con = new SqlConnection(string.Format(GlobalConstants.ConnectionStringToAx, machineName, nameofDatabaseSettings.NameOfDatabase));
con.Open();
SqlCommand cmd = new SqlCommand(string.Format(queryUpdateCheckbox, nameofDatabaseSettings.NameOfDatabase, updateCheckbox.NAME));
cmd.Connection = con;
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
DataTable dbTable = new DataTable();
dataAdapter.Fill(dbTable);
}
public string LoginWithToken(string Token)
{
var jss = new System.Web.Script.Serialization.JavaScriptSerializer();
jss.MaxJsonLength = Int32.MaxValue;
USERINFO user = GetUserByToken(Token);
if (null != user)
{
return("{\"State\":\"Success\", \"User\":" + jss.Serialize(user) + "}");
}
return("{\"State\":\"Fail\"}");
}
public Frm_User_ViewModel(bool bCreateAccount)
{
userinfo = _Data.Inst.user;
BtnEvent = new Command(BtnClickEvnet);
ComboEvent = new Command(ComboChangedEvent);
if (bCreateAccount)
{
LoginGridVisibility = Visibility.Visible;
}
else
{
RegisterGridVisibility = Visibility.Visible;
BtnClickEvnet("btn_openregister");
}
}
public string ChangePwd(string Token, string Password)
{
USERINFO user = GetUserByToken(Token); // 登陆
user.PASSWORD = Utils.md5Unicodebase64(Password);
if (null != user)
{
int count = UserHelper.UpdateUser(user);
if (count > 0)
{
return("{\"State\":\"Success\"}");
}
}
return("{\"State\":\"Fail\", \"Message\":\"无此用户\"}");
}
void ActualizaSocios(int i)
{
using (Model1 bd = new Model1())
{
USERINFO user = new USERINFO();
user.Badgenumber = Convert.ToString(Dt.Rows[i]["pkMemberID"]);
user.Name = Convert.ToString(Dt.Rows[i]["tName"]);
user.lastname = Convert.ToString(Dt.Rows[i]["tLastname"]) + " " + Convert.ToString(Dt.Rows[i]["tLastname2"]);
// user.BIRTHDAY = Convert.ToDateTime(Dt.Rows[i]["dBirthdate"]);
user.email = Convert.ToString(Dt.Rows[i]["temail"]);
user.Gender = Convert.ToString(Dt.Rows[i]["tgender"]);
user.OPHONE = Convert.ToString(Dt.Rows[i]["tCellPhone"]);
// user.PHOTO = FuncNet.ImageTobyteArray(PicDetalle.Image);
user.DEFAULTDEPTID = 2;
user.ATT = 1;
user.INLATE = 1;
user.OUTEARLY = 1;
user.OVERTIME = 1;
user.SEP = 1;
user.HOLIDAY = 1;
user.privilege = 0;
user.AutoSchPlan = 1;
user.MinAutoSchInterval = 24;
user.RegisterOT = 1;
user.status = 0;
bd.USERINFO.Add(user);
bd.SaveChanges();
var Resultado = (from dd in bd.Zk_Correlativos
select dd).First();
int vCodId = Convert.ToInt32(Resultado.codId);
Resultado.codId += 1;
Resultado.Codigo += 1;
bd.SaveChanges();
acc_levelset_emp level = new acc_levelset_emp();
level.employee_id = vCodId;
level.acclevelset_id = 1;
bd.acc_levelset_emp.Add(level);
bd.SaveChanges();
}
}
public EmpCheckMonth(USERINFO emp, AttControlClass attControl, GetDeptNameDelgate GetDeptName)
{
Emp = emp;
DeptName = GetDeptName((short)emp.DEFAULTDEPTID);
AttControl = attControl;
GetDayType = AttControl.GetDayType;
EmpNote = AttControl.GetEmpNoteInfoByByte(emp.Notes);
if (EmpNote == null)
{
EmpNote = new EmpNoteInfo();
EmpNote.EmpPyName = PinyinHelper.PinyinString(emp.Name);
EmpNote.IsHaveNote = true;
AttControl.UpDateEmpNoteInfo(emp.USERID, EmpNote);
}
}
public async Task <IHttpActionResult> RegisterUser(RegisterModel registermodel)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = new USERINFO()
{
full_name = registermodel.FullName,
UserName = registermodel.UserName,
Email = registermodel.Email,
EmailConfirmed = false,
PhoneNumber = registermodel.MobileNo,
};
IdentityResult result = await UserManager.CreateAsync(user, registermodel.Password);
if (result.Succeeded)
{
/*
* var provider = new DpapiDataProtectionProvider("TalentSpire");
* UserManager.EmailService = new EmailService();
* string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
* var newRouteValues = new System.Web.Routing.RouteValueDictionary(new { userId = user.Id, code = code })
* {
* {"httproute", true}
* };
* System.Web.Mvc.UrlHelper urlHelper = new System.Web.Mvc.UrlHelper(System.Web.HttpContext.Current.Request.RequestContext, System.Web.Routing.RouteTable.Routes);
* var callbackUrl = urlHelper.Action("ConfirmEmail", "Account", newRouteValues, System.Web.HttpContext.Current.Request.Url.Scheme);
* var body = CreateMailBody(callbackUrl, "Gabriel xavier");
* await UserManager.SendEmailAsync(user.Id,
* "Welcome to Talentspire - Confirm account", body);
* Uri locationHeader = new Uri(Url.Link("GetUserById", new { id = user.Id })); */
return(Ok());
}
else
{
return(GetErrorResult(result));
}
}
catch (Exception ex)
{
return(BadRequest(ex.InnerException.ToString()));
}
}
public ActionResult ShowEditInfo()
{
decimal id = decimal.Parse(Request["id"]);
USERINFO userInfo = UserInfoService.LoadEntities(c => c.ID == id).FirstOrDefault();
//使用匿名类，解决USERINFO中有集合类数据ICollection<R_USERINFO_ACTIONINFO>转换JSON失败的问题
var obj = new
{
userInfo.UNAME,
userInfo.UPWD,
userInfo.REMARK,
userInfo.SORT,
userInfo.DELFLAG,
userInfo.SUBTIME
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
