private static string SaveLoginSession(USER user)
{
LoginSession ls = new LoginSession(user.FIRST_NAME + "." + user.LAST_NAME, user.ROLE);
string result=myConvert.Serialize(ls);
HttpContext.Current.Session["user"] = user;
return result;
}
public ActionResult Create(USER user)
{
if (ModelState.IsValid)
{
db.USERS.Add(user);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(user);
}
public virtual void Remove(USER user)
{
try
{
db.USERs.DeleteOnSubmit(user);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(USER user)
{
try
{
this.db.USERs.InsertOnSubmit(user);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Update(USER user)
{
try
{
USER userOld = this.GetById(user.USER_ID);
userOld = user;
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public bool AddNewUserToDatabase(USER user)
{
_users.InsertOnSubmit(user);
try
{
_dataContext.SubmitChanges();
}
catch (Exception ex)
{
_log.Error(ex.Message);
return false;
}
return true;
}
public static string InsertUser(string firstName, string lastName,string loginID, string password,string email,string role)
{
try
{
if (mydb.USERs.SingleOrDefault(u => u.USER_ID == loginID) != null)
{
return "";
}
USER user = new USER() { FIRST_NAME = firstName, LAST_NAME = lastName, PASSWORD = password, EMAIL = email, USER_ID = loginID, REGISTER_DATE=DateTime.Now, ROLE=role };
mydb.USERs.InsertOnSubmit(user);
mydb.SubmitChanges();
return SaveLoginSession(user);
}
catch (Exception e)
{
return e.Message;
}
}
public HttpResponseMessage addUser([FromBody] USER UserData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
try
{
USER user = new USER();
user.Email = UserData.Email;
user.Password = UserData.Password;
ctx.USERS.Add(user);
ctx.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
}
}
private void CreateUser(User user)
{
using (var ctx = new LANBackupContext())
{
var dbuser=ctx.USERS.FirstOrDefault(p => p.USERID == user.UserId);
if (dbuser != null)
{
dbuser.PASSWORD = user.Password;
dbuser.DOMAIN = user.Domain;
ctx.SaveChanges();
}
else
{
dbuser = new USER { USERID = user.UserId, PASSWORD = user.Password, DOMAIN = user.Domain };
ctx.USERS.Add(dbuser);
ctx.SaveChanges();
}
}
}
partial void DeleteUSER(USER instance);
public void Save_Info(string strLink = "")
{
try
{
if (_iUserID > 0)
{
var user_update = db.GetTable<USER>().Where(g => g.USER_ID == _iUserID);
if (user_update.ToList().Count > 0)
{
DateTime _dateBirth = new DateTime();
//string _sDay = clsUtility.Utils.CStrDef(ddlDay.SelectedValue, string.Empty);
//string _sMonth = clsUtility.Utils.CStrDef(ddlMonth.SelectedValue, string.Empty);
//string _sYear = clsUtility.Utils.CStrDef(ddlYear.SelectedValue, string.Empty);
//_dateBirth = clsUtility.Utils.StrDateToDate(_sDay + "/" + _sMonth + "/" + _sYear, "dd/MM/yyyy");
user_update.First().USER_ACTIVE = Convert.ToInt16(rblActive.SelectedValue);
user_update.First().USER_ADDRESS = txtAddress.Text;
//user_update.First().USE_CODE = txtCode.Text;
//user_update.First().TYPE = clsUtility.Utils.CIntDef(rblType.SelectedValue, 0) == 0 ? 0 : 1;
// user_update.First().AT_EMP_DATEOFBIRTH = _dateBirth;
//user_update.First().AT_EMP_LASTUPDATE = DateTime.Now;
user_update.First().GROUP_ID = clsUtility.Utils.CIntDef(ddlGroup.SelectedValue, 0);
user_update.First().USER_EMAIL = txtEmail.Text;
//user_update.First().AT_EMP_GENDER = clsUtility.Utils.CIntDef(rblGender.SelectedValue);
user_update.First().USER_NAME = txtUserFullName.Text;
user_update.First().USER_PHONE = txtPhone.Text;
user_update.First().USER_UN = txtUserName.Text;
// user_update.First().USE_OIDENTITY = txtIdentity.Text;
db.SubmitChanges();
strLink = string.IsNullOrEmpty(strLink) ? "changeinfo.aspx" : strLink;
}
}
else
{
USER user_insert = new USER();
DateTime _dateBirth = new DateTime();
//string _sDay = clsUtility.Utils.CStrDef(ddlDay.SelectedValue, string.Empty);
//string _sMonth = clsUtility.Utils.CStrDef(ddlMonth.SelectedValue, string.Empty);
//string _sYear = clsUtility.Utils.CStrDef(ddlYear.SelectedValue, string.Empty);
string _sSalt = clsUtility.Common.CreateSalt();
// _dateBirth = clsUtility.Utils.StrDateToDate(_sDay + "/" + _sMonth + "/" + _sYear, "dd/MM/yyyy");
user_insert.USER_ACTIVE = Convert.ToInt16(rblActive.SelectedValue);
user_insert.USER_ADDRESS = txtAddress.Text;
//user_insert.USE_CODE = txtCode.Text;
//user_insert.USE_OIDENTITY = txtIdentity.Text;
//user_insert.AT_EMP_DATEOFBIRTH = _dateBirth;
// user_insert.AT_EMP_LASTUPDATE = DateTime.Now;
user_insert.GROUP_ID = clsUtility.Utils.CIntDef(ddlGroup.SelectedValue, 0);
user_insert.USER_EMAIL = txtEmail.Text;
//user_insert.AT_EMP_GENDER = clsUtility.Utils.CIntDef(rblGender.SelectedValue);
user_insert.USER_NAME = txtUserFullName.Text;
user_insert.USER_PHONE = txtPhone.Text;
user_insert.USER_UN = txtUserName.Text;
user_insert.SALT = _sSalt;
user_insert.USER_PW = clsUtility.Common.Encrypt(txtPassword.Text, _sSalt);
db.USERs.InsertOnSubmit(user_insert);
db.SubmitChanges();
var _vEmp = db.GetTable<USER>().OrderByDescending(a => a.USER_ID);
_iUserID = clsUtility.Utils.CIntDef(_vEmp.First().USER_ID);
strLink = string.IsNullOrEmpty(strLink) ? "changeinfo.aspx" : strLink;
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
finally
{
if (!string.IsNullOrEmpty(strLink))
{
Response.Redirect(strLink);
}
}
}
private bool IsValidUserAndPasswordCombination(string Email, string Password)
{
existUser = context.USER.FirstOrDefault(u => u.USER_NAME == Email && u.PASSWORD == Password);
return(existUser != null);
}
partial void InsertUSER(USER instance);
private void Save(string strLink = "")
{
try
{
string SALT = "";
string USER_PW = "";
if (!string.IsNullOrEmpty(Txtpass.Text))
{
if (Txtpass.Text != Txtrepass.Text)
{
Lberrors.Text = "2 mật khẩu không giống nhau";
}
else
{
SALT = Common.CreateSalt();
USER_PW = Common.Encrypt(Txtpass.Text, SALT);
}
}
if (_userid == 0)
{
USER user = new USER();
user.USER_NAME = Txtname.Text;
user.USER_UN = Txtusername.Text;
user.USER_MACC = txtMaCC.Text;
user.USER_GIOITINH = Utils.CIntDef(rdoGioiTinh.SelectedValue);
user.USER_NGAYSINH = txtNgaySinh.Text == "" ? user.USER_NGAYSINH = null :
DateTime.ParseExact(txtNgaySinh.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
user.USER_CMND = txtCMND.Text;
user.USER_CMND_NGAYCAP = txtNgayCapCMND.Text == "" ? user.USER_CMND_NGAYCAP = null :
DateTime.ParseExact(txtNgayCapCMND.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
user.USER_CMND_NOICAP = txtNoiCapCMND.Text;
user.USER_DANTOC = txtDanToc.Text;
user.USER_NGUYENQUAN = txtNguyenQuan.Text;
user.USER_NOIDK_HK = txtNoiDK_HK.Text;
user.USER_ADDRESS = Txtaddress.Text;
user.USER_EMAIL = Txtemail.Text;
user.USER_EMAIL_CANHAN = txtEmail_CaNhan.Text;
user.USER_PHONE = Txtphone.Text;
user.USER_PHONE_CANHAN = txtPhone_CaNhan.Text;
user.USER_TRINHDO = txtTrinhDo.Text;
user.NT_HOTEN = txtNT_HoTen.Text;
user.NT_SDT = txtNT_SDT.Text;
user.NT_MOIQUANHE = txtNT_MoiQuanHe.Text;
user.GROUP_ID = Utils.CIntDef(Drgroup.SelectedValue);
user.USER_CHINHANH = Utils.CIntDef(ddlChiNhanh.SelectedValue);
user.USER_DATE = DateTime.Now;
db.USERs.InsertOnSubmit(user);
db.SubmitChanges();
SendEmailNew(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(Drgroup.SelectedItem), rdoGioiTinh.SelectedValue == "1" ? "Nam" : "Nữ"
, txtNgaySinh.Text, txtCMND.Text, txtNgayCapCMND.Text, txtNoiCapCMND.Text, txtDanToc.Text, txtNguyenQuan.Text, txtNoiDK_HK.Text
, Txtaddress.Text, txtEmail_CaNhan.Text, Txtphone.Text, txtPhone_CaNhan.Text, txtTrinhDo.Text, txtNT_HoTen.Text, txtNT_SDT.Text, txtNT_MoiQuanHe.Text, getDiaDiem(ddlChiNhanh.SelectedValue));
var getlink = db.USERs.OrderByDescending(n => n.USER_ID).Take(1).ToList();
if (getlink.Count > 0)
{
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-nhan-vien.aspx?userid=" + getlink[0].USER_ID : strLink;
}
}
else
{
var list = db.USERs.Where(n => n.USER_ID == _userid).ToList();
if (ASPxPageControl2.ActiveTabIndex == 0)
{
foreach (var i in list)
{
i.USER_NAME = Txtname.Text;
i.USER_UN = Txtusername.Text;
i.USER_MACC = txtMaCC.Text;
i.USER_GIOITINH = Utils.CIntDef(rdoGioiTinh.SelectedValue);
i.USER_NGAYSINH = txtNgaySinh.Text == "" ? i.USER_NGAYSINH = null :
DateTime.ParseExact(txtNgaySinh.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
i.USER_CMND = txtCMND.Text;
i.USER_CMND_NGAYCAP = txtNgayCapCMND.Text == "" ? i.USER_CMND_NGAYCAP = null :
DateTime.ParseExact(txtNgayCapCMND.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
i.USER_CMND_NOICAP = txtNoiCapCMND.Text;
i.USER_DANTOC = txtDanToc.Text;
i.USER_NGUYENQUAN = txtNguyenQuan.Text;
i.USER_NOIDK_HK = txtNoiDK_HK.Text;
i.USER_ADDRESS = Txtaddress.Text;
i.USER_EMAIL = Txtemail.Text;
i.USER_EMAIL_CANHAN = txtEmail_CaNhan.Text;
i.USER_PHONE = Txtphone.Text;
i.USER_PHONE_CANHAN = txtPhone_CaNhan.Text;
i.USER_TRINHDO = txtTrinhDo.Text;
i.NT_HOTEN = txtNT_HoTen.Text;
i.NT_SDT = txtNT_SDT.Text;
i.NT_MOIQUANHE = txtNT_MoiQuanHe.Text;
i.GROUP_ID = Utils.CIntDef(Drgroup.SelectedValue);
i.USER_CHINHANH = Utils.CIntDef(ddlChiNhanh.SelectedValue);
}
SendEmailChange(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(Drgroup.SelectedItem), rdoGioiTinh.SelectedValue == "1" ? "Nam" : "Nữ"
, txtNgaySinh.Text, txtCMND.Text, txtNgayCapCMND.Text, txtNoiCapCMND.Text, txtDanToc.Text, txtNguyenQuan.Text, txtNoiDK_HK.Text
, Txtaddress.Text, txtEmail_CaNhan.Text, Txtphone.Text, txtPhone_CaNhan.Text, txtTrinhDo.Text, txtNT_HoTen.Text, txtNT_SDT.Text, txtNT_MoiQuanHe.Text, getDiaDiem(ddlChiNhanh.SelectedValue));
}
else if (ASPxPageControl2.ActiveTabIndex == 1)
{//Khi Tab Index = 1 thì cho đổi pass
foreach (var i in list)
{
if (i.USER_PW != null && i.USER_PW != "")
{
SendEmailChangePas(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(rblActive.SelectedItem), Txtpass.Text);
}
else
{
SendEmailCreatePas(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(rblActive.SelectedItem), Txtpass.Text);
}
if (!string.IsNullOrEmpty(USER_PW))
{
i.SALT = SALT;
i.USER_PW = USER_PW;
}
i.USER_ACTIVE = Utils.CIntDef(rblActive.SelectedValue);
}
}
else
{
foreach (var i in list)
{
i.USER_LUONG_CB = Utils.CDecDef(txtLuongCanBan.Text.Replace(",", ""));
if (rdoCoBH.SelectedValue == "1")
{
i.USER_COBH = Utils.CIntDef(rdoCoBH.SelectedValue);
i.USER_LUONG_BH = Utils.CDecDef(txtLuongBHCD.Text.Replace(",", ""));
i.USER_BHXH_PT = Utils.CDblDef(txtPT_BHXH.Text.Replace(",", "."), 0);
i.USER_BHYT_PT = Utils.CDblDef(txtPT_BHYT.Text.Replace(",", "."), 0);
i.USER_BHTN_PT = Utils.CDblDef(txtPT_BHTN.Text.Replace(",", "."), 0);
i.USER_BHXH = Utils.CDecDef(txtCTBHXH.Text.Replace(",", ""));
i.USER_BHYT = Utils.CDecDef(txtCTBHYT.Text.Replace(",", ""));
i.USER_BHTN = Utils.CDecDef(txtCTBHTN.Text.Replace(",", ""));
}
}
}
db.SubmitChanges();
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-nhan-vien.aspx?userid=" + _userid : strLink;
}
}
catch (Exception)
{
throw;
}
finally
{
if (!string.IsNullOrEmpty(strLink))
{
Response.Redirect(strLink);
}
}
}
public async Task <IActionResult> OnPostConfirmationAsync(string returnUrl = null)
{
returnUrl = returnUrl ?? Url.Content("~/");
// Get the information about the user from the external login provider
var info = await _signInManager.GetExternalLoginInfoAsync();
if (info == null)
{
ErrorMessage = "Error loading external login information during confirmation.";
return(RedirectToPage("./Login", new { ReturnUrl = returnUrl }));
}
if (ModelState.IsValid)
{
var user = new USER {
UserName = Input.Email, Email = Input.Email
};
var result = await _userManager.CreateAsync(user);
if (result.Succeeded)
{
result = await _userManager.AddLoginAsync(user, info);
if (result.Succeeded)
{
_logger.LogInformation("User created an account using {Name} provider.", info.LoginProvider);
var userId = await _userManager.GetUserIdAsync(user);
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code));
var callbackUrl = Url.Page(
"/Account/ConfirmEmail",
pageHandler: null,
values: new { area = "Identity", userId = userId, code = code },
protocol: Request.Scheme);
await _emailSender.SendEmailAsync(Input.Email, "Confirm your email",
$"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>.");
// If account confirmation is required, we need to show the link if we don't have a real email sender
if (_userManager.Options.SignIn.RequireConfirmedAccount)
{
return(RedirectToPage("./RegisterConfirmation", new { Email = Input.Email }));
}
await _signInManager.SignInAsync(user, isPersistent : false, info.LoginProvider);
return(LocalRedirect(returnUrl));
}
}
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
ProviderDisplayName = info.ProviderDisplayName;
ReturnUrl = returnUrl;
return(Page());
}
protected void btnChangePass_Click(object sender, EventArgs e)
{
if (btnChangePass.Text == "Change Pasword" &&
divexistingPass.Visible == false)
{
try
{
//re set the password
bool success = handler.updateUserAccountPassword(
auth.generatePassHash(txtNewPasword.Text.ToString().Replace(" ", string.Empty))
, restPassAccount.UserID.ToString());
if (success == true)
{
//send confermation email
var body = new System.Text.StringBuilder();
body.AppendFormat("Hello User,");
body.AppendLine(@"");
body.AppendLine(@"Your Password Was Successfully Rest.");
body.AppendLine(@"");
body.AppendLine(@"Make a Booking Now --> http://sict-iis.nmmu.ac.za/beauxdebut/MakeABooking.aspx.");
body.AppendLine(@"");
body.AppendLine(@"Regards,");
body.AppendLine(@"The Cheveux Team");
success = function.sendEmailAlert(handler.GetUserDetails(restPassAccount.UserID.ToString()).Email.ToString(), "Cheveux User",
"Password Rest Succesful",
body.ToString(),
"Accounts Cheveux");
//let the user know the password was succefuly rest
lPaswordResetUsernameLable.Visible = true;
lPaswordResetUsernameLable.Text = "Your Password Has Successfully Been Reset";
divResetPaswordtxtPass.Visible = false;
btnChangePass.Text = "Done";
}
else
{
//let the user know the password was succefuly rest
function.logAnError("Error reseting password on accounts page for reset code: " + code);
lPaswordResetUsernameLable.Visible = true;
lPaswordResetUsernameLable.Text = "An error occurred, Please try again later.";
divResetPaswordtxtPass.Visible = false;
btnChangePass.Text = "Done";
}
}
catch (Exception Err)
{
//let the use know an erorr ocoured
lPaswordResetUsernameLable.Visible = true;
divResetPaswordtxtPass.Visible = false;
btnChangePass.Visible = false;
lPaswordResetUsernameLable.Text = "An error occurred communicating with the Cheveux Server, Please try again later.";
function.logAnError("Error reseting password on accounts page for reset code: " + code +
Err.ToString());
}
}
else if (btnChangePass.Text == "Change Pasword" &&
divexistingPass.Visible == true)
{
HttpCookie UserID = Request.Cookies["CheveuxUserID"];
USER user = handler.GetUserDetails(UserID["ID"]);
try
{
//check if the credentials are correct
string[] result = auth.AuthenticateEmail(user.UserName.ToString().Replace(" ", string.Empty),
txtExistingPassword.Text.ToString().Replace(" ", string.Empty));
/*
* if the user deatails are incorect let the user know
*/
if (result[0].ToString().Replace(" ", string.Empty) == "Error")
{
//let the use know the account details were incorect
wrongExsistingPass.Visible = true;
wrongExsistingPass.Text = "Wrong password";
}
//if the user details are corect change the password
else if (result[1].ToString().Replace(" ", string.Empty) == "C" ||
result[1].ToString().Replace(" ", string.Empty) == "E")
{
//re set the password
bool success = handler.updateUserAccountPassword(auth.generatePassHash(txtNewPasword.Text.ToString().Replace(" ", string.Empty)),
UserID["ID"].ToString().Replace(" ", string.Empty));
if (success == true)
{
//send confermation email
var body = new System.Text.StringBuilder();
body.AppendFormat("Hello " + user.FirstName + ",");
body.AppendLine(@"");
body.AppendLine(@"Your Password Was Successfully Changed.");
body.AppendLine(@"");
body.AppendLine(@"Make a Booking Now --> http://sict-iis.nmmu.ac.za/beauxdebut/MakeABooking.aspx.");
body.AppendLine(@"");
body.AppendLine(@"Regards,");
body.AppendLine(@"The Cheveux Team");
success = function.sendEmailAlert(user.Email.ToString(), "Cheveux User",
"Password Changed",
body.ToString(),
"Accounts Cheveux");
//let the user know the password was succefuly rest
lPaswordResetUsernameLable.Visible = true;
lPaswordResetUsernameLable.Text = "Your Password Has Successfully Been Changed";
divResetPaswordtxtPass.Visible = false;
divexistingPass.Visible = false;
btnChangePass.Text = "Done";
}
else
{
//let the user know the password was succefuly rest
function.logAnError("Error changeing password for username: "******"An error occurred, Please try again later.";
divResetPaswordtxtPass.Visible = false;
divexistingPass.Visible = false;
btnChangePass.Text = "Done";
}
}
}
catch (Exception Err)
{
//let the use know an erorr ocoured
lPaswordResetUsernameLable.Visible = true;
lPaswordResetUsernameLable.Text = "An error occurred communicating with the Cheveux Server, Please try again later.";
function.logAnError("Error changeing password for username: "******"Done" && txtExistingPassword.Text == null)
{
Response.Redirect("../Authentication/Accounts.aspx?Type=Email");
}
else if (btnChangePass.Text == "Done" && txtExistingPassword.Text != null)
{
Response.Redirect("../Profile.aspx");
}
}
public ActionResult Register(string username, string password, string mail, string phone)
{
var taikhoan = (from a in db.USERS select a.USER_NAME).ToList();
foreach (var tk in taikhoan)
{
if (username == tk)
{
ViewBag.Message = "User already exists";
ViewBag.error_tk = true;
ViewBag.tentk = username;
ViewBag.sdt = phone;
ViewBag.mail = mail;
return(View("Register"));
}
}
var sodt = (from p in db.USERS select p.SODT).ToList();
foreach (var so in sodt)
{
if (phone == so)
{
ViewBag.Message = "Number already exists";
ViewBag.error_sodt = true;
ViewBag.tentk = username;
ViewBag.sdt = phone;
ViewBag.mail = mail;
return(View("Register"));
}
}
var email = (from e in db.USERS select e.EMAIL).ToList();
foreach (var maill in email)
{
if (mail == maill)
{
ViewBag.Message = "Email already exists";
ViewBag.error_email = true;
ViewBag.tentk = username;
ViewBag.sdt = phone;
ViewBag.mail = mail;
return(View("Register"));
}
}
var ngdung = (from m in db.USERS where m.SODT == null select m).Single();
ngdung.USER_NAME = username;
ngdung.PASSWORD = password;
ngdung.SODT = phone;
ngdung.EMAIL = mail;
db.Entry(ngdung).State = EntityState.Modified;
string ID = ngdung.USER_ID;
int num = int.Parse(ID.Substring(2)) + 1;
string IDnext = "US" + num.ToString();
USER IDmoi = new USER();
IDmoi.USER_ID = IDnext;
db.USERS.Add(IDmoi);
db.SaveChanges();
ViewBag.Message = "Success!";
return(View("Login"));
}
private void getgoogleplususerdataSer(string access_token)
{
try
{
string _email = "";
string _fullname = "";
//HttpClient client = new HttpClient();
var urlProfile = "https://www.googleapis.com/oauth2/v1/userinfo?access_token=" + access_token;
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(urlProfile);
//Đọc dữ liệu urlProfile đã nhận
using (var response = req.GetResponse())
using (var reader = new StreamReader(response.GetResponseStream()))
{
string x = reader.ReadToEnd();
string[] lines = Regex.Split(x.Replace("\": ", ":").Replace("\n \"", "").Replace("\"", "").Replace("{", ""), ",");
if (lines.Count() > 0)
{
for (int i = 0; i < lines.Count(); i++)
{
if (Regex.Split(lines[i], ":").Count() == 2)
{//Gán dữ liệu Email
if (Regex.Split(lines[i], ":")[0] == "email")
{
_email = Regex.Split(lines[i], ":")[1];
}
}
if (Regex.Split(lines[i], ":").Count() == 2)
{//Gàn dữ liệu Tên
if (Regex.Split(lines[i], ":")[0] == "name")
{
_fullname = Regex.Split(lines[3], ":")[1];
}
}
}
}
}
if (_email != "")
{
HttpContext.Current.Session["user_email"] = _email;
HttpContext.Current.Session["user_username"] = _fullname;
if (!CheckExitsEmail(_email))
{
USER user = new USER();
user.EMAIL = _email;
user.NAME = _fullname;
user.LASTUPDATE = DateTime.Now;
user.ACTIVE = 1;
db.USERs.InsertOnSubmit(user);
db.SubmitChanges();
HttpContext.Current.Session["user_id"] = user.OID;
}
else
{
var item = db.USERs.Where(n => n.EMAIL == _email);
if (item != null && item.ToList().Count > 0)
{
HttpContext.Current.Session["user_id"] = item.ToList()[0].OID;
}
}
//Response.Redirect("/");
}
string strScript = "<script>";
strScript += "window.onunload = refreshParent;function refreshParent() {window.opener.location.href='/';}";
//strScript += "window.onunload = refreshParent;function refreshParent() {window.opener.location.reload();}";
strScript += "window.parent.close();";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
catch (Exception ex)
{
//catching the exception
}
}
public HttpResponseMessage googleSignIn([FromBody] USER userData)
{
var request = (HttpWebRequest)WebRequest.Create("https://www.googleapis.com/oauth2/v3/tokeninfo?id_token=" + userData.Password);
try
{
using (WebResponse response = request.GetResponse())
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
if (userData == null)
return Request.CreateResponse(HttpStatusCode.BadRequest);
var user = ctx.USERS.Where(x => x.Email == userData.Email).FirstOrDefault();
if (user == null)
{
try
{
USER u = new USER();
u.Email = userData.Email;
u.Password = userData.Password.Substring(0, 16);
ctx.USERS.Add(u);
ctx.SaveChanges();
return Request.CreateResponse(HttpStatusCode.OK);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
}
else
{
var returnUser = new USER();
returnUser.Email = user.Email;
returnUser.ID = user.ID;
return Request.CreateResponse(HttpStatusCode.OK, returnUser);
}
}
}
}
catch (WebException e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
}
public void Save_Info(string strLink = "")
{
try
{
if (_iUserID > 0)
{
var user_update = db.GetTable <USER>().Where(g => g.USER_ID == _iUserID);
if (user_update.ToList().Count > 0)
{
DateTime _dateBirth = new DateTime();
//string _sDay = clsUtility.Utils.CStrDef(ddlDay.SelectedValue, string.Empty);
//string _sMonth = clsUtility.Utils.CStrDef(ddlMonth.SelectedValue, string.Empty);
//string _sYear = clsUtility.Utils.CStrDef(ddlYear.SelectedValue, string.Empty);
//_dateBirth = clsUtility.Utils.StrDateToDate(_sDay + "/" + _sMonth + "/" + _sYear, "dd/MM/yyyy");
user_update.First().USER_ACTIVE = Convert.ToInt16(rblActive.SelectedValue);
user_update.First().USER_ADDRESS = txtAddress.Text;
//user_update.First().USE_CODE = txtCode.Text;
//user_update.First().TYPE = clsUtility.Utils.CIntDef(rblType.SelectedValue, 0) == 0 ? 0 : 1;
// user_update.First().AT_EMP_DATEOFBIRTH = _dateBirth;
//user_update.First().AT_EMP_LASTUPDATE = DateTime.Now;
user_update.First().GROUP_ID = clsUtility.Utils.CIntDef(ddlGroup.SelectedValue, 0);
user_update.First().USER_EMAIL = txtEmail.Text;
//user_update.First().AT_EMP_GENDER = clsUtility.Utils.CIntDef(rblGender.SelectedValue);
user_update.First().USER_NAME = txtUserFullName.Text;
user_update.First().USER_PHONE = txtPhone.Text;
user_update.First().USER_UN = txtUserName.Text;
// user_update.First().USE_OIDENTITY = txtIdentity.Text;
db.SubmitChanges();
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-nhan-vien.aspx?id=" + _iUserID : strLink;
}
}
else
{
USER user_insert = new USER();
DateTime _dateBirth = new DateTime();
//string _sDay = clsUtility.Utils.CStrDef(ddlDay.SelectedValue, string.Empty);
//string _sMonth = clsUtility.Utils.CStrDef(ddlMonth.SelectedValue, string.Empty);
//string _sYear = clsUtility.Utils.CStrDef(ddlYear.SelectedValue, string.Empty);
string _sSalt = clsUtility.Common.CreateSalt();
// _dateBirth = clsUtility.Utils.StrDateToDate(_sDay + "/" + _sMonth + "/" + _sYear, "dd/MM/yyyy");
user_insert.USER_ACTIVE = Convert.ToInt16(rblActive.SelectedValue);
user_insert.USER_ADDRESS = txtAddress.Text;
//user_insert.USE_CODE = txtCode.Text;
//user_insert.USE_OIDENTITY = txtIdentity.Text;
//user_insert.AT_EMP_DATEOFBIRTH = _dateBirth;
// user_insert.AT_EMP_LASTUPDATE = DateTime.Now;
user_insert.GROUP_ID = clsUtility.Utils.CIntDef(ddlGroup.SelectedValue, 0);
user_insert.USER_EMAIL = txtEmail.Text;
//user_insert.AT_EMP_GENDER = clsUtility.Utils.CIntDef(rblGender.SelectedValue);
user_insert.USER_NAME = txtUserFullName.Text;
user_insert.USER_PHONE = txtPhone.Text;
user_insert.USER_UN = txtUserName.Text;
user_insert.SALT = _sSalt;
user_insert.USER_PW = clsUtility.Common.Encrypt(txtPassword.Text, _sSalt);
db.USERs.InsertOnSubmit(user_insert);
db.SubmitChanges();
var _vEmp = db.GetTable <USER>().OrderByDescending(a => a.USER_ID);
_iUserID = clsUtility.Utils.CIntDef(_vEmp.First().USER_ID);
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-nhan-vien.aspx?id=" + _iUserID : strLink;
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
finally
{
if (!string.IsNullOrEmpty(strLink))
{
Response.Redirect(strLink);
}
}
}
public int Update(int input)
{
string nama, email, jobtitle, jenis_kelamin, password;
DateTime tanggal_lahir;
//int id_dept, id_rol;
// inputan by user
var getAll = from u in context.Users.ToList()
join d in context.Departments.ToList()
on u.department_id equals d.department_id
join r in context.Roles.ToList()
on u.role_id equals r.role_id
select u;
var users = context.Users.Find(input);
if (users == null)
{
Console.Write("User dengan ID " + input + " tidak tersedia");
}
else
{
Console.WriteLine("--------Data Sebelum di Update---------");
Console.WriteLine("Id : " + users.user_id);
Console.WriteLine("Name : " + users.name);
Console.WriteLine("Email : " + users.email);
Console.WriteLine("Job Title : " + users.job_title);
Console.WriteLine("Gender : " + users.gender);
Console.WriteLine("Birth Date : " + users.birth_date);
Console.WriteLine("Password : "******"Department : " + users.Departments.name);
Console.WriteLine("Role : " + users.Roles.name);
Console.WriteLine("-------------------------\n");
Console.Write("Masukkan Nama Lengkap : ");
nama = Console.ReadLine();
Console.Write("Masukkan Email : ");
email = Console.ReadLine();
Console.Write("Masukkan Job Title : ");
jobtitle = Console.ReadLine();
Console.Write("Masukkan Gender : ");
jenis_kelamin = Console.ReadLine();
Console.Write("Masukkan Birth Date : ");
tanggal_lahir = Convert.ToDateTime(Console.ReadLine());
Console.Write("Masukkan Password : "******"Masukkan Department ID : ");
* id_dept = Convert.ToInt32(Console.ReadLine());
* Console.Write("Masukkan Role ID : ");
* id_rol = Convert.ToInt32(Console.ReadLine());*/
USER uSER = GetById(input);
uSER.name = nama;
uSER.email = email;
uSER.job_title = jobtitle;
uSER.gender = jenis_kelamin;
uSER.birth_date = tanggal_lahir;
uSER.password = password;
context.Entry(uSER).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
Console.WriteLine("\n--------Data Sesudah di Update---------");
Console.WriteLine("Id : " + users.user_id);
Console.WriteLine("Name : " + users.name);
Console.WriteLine("Email : " + users.email);
Console.WriteLine("Job Title : " + users.job_title);
Console.WriteLine("Gender : " + users.gender);
Console.WriteLine("Birth Date : " + users.birth_date);
Console.WriteLine("Password : "******"Department : " + users.department_id);
Console.WriteLine("Role : " + users.role_id);
Console.WriteLine("-------------------------");
}
return(input);
}
public ActionResult Create(FormCollection f)
{
try
{
string _Name = f.Get("Name").ToString();
string _Address = f.Get("Address").ToString();
string _Note = f.Get("Note").ToString();
string _Email = f.Get("Email").ToString();
string _Mobile = f.Get("Mobile").ToString();
int _ShipVia = int.Parse(f.Get("ListShipper").ToString());
if (Session["Order_Id"] == null)
{
ORDER _ORDER = new ORDER();
ORDER_DETAILS _ORDER_DETAILS = null;
USER _USER = (USER)Session["SS_USER"];
if (_USER != null)
{
_ORDER.USER_ID = _USER.USER_ID;
}
else
{
_ORDER.USER_ID = 0;
}
_ORDER.ORDER_CODE = m_STRING_RAMDOM.RandomString();
_ORDER.ORDER_DATE = DateTime.Now;
_ORDER.SHIP_NAME = _Name;
_ORDER.SHIP_ADDRESS = _Address;
_ORDER.SHIP_PHONE = _Mobile;
_ORDER.SHIP_EMAIL = _Email;
_ORDER.NOTE = _Note;
_ORDER.ORDER_STATUS_ID = 3;
_ORDER.SHIP_VIA_ID = _ShipVia;
_ORDER.FREIGHT = (decimal)db.SHIPPERS.Single(n => n.SHIPPER_ID == _ORDER.SHIP_VIA_ID).FREIGHT;
_ORDER.SUBTOTAL = decimal.Parse(Session["TOTAL_PRICE"].ToString());
db.ORDERS.Add(_ORDER);
db.SaveChanges();
List <ProductCart> _lstProductCart = (List <ProductCart>)Session["ShoppingCart"];
foreach (var product in _lstProductCart)
{
_ORDER_DETAILS = new ORDER_DETAILS();
_ORDER_DETAILS.ORDER_ID = _ORDER.ORDER_ID;
_ORDER_DETAILS.PRODUCT_ID = product.PRODUCT_ID;
_ORDER_DETAILS.UNIT_PRICE = product.UNIT_PRICE;
_ORDER_DETAILS.UNIT = product.UNIT;
_ORDER_DETAILS.QUANTITY = product.QUANTITY;
_ORDER_DETAILS.EXTENDED_PRICE = product.TOTAL_PRICE;
db.ORDER_DETAILS.Add(_ORDER_DETAILS);
}
db.SaveChanges();
Session["Order_Id"] = _ORDER.ORDER_ID;
}
else
{
int _Order_Id = (int)Session["Order_Id"];
ORDER _ORDER = db.ORDERS.Find(_Order_Id);
USER _USER = (USER)Session["SS_USER"];
if (_USER != null)
{
_ORDER.USER_ID = _USER.USER_ID;
}
else
{
_ORDER.USER_ID = 0;
}
_ORDER.ORDER_CODE = m_STRING_RAMDOM.RandomString();
_ORDER.ORDER_DATE = DateTime.Now;
_ORDER.SHIP_NAME = _Name;
_ORDER.SHIP_ADDRESS = _Address;
_ORDER.SHIP_PHONE = _Mobile;
_ORDER.SHIP_EMAIL = _Email;
_ORDER.NOTE = _Note;
_ORDER.ORDER_STATUS_ID = 3;
_ORDER.SHIP_VIA_ID = _ShipVia;
_ORDER.FREIGHT = (decimal)db.SHIPPERS.Single(n => n.SHIPPER_ID == _ORDER.SHIP_VIA_ID).FREIGHT;
_ORDER.SUBTOTAL = decimal.Parse(Session["TOTAL_PRICE"].ToString());
db.SaveChanges();
Session["Order_Id"] = _ORDER.ORDER_ID;
}
return(RedirectToAction("Payment", "Payment"));
}
catch (Exception ex)
{
return(RedirectToAction("Http404", "Error")); // 404
}
}
private void detach_USERs(USER entity)
{
this.SendPropertyChanging();
entity.KORISNIK = null;
}
private void attach_USERs(USER entity)
{
this.SendPropertyChanging();
entity.KORISNIK = this;
}
//上传人员信息
public JsonResult UploadUserFile()
{
var retModel = new JsonReturnModel();
try
{
if (Request.Files == null || Request.Files.Count == 0)
{
retModel.AddError("errorMessage", Common.GetLanguageValueByParam("请选择您要上传的附件！", "PRCommon", "PRItemType", Userinfo.language));
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
HttpPostedFileBase prfile = Request.Files[0];
string fileName = prfile.FileName.Substring(prfile.FileName.LastIndexOf("\\") + 1, prfile.FileName.Length - (prfile.FileName.LastIndexOf("\\")) - 1);
if (!fileName.ToLower().Contains(".xls") && !fileName.ToLower().Contains(".xlsx"))
{
retModel.AddError("errorMessage", "只能上传Excel文件！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
string filePath = ConfigurationManager.AppSettings["UploadPath"] + fileName;
prfile.SaveAs(filePath);
//获取数据库 所有的用户信息
List <USER> allUser = UserBll.GetAllUserInfo();
List <USER> list = new List <USER>();
using (FileStream fs = new FileStream(filePath, FileMode.Open))
{
IWorkbook workbook = null;
if (fileName.ToLower().Contains(".xlsx"))
{
workbook = new XSSFWorkbook(fs);
}
else
{
workbook = new HSSFWorkbook(fs);
}
ISheet sheet = workbook.GetSheetAt(0);
int rowNum = sheet.PhysicalNumberOfRows;
//获取整个组织架构
List <B_ORGANIZATIONALSTRUCTURE> dataList = OrganizationalStructureBll.GetOrganizationalStructureList();
for (int i = 0; i < rowNum; i++)
{
IRow row = sheet.GetRow(i);
if (i != 0)
{
USER model = new USER();
if (row.GetCell(0) != null)
{
model.B_JOBNUMBER = row.GetCell(0) != null?row.GetCell(0).ToString().Trim() : "";
model.B_CHINESENAME = row.GetCell(1) != null?row.GetCell(1).ToString().Trim() : "";
model.B_ENGLISHNAME = row.GetCell(2) != null?row.GetCell(2).ToString().Trim() : "";
model.B_CENTRE = row.GetCell(3) != null?row.GetCell(3).ToString().Trim() : "";
model.B_DEPARTMENT = row.GetCell(4) != null?row.GetCell(4).ToString().Trim() : "";
model.B_SENIORMANAGER = row.GetCell(5) != null?row.GetCell(5).ToString().Trim() : "";
model.B_DIRECTOR = row.GetCell(6) != null?row.GetCell(6).ToString().Trim() : "";
model.B_VP = row.GetCell(7) != null?row.GetCell(7).ToString().Trim() : "";
model.B_AFFILIATEDCOMPANY = row.GetCell(8) != null?row.GetCell(8).ToString().Trim() : "";
//根据用户名称判断用户是否存在
int count = allUser.Where(x => x.LOGIN_NAME.ToUpper() == model.B_ENGLISHNAME.ToUpper()).Count();
if (count == 0)
{
retModel.AddError("errorMessage", i + 1 + "行上传的用户不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
//判断中心是否存在
B_ORGANIZATIONALSTRUCTURE centreObj = dataList.Where(x => x.B_NODENAME == model.B_CENTRE && x.B_NODELEVEL == 2).FirstOrDefault();
if (centreObj == null)
{
retModel.AddError("errorMessage", i + 1 + "行上传的中心不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
//判断部门是否存在
List <B_ORGANIZATIONALSTRUCTURE> organizationalStructureList = new List <B_ORGANIZATIONALSTRUCTURE>();
if (!string.IsNullOrEmpty(model.B_DEPARTMENT))
{
OrganizationalStructureBll.GetChildByParent(inn, centreObj.B_NODECODE, organizationalStructureList, dataList);
int countDepartment = organizationalStructureList.Where(x => x.B_NODENAME == model.B_DEPARTMENT).Count();
if (countDepartment == 0)
{
retModel.AddError("errorMessage", i + 1 + "行上传的部门不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
}
//判断上传的高级经理是否存在
if (!string.IsNullOrEmpty(model.B_SENIORMANAGER))
{
var itemSeniorManager = allUser.Where(x => x.LOGIN_NAME.ToUpper() == model.B_SENIORMANAGER.ToUpper()).FirstOrDefault();
if (itemSeniorManager == null)
{
retModel.AddError("errorMessage", i + 1 + "行上传的高级经理不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
model.B_SENIORMANAGER = itemSeniorManager.FIRST_NAME;
}
//判断上传的总监是否存在
if (!string.IsNullOrEmpty(model.B_DIRECTOR))
{
var itemDirector = allUser.Where(x => x.LOGIN_NAME.ToUpper() == model.B_DIRECTOR.ToUpper()).FirstOrDefault();
if (itemDirector == null)
{
retModel.AddError("errorMessage", i + 1 + "行上传的总监不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
model.B_DIRECTOR = itemDirector.FIRST_NAME;
}
//判断上传的VP是否存在
if (!string.IsNullOrEmpty(model.B_VP))
{
var itemVP = allUser.Where(x => x.LOGIN_NAME.ToUpper() == model.B_VP.ToUpper()).FirstOrDefault();
if (itemVP == null)
{
retModel.AddError("errorMessage", i + 1 + "行上传的VP不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
model.B_VP = itemVP.FIRST_NAME;
}
//判断上传所属公司是否正确
if (!string.IsNullOrEmpty(model.B_AFFILIATEDCOMPANY))
{
List <string> arrList = model.B_AFFILIATEDCOMPANY.Split(';').Where(x => x != "").ToList();
foreach (var item in arrList)
{
if (item != "博郡" && item != "思致")
{
retModel.AddError("errorMessage", i + 1 + "行上传的所属公司不正确！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
}
}
list.Add(model);
}
}
}
Innovator adminInn = WorkFlowBll.GetAdminInnovator();
//修改数据库中的数据
if (list != null && list.Count > 0 && adminInn != null)
{
for (int i = 0; i < list.Count; i++)
{
var item = list[i];
//string userName = item.B_ENGLISHNAME.ToUpper() + " " + "(" + item.B_CHINESENAME + ")";
USER userObj = allUser.Where(x => x.LOGIN_NAME.ToUpper() == item.B_ENGLISHNAME.ToUpper()).First();
var user = adminInn.newItem("User", "edit");
user.setAttribute("id", userObj.ID);
user.setProperty("b_jobnumber", item.B_JOBNUMBER);
user.setProperty("b_chinesename", item.B_CHINESENAME);
user.setProperty("b_englishname", item.B_ENGLISHNAME);
user.setProperty("b_centre", item.B_CENTRE);
user.setProperty("b_department", item.B_DEPARTMENT);
user.setProperty("b_seniormanager", item.B_SENIORMANAGER);
user.setProperty("b_director", item.B_DIRECTOR);
user.setProperty("b_vp", item.B_VP);
user.setProperty("b_affiliatedcompany", item.B_AFFILIATEDCOMPANY);
var result = user.apply();
}
}
}
}
catch (Exception ex)
{
retModel.AddError("errorMessage", ex.Message);
}
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
public EUser(int id)
{
_user = this.Find(id);
}
public UserService(USER item)
{
_item = item;
}
public long Insert(USER entity) //Thêm mới user
{
db.USERs.Add(entity);
db.SaveChanges();
return(entity.UserId);
}
public static MailMessage GenerateMailMessage(string typeDemande, TASK task = null, PanierViewModel panier = null)
{
var message = new MailMessage();
var user = new USER();
if (task != null)
{
message = new MailMessage("*****@*****.**", task.USER.EMAIL);
}
else
{
user = new USER_Service().FindUserByID(panier.UserId);
message = new MailMessage("*****@*****.**", user.EMAIL);
}
message.IsBodyHtml = true;
message.BodyEncoding = Encoding.UTF8;
switch (typeDemande)
{
case Enums.StringManager.CONVERSION_TERMINEE:
{
message.Subject = "Votre conversion n°" + task.PK_ID_TASK;
message.Body = "Bonjour " + task.USER.FIRSTNAME + " " + task.USER.LASTNAME + ", <br/> <br/>";
message.Body += "Votre conversion n° " + task.PK_ID_TASK + " a été effectuée. <br/>";
message.Body += "Vous pouvez télécharger votre média en vous rendant sur Transcoder dans la section 'Mes Conversions'<br/>";
message.Body += "Nous vous souhaitons une agréable journée. <br/>";
message.Body += "Cordialement, <br/>";
message.Body += "<p> L'équipe TRANSCODER France </p> <br/>";
break;
}
case Enums.StringManager.PAIEMENT_ACCEPTE:
{
message.Subject = "Votre commande n° " + panier.TransactionId;
message.Body = "<style>table tr td { border: solid 1px gray;} thead tr { background: #CCC; }</style>";
message.Body = "<p>Bonjour " + user.FIRSTNAME + " " + user.LASTNAME + ",</p> <br/>";
message.Body += "Votre paiement pour la commande n° " + panier.TransactionId + " a été accepté et est en cours de traitement par nos services. <br/><br/>";
message.Body += "Vous recevrez un mail lorsque votre commande sera terminée et prête a être téléchargée. <br/><br/>";
message.Body += "<h3> Récapitulatif de votre commande </h3><hr/>";
message.Body += "<table>";
message.Body += "<thead>";
message.Body += "<tr><td><strong>Nom du fichier</strong></td><td><strong>Format de base</strong></td><td><strong>Format de conversion</strong></td><td><strong>Statut</strong></td><td><strong>Prix</strong></td><tr></thead>";
foreach (var item in panier.ListOfConversions)
{
message.Body += "<tr>";
message.Body += "<td>" + item.FILE_URL_ACCESS + "</td>";
message.Body += "<td>" + item.FORMAT_BASE + "</td>";
message.Body += "<td>" + item.FORMAT_CONVERT + "</td>";
message.Body += "<td>" + item.STATUS + "</td>";
message.Body += "<td>" + item.PRICE + "</td>";
message.Body += "</tr>";
}
message.Body += "</table><hr/><h3 style='color: green'>Montant total de votre commande :<span style='float:right;' >" + panier.GlobalPrice + "€</span></h3>";
message.Body += "Nous vous souhaitons une agréable journée. <br/>";
message.Body += "Cordialement, <br/>";
message.Body += "<p> L'équipe TRANSCODER France </p> <br/>";
break;
}
default:
{
break;
}
}
return(message);
}
public ActionResult Edit(USER user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult GetUserInfo(int?id)
{
Stream req = Request.InputStream;
req.Seek(0, System.IO.SeekOrigin.Begin);
string json = new StreamReader(req).ReadToEnd();
//AppendLog("[REQ HKSports/LoginController]" + json);
DateTime today = DateTime.Now;
// 객체 초기화
Login login = null;
UserInfo userInfo = new UserInfo();
HKRheader rHeader = new HKRheader();
UserInfoBody uiBody = new UserInfoBody();
LOG newLog = new LOG(); // 로그 객체
// DB Context 가져오기
HKRiderDBDataContext db = new HKRiderDBDataContext(/*connectionString here */);
LOGDBDataContext logdb = new LOGDBDataContext(/**/);
try
{
login = JsonConvert.DeserializeObject <Login>(json);
// Log 처리 루틴 -------------------------------------------------
newLog.action = login.header.action;
newLog.auth_token = login.header.auth_token;
newLog.json = json;
newLog.dt_created = DateTime.Now;
// Log 처리 루틴 -------------------------------------------------
if (!login.header.action.Equals("GetUserInfo"))
{
userInfo.header = setHKRheader_Err(rHeader, 101, "[ERROR] Action is wrong: " + login.header.action,
login.header.auth_token, logdb, newLog);
return(Json(userInfo, JsonRequestBehavior.AllowGet));
}
// Version Check 추가 예정
if (login.header.client_market == null || login.body.email == null)
{
userInfo.header = setHKRheader_Err(rHeader, 102, "[ERROR] No client_market or No user_id",
login.header.auth_token, logdb, newLog);
return(Json(userInfo, JsonRequestBehavior.AllowGet));
}
USER thisUser = null;
string passwd = login.body.password;
string token = login.header.auth_token;
// User 가져오기
if (passwd != null && passwd.Length > 0)
{
thisUser = (from u in db.USERs
where u.EMail == login.body.email &&
u.Client_Market == login.header.client_market &&
u.Passwd == passwd
select u).SingleOrDefault();
}
else if (token != null && token.Length > 0)
{
thisUser = (from u in db.USERs
where u.EMail == login.body.email &&
u.Client_Market == login.header.client_market &&
u.Auth_Token == token
select u).SingleOrDefault();
}
if (thisUser == null)
{
// Error: 아이디, 패스워드를 다시 확인하세요.
userInfo.header = setHKRheader_Err(rHeader, 201, "[ERROR] 아이디, 패스워드를 다시 확인하세요: " +
login.body.email, login.header.auth_token, logdb, newLog);
return(Json(userInfo, JsonRequestBehavior.AllowGet));
}
// 토큰 발급: 로그인으로 들어온 경우는 대부분 Expired 된 경우이다.
if (token != null && token.Length > 0 && !token.Equals(thisUser.Auth_Token) ||
thisUser.Auth_Token == null || thisUser.Auth_Token == "")
{
token = Convert.ToBase64String(Guid.NewGuid().ToByteArray());
thisUser.Auth_Token = token;
}
if (!login.header.auth_device_id.Equals(thisUser.FCM_Token))
{
thisUser.FCM_Token = login.header.auth_device_id;
}
db.SubmitChanges();
logdb.LOGs.InsertOnSubmit(newLog);
logdb.SubmitChanges();
userInfo.header = rHeader;
userInfo.body = uiBody;
userInfo = getUserInformation(userInfo, thisUser);
//userInfo.header = rHeader;
//userInfo.body = uiBody;
return(Json(userInfo, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
// Error: Exception
userInfo.header = setHKRheader_Err(rHeader, 301, "[ERROR] Exception: " + ex.Message
, login == null ? "Login is null" : login.header.auth_token, logdb, newLog);
return(Json(userInfo, JsonRequestBehavior.AllowGet));
}
}
public static bool NotificationEmail(USER user, string fecha, string title, string message, string icon)
{
try
{
var mensaje = new MailMessage();
string imgsource = string.Empty;
mensaje.Subject = title;// "SafeOps - Ejecución automática";
switch (icon)
{
case "fa-upload":
imgsource = "<img width='100' src='https://safe-ops.net/Images/logo-t.png' />";
break;
case "fa-check-circle":
imgsource = "<img width='100' src='https://safe-ops.net/Images/email_ok.png' />";
break;
case "fa-exclamation-circle":
imgsource = "<img width='100' src='https://safe-ops.net/Images/email_error.png' />";
break;
case "fa-close":
imgsource = "<img width='100' src='https://safe-ops.net/Images/email_error.png' />";
break;
default:
imgsource = "<img width='100' src='https://safe-ops.net/Images/logo-t.png' />";
break;
}
//then we create the Html part
AlternateView htmlView = AlternateView.CreateAlternateViewFromString(
"<section style=\"width:100%;\">" +
"<p> " + imgsource + " </p> " +
"<div style=\"width:100%;\">" +
"<p><b>" + user.FIRST_NAME + " " + user.LAST_NAME + "</b>,</p>" +
"<p>" + message + "</p>" +
"</div>" +
"</section>"
, null, "text/html"
);
mensaje.AlternateViews.Add(htmlView);
mensaje.To.Add(user.EMAIL);
mensaje.IsBodyHtml = true;
var smtp = new SmtpClient();
ServicePointManager.ServerCertificateValidationCallback =
delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); };
smtp.Send(mensaje);
//SERVICE_LOG sl = new SERVICE_LOG();
//sl.ID_DAILY_ROL = iddailyrol;
//sl.ID_USER = iduser;
//sl.LOG_DATE = DateTime.Now;
//sl.DESCRIPTION = "Envío de correo de cambio de asignación a operador (" + usr.correo + ")";
//db.SERVICE_LOG.Add(sl);
//db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public ProfiliViewModel()
{
users = new USER();
psw = new ChangePasswordViewModel();
}
public ActionResult Login(FormCollection form, string ReturnUrl)
{
Hashtable json = new Hashtable();
try
{
string url = "/Home/Index";
if (!string.IsNullOrEmpty(ReturnUrl))
{
url = ReturnUrl;
}
string uname = form["userid"];
if (uname.Trim().Length <= 0)
{
ViewBag.Msg = "请输入登录账号";
return(View());
}
ViewBag.uname = uname;
string upwd = form["userpass"];
if (upwd.Trim().Length <= 0)
{
ViewBag.Msg = "请输入登录密码";
return(View());
}
string code = form["verifycode"];
if (code.Trim().Length <= 0)
{
ViewBag.Msg = "请输入验证码";
return(View());
}
if (!code.ToUpper().Equals(Session["CheckCode"]))
{
ViewBag.Msg = "验证码不正确";
return(View());
}
//string uname = "bj-admin";
//string upwd = "123456";
USER u = new USER();
json = UserService.instance().Login(uname, upwd);
if (Convert.ToBoolean(json["status"]))
{
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
json["uid"].ToString(), DateTime.Now, DateTime.Now.Add(FormsAuthentication.Timeout), false,
"");
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, FormsAuthentication.Encrypt(ticket));
Guid UID = new Guid(json["uid"].ToString());
//初始化ticket
USER m = UserService.instance().GetEntityByID(UID);
UserDateTicket.Uname = m.Name;
UserDateTicket.Company = CompanyService.instance().Single(m.CompanyID);
UserDateTicket.wx_config = WX_ConfigService.instance().SingleByCompanyID(m.CompanyID);
UserDateTicket.IsSuper = m.Type == 99 ? true : false;
var rlist = User_PK_Role_s_Service.instance().GetEnumByUID(UID).Select(x => x.Role_ID.ToString().ToUpper()).ToList();
UserDateTicket.IsWeShop = rlist.Contains("4AD50983-426E-4A74-95FA-D4A9FFB147E5");
UserDateTicket.MenuHTML = new MenuService(m.ID).Html;
//end初始化ticket
Response.Cookies.Add(cookie);
Response.Redirect(url);
}
else
{
ViewBag.Msg = json["error"];
return(View());
}
}
catch (Exception ex)
{
ViewBag.Msg = "未知错误！" + ex.ToString();
}
return(View());
}
private void deleteStaff(USER staff)
{
UserController.deleteStaff(staff);
loadDataStaff();
}
public bool CheckPermissionToManageUsers(USER user, int teamId)
{
UserTeamPermissionsViewModel userTeamPermissions = GetPermissionsForUserTeam(user, teamId);
return(userTeamPermissions.CanManageUsers);
}
partial void UpdateUSER(USER instance);
public bool CheckPermissionToAssignTasks(USER user, int teamId)
{
UserTeamPermissionsViewModel userTeamPermissions = GetPermissionsForUserTeam(user, teamId);
return(userTeamPermissions.CanAssignTasks);
}
private USER kullanicidogrula(string kisim, string ksifre)
{
aktif = managerUser.Find(x => x.NAME == kisim && x.PASSWORD == ksifre);
return(aktif);
}
public bool CheckIfUserIsTeamOwner(USER user, int teamId)
{
UserTeamPermissionsViewModel userTeamPermissions = GetPermissionsForUserTeam(user, teamId);
return(userTeamPermissions.IsTeamOwner);
}
public ActionResult Index(USER model)
{
if (ModelState.IsValid)
{
// check user is valid
if (Membership.ValidateUser(model.EMAIL, model.PASS))
{
FormsAuthentication.RedirectFromLoginPage(model.EMAIL, true);
}
// save user control error
ModelState.AddModelError("", "Kullanıcı Adı ve Şifre Yanlış");
// show error
ViewBag.error = true;
}
return View("~/Views/ADMIN/_login.cshtml", model);
}
public static void InsertGoogleStore(string storejson)
{
Store s = myConvert.Deserialize<Store>(storejson);
try
{
if (s == null)
{ return; }
Random r = new Random();
int i = r.Next(0, 6);
//string[] users = new string[6] { "gdabli", "harshisame", "nari.dontula", "rungta.sachin", "SiChen", "YongZhuang" };
string[] users = new string[6] { "Gaurav_Dabli", "Harshita_Gupta", "Harshita_Gupta", "Nari_Dontula", "Nari_Dontula", "Yong_Zhuang" };
if (mydb.STOREs.SingleOrDefault(ss => ss.PLACE_ID == s.place_id) != null)
{
return;
}
//{ "geometry": { "location": { "k": 42.360128, "B": -71.055454 } }, "name": "Cheers", "types": ["cafe", "bar", "restaurant", "food", "establishment"], "vicinity": "1 S Market St, Boston", "html_attributions": [] }
STORE store = new STORE() { NAME = s.name, PLACE_ID = s.place_id, PRICE_LEVEL = s.price_level, RATING = s.rating, PHONE = s.formatted_phone_number, WEBSITE = s.website, OWNER = users[i], GOOGLE_URL = s.url };
LOCATION location = new LOCATION() { LATITUDE = s.geometry.location.k, LONGITUDE = s.geometry.location.B };
mydb.LOCATIONs.InsertOnSubmit(location);
store.LOCATION = location;
ADDRESS address = new ADDRESS() { ADDRESS_LINE1 = s.vicinity.Split(',')[0], CITY = s.vicinity.Split(',')[1] };
if (s.address_components != null)
{
foreach (Address_Components ad in s.address_components)
{
foreach (string type in ad.types)
{
switch (type)
{
case "country":
{
address.COUNTRY = ad.long_name;
break;
}
case "postal_code":
{
address.POSTAL_CODE = ad.long_name;
break;
}
case "administrative_area_level_1":
{
address.STATE_PROVINCE_REGION = ad.long_name;
break;
}
}
}
}
}
mydb.ADDRESSes.InsertOnSubmit(address);
store.ADDRESS = address;
if (s.opening_hours != null)
{
foreach (Period period in s.opening_hours.periods)
{
PERIOD p = new PERIOD() { OPEN_DAY = period.open.day, CLOSE_DAY = period.close.day, OPEN_TIME = Convert.ToDateTime(period.open.hours + ":" + period.open.minutes).TimeOfDay, CLOSE_TIME = Convert.ToDateTime(period.close.hours + ":" + period.close.minutes).TimeOfDay };
store.PERIODs.Add(p);
}
}
if (s.reviews != null)
{
foreach (Review review in s.reviews)
{
if (string.IsNullOrEmpty(review.author_name) || review.author_name == "A Google User")
{
continue;
}
USER user = mydb.USERs.SingleOrDefault(u => u.FIRST_NAME + " " + u.LAST_NAME == review.author_name);
if (user == null)
{
string[] name = review.author_name.Split(' ');
if (name.Length > 1)
{
user = new USER() { FIRST_NAME = name[0], LAST_NAME = name[1], USER_ID = name[0] + "_" + name[1], EMAIL = name[0] + "." + name[1] + "@gmail.com", PASSWORD = "******", ROLE = "0", REGISTER_DATE = DateTime.Now };
}
else if (name.Length > 0)
{
user = new USER() { FIRST_NAME = name[0], LAST_NAME = "", USER_ID = name[0], EMAIL = name[0] + "@gmail.com", PASSWORD = "******", ROLE = "0", REGISTER_DATE = DateTime.Now };
}
mydb.USERs.InsertOnSubmit(user);
}
if (user != null)
{
FEEDBACK feed = new FEEDBACK() { COMMENT = review.text, RATING = review.rating };
feed.IS_LIKED = feed.RATING > 2.5 ? 1 : 0;
feed.USER = user;
feed.STORE = store;
mydb.FEEDBACKs.InsertOnSubmit(feed);
}
}
}
if (s.types != null)
{
foreach (string type in s.types)
{
CATEGORY catergory = mydb.CATEGORies.SingleOrDefault(c => c.NAME == type);
if (catergory == null)
{
catergory = new CATEGORY() { NAME = type, LAYER = 1, PARENT = 0 };
mydb.CATEGORies.InsertOnSubmit(catergory);
}
STORE_CATEGORY s_c = new STORE_CATEGORY();
s_c.CATEGORY = catergory;
s_c.STORE = store;
mydb.STORE_CATEGORies.InsertOnSubmit(s_c);
}
}
mydb.SubmitChanges();
}
catch (Exception e)
{
throw e;
}
}
public HttpResponseMessage signIn([FromBody] USER userData)
{
using (FutureMeProductEntities ctx = new FutureMeProductEntities())
{
var user = ctx.USERS.Where(x => x.Email == userData.Email && x.Password == userData.Password).FirstOrDefault();
if (user == null)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
var returnUser = new USER();
returnUser.Email = user.Email;
returnUser.ID = user.ID;
return Request.CreateResponse(HttpStatusCode.OK, returnUser);
}
}
public ActionResult Create([Bind(Include = "ID,USRNAME,FIRST_NAME,LAST_NAME,EML,ADMIN_IND,STDNT_IND,EMP_IND,HASHED_PSWRD,SALT,RST_PSWRD_CODE,RST_PSWRD_CODE_UNTL,CREATED_AT,UPDATED_AT,PARNT_IND")] USER uSER)
{
if (ModelState.IsValid)
{
db.USERS.Add(uSER);
db.SaveChanges();
if (uSER.ADMIN_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(1)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else if (uSER.EMP_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(2)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else if (uSER.STDNT_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(4)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else if (uSER.PARNT_IND.Equals("Y"))
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(3)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
else
{
foreach (var entity in db.USERS_ACCESS.Select(s => new { s.USRS_ID, s.LIST_ITEM, s.LVL_1_MENU, s.LVL_2_MENU, s.CTL, s.ACTN, s.IS_ACCBLE }).Distinct().Where(a => a.USRS_ID.Equals(3)).ToList())
{
var UserAccess = new USERS_ACCESS()
{
USRS_ID = uSER.ID, LIST_ITEM = entity.LIST_ITEM, LVL_1_MENU = entity.LVL_1_MENU, LVL_2_MENU = entity.LVL_2_MENU, CTL = entity.CTL, ACTN = entity.ACTN, IS_ACCBLE = entity.IS_ACCBLE
};
db.USERS_ACCESS.Add(UserAccess);
db.SaveChanges();
}
}
return(RedirectToAction("Edit_Privilege", "USERs", new { id = uSER.ID }));
}
return(View(uSER));
}
private void Save(string strLink = "")
{
try
{
string SALT = "";
string USER_PW = "";
if (!string.IsNullOrEmpty(Txtpass.Text))
{
if (Txtpass.Text != Txtrepass.Text)
{
Lberrors.Text = "2 mật khẩu không giống nhau";
}
else
{
SALT = Common.CreateSalt();
USER_PW = Common.Encrypt(Txtpass.Text, SALT);
}
}
if (_userid == 0)
{
USER user = new USER();
user.USER_NAME = Txtname.Text;
user.USER_UN = Txtusername.Text;
user.USER_MACC = txtMaCC.Text;
user.USER_GIOITINH = Utils.CIntDef(rdoGioiTinh.SelectedValue);
user.USER_NGAYSINH = txtNgaySinh.Text == "" ? user.USER_NGAYSINH = null :
DateTime.ParseExact(txtNgaySinh.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
user.USER_CMND = txtCMND.Text;
user.USER_CMND_NGAYCAP = txtNgayCapCMND.Text == "" ? user.USER_CMND_NGAYCAP = null :
DateTime.ParseExact(txtNgayCapCMND.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
user.USER_CMND_NOICAP = txtNoiCapCMND.Text;
user.USER_DANTOC = txtDanToc.Text;
user.USER_NGUYENQUAN = txtNguyenQuan.Text;
user.USER_NOIDK_HK = txtNoiDK_HK.Text;
user.USER_ADDRESS = Txtaddress.Text;
user.USER_EMAIL = Txtemail.Text;
user.USER_EMAIL_CANHAN = txtEmail_CaNhan.Text;
user.USER_PHONE = Txtphone.Text;
user.USER_PHONE_CANHAN = txtPhone_CaNhan.Text;
user.USER_TRINHDO = txtTrinhDo.Text;
user.NT_HOTEN = txtNT_HoTen.Text;
user.NT_SDT = txtNT_SDT.Text;
user.NT_MOIQUANHE = txtNT_MoiQuanHe.Text;
user.GROUP_ID = Utils.CIntDef(Drgroup.SelectedValue);
user.USER_CHINHANH = Utils.CIntDef(ddlChiNhanh.SelectedValue);
user.USER_DATE = DateTime.Now;
db.USERs.InsertOnSubmit(user);
db.SubmitChanges();
SendEmailNew(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(Drgroup.SelectedItem), rdoGioiTinh.SelectedValue == "1" ? "Nam" : "Nữ"
, txtNgaySinh.Text, txtCMND.Text, txtNgayCapCMND.Text, txtNoiCapCMND.Text, txtDanToc.Text, txtNguyenQuan.Text, txtNoiDK_HK.Text
, Txtaddress.Text, txtEmail_CaNhan.Text, Txtphone.Text, txtPhone_CaNhan.Text, txtTrinhDo.Text, txtNT_HoTen.Text, txtNT_SDT.Text, txtNT_MoiQuanHe.Text, getDiaDiem(ddlChiNhanh.SelectedValue));
var getlink = db.USERs.OrderByDescending(n => n.USER_ID).Take(1).ToList();
if (getlink.Count > 0)
{
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-nhan-vien.aspx?userid=" + getlink[0].USER_ID : strLink;
}
}
else
{
var list = db.USERs.Where(n => n.USER_ID == _userid).ToList();
if (ASPxPageControl2.ActiveTabIndex == 0)
{
foreach (var i in list)
{
i.USER_NAME = Txtname.Text;
i.USER_UN = Txtusername.Text;
i.USER_MACC = txtMaCC.Text;
i.USER_GIOITINH = Utils.CIntDef(rdoGioiTinh.SelectedValue);
i.USER_NGAYSINH = txtNgaySinh.Text == "" ? i.USER_NGAYSINH = null :
DateTime.ParseExact(txtNgaySinh.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
i.USER_CMND = txtCMND.Text;
i.USER_CMND_NGAYCAP = txtNgayCapCMND.Text == "" ? i.USER_CMND_NGAYCAP = null :
DateTime.ParseExact(txtNgayCapCMND.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
i.USER_CMND_NOICAP = txtNoiCapCMND.Text;
i.USER_DANTOC = txtDanToc.Text;
i.USER_NGUYENQUAN = txtNguyenQuan.Text;
i.USER_NOIDK_HK = txtNoiDK_HK.Text;
i.USER_ADDRESS = Txtaddress.Text;
i.USER_EMAIL = Txtemail.Text;
i.USER_EMAIL_CANHAN = txtEmail_CaNhan.Text;
i.USER_PHONE = Txtphone.Text;
i.USER_PHONE_CANHAN = txtPhone_CaNhan.Text;
i.USER_TRINHDO = txtTrinhDo.Text;
i.NT_HOTEN = txtNT_HoTen.Text;
i.NT_SDT = txtNT_SDT.Text;
i.NT_MOIQUANHE = txtNT_MoiQuanHe.Text;
i.GROUP_ID = Utils.CIntDef(Drgroup.SelectedValue);
i.USER_CHINHANH = Utils.CIntDef(ddlChiNhanh.SelectedValue);
}
SendEmailChange(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(Drgroup.SelectedItem), rdoGioiTinh.SelectedValue == "1" ? "Nam" : "Nữ"
, txtNgaySinh.Text, txtCMND.Text, txtNgayCapCMND.Text, txtNoiCapCMND.Text, txtDanToc.Text, txtNguyenQuan.Text, txtNoiDK_HK.Text
, Txtaddress.Text, txtEmail_CaNhan.Text, Txtphone.Text, txtPhone_CaNhan.Text, txtTrinhDo.Text, txtNT_HoTen.Text, txtNT_SDT.Text, txtNT_MoiQuanHe.Text, getDiaDiem(ddlChiNhanh.SelectedValue));
}
else if (ASPxPageControl2.ActiveTabIndex == 1)
{//Khi Tab Index = 1 thì cho đổi pass
foreach (var i in list)
{
if (i.USER_PW != null && i.USER_PW != "")
SendEmailChangePas(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(rblActive.SelectedItem), Txtpass.Text);
else
SendEmailCreatePas(Txtname.Text, Txtusername.Text, Txtemail.Text, Utils.CStrDef(rblActive.SelectedItem), Txtpass.Text);
if (!string.IsNullOrEmpty(USER_PW))
{
i.SALT = SALT;
i.USER_PW = USER_PW;
}
i.USER_ACTIVE = Utils.CIntDef(rblActive.SelectedValue);
}
}
else
{
foreach (var i in list)
{
i.USER_LUONG_CB = Utils.CDecDef(txtLuongCanBan.Text.Replace(",", ""));
if (rdoCoBH.SelectedValue == "1")
{
i.USER_COBH = Utils.CIntDef(rdoCoBH.SelectedValue);
i.USER_LUONG_BH = Utils.CDecDef(txtLuongBHCD.Text.Replace(",", ""));
i.USER_BHXH_PT = Utils.CDblDef(txtPT_BHXH.Text.Replace(",", "."), 0);
i.USER_BHYT_PT = Utils.CDblDef(txtPT_BHYT.Text.Replace(",", "."), 0);
i.USER_BHTN_PT = Utils.CDblDef(txtPT_BHTN.Text.Replace(",", "."), 0);
i.USER_BHXH = Utils.CDecDef(txtCTBHXH.Text.Replace(",", ""));
i.USER_BHYT = Utils.CDecDef(txtCTBHYT.Text.Replace(",", ""));
i.USER_BHTN = Utils.CDecDef(txtCTBHTN.Text.Replace(",", ""));
}
}
}
db.SubmitChanges();
strLink = string.IsNullOrEmpty(strLink) ? "chi-tiet-nhan-vien.aspx?userid=" + _userid : strLink;
}
}
catch (Exception)
{
throw;
}
finally
{
if (!string.IsNullOrEmpty(strLink))
{
Response.Redirect(strLink);
}
}
}
public ActionResult Register(int id = 0)
{
USER userx = new USER();
return(View(userx));
}
public virtual int Delete(USER user)
{
try
{
//user.IsDelete = true;
db.SubmitChanges();
return 0;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult Register()
{
USER userModel = new USER();
return(View(userModel));
}
/// <summary>
/// 保存加签
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult SaveWorkflowActivitySign(CompleteActivityModel model)
{
var retModel = new JsonReturnModel();
try
{
List <string> authIds = new List <string>();
List <string> oldAuthIds = new List <string>();
List <string> addAuthIds = new List <string>();
List <string> listEmail = new List <string>();
//验证输入的加签用户是否存在！并且获取IdentityId;
List <string> listName = model.PersonList.Split(';').Where(x => x != "" && x != null).Select(x => x.Trim()).Distinct().ToList();
if (listName != null && listName.Count() > 0)
{
for (int i = 0; i < listName.Count; i++)
{
string textValue = listName[i];
USER user = UserDA.GetUserByFirstName(textValue);
if (user == null)
{
retModel.AddError("errorMessage", "输入的人员在系统中不存在！");
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
else
{
listEmail.Add(user.EMAIL);
Item identity = IdentityDA.GetIdentityByKeyedName(inn, textValue);
if (!identity.isError() && identity.getItemCount() > 0)
{
string identityId = identity.getProperty("id");
authIds.Add(identityId);
}
}
}
}
//获取当前活动的名称
Item activity = ActivityDA.GetActivityById(inn, model.activityId);
string keyedName = activity.getProperty("keyed_name").Trim();
List <string> activityNames = new List <string> {
keyedName
};
//获取现有的审核权限
Item activityAssignments = ActivityAssignmentDA.GetActivityAssignment(inn, model.activityId);
if (!activityAssignments.isError() && activityAssignments.getItemCount() > 0)
{
for (int i = 0; i < activityAssignments.getItemCount(); i++)
{
Item activityAssignmentItem = activityAssignments.getItemByIndex(i);
string id = activityAssignmentItem.getProperty("id");
string related_id = activityAssignmentItem.getProperty("related_id");
oldAuthIds.Add(related_id);
//删除现有审核权限
ActivityAssignmentDA.deleteActivityAssignment(inn, id);
}
}
//添加该活动的审核权限
addAuthIds.AddRange(authIds);
addAuthIds.AddRange(oldAuthIds);
addAuthIds = addAuthIds.Distinct().ToList();
if (addAuthIds.Count > 0)
{
int voting_weight = Common.CalculationWeight(addAuthIds.Count);
foreach (var id in addAuthIds)
{
ActivityBll.AddActivityAuth(inn, model.itemId, id, activityNames, model.operateTable, voting_weight, "Active");
}
}
//加签成功发送邮件
string nameStr = "";
listEmail = listEmail.Distinct().ToList();
if (listName != null && listName.Count > 0)
{
for (int i = 0; i < listName.Count; i++)
{
if (i != listName.Count - 1)
{
nameStr += listName[i] + "、";
}
else
{
nameStr += listName[i];
}
}
}
WorkFlowBll.WorkflowActivitySignSendEmail(Userinfo.UserName, nameStr, model.recordNo, model.linkStr, listEmail);
}
catch (Exception ex)
{
retModel.AddError("errorMessage", ex.Message);
}
return(Json(retModel, JsonRequestBehavior.AllowGet));
}
public static bool Login(string username, string password, int UserID = 0)
{
if ((((string.IsNullOrEmpty(username)) || (string.IsNullOrEmpty(password))) && UserID <= 0))
{
return(false);
}
System.Web.Security.FormsAuthentication.Initialize();
Models.Entity.DataBase db = new Models.Entity.DataBase();
var lstUserRoles = (from U in db.users join UR in db.Users_Roles
on U.ID equals UR.Users.ID
join R in db.Roles on UR.Roles.ID equals R.ID
where U.USERNAME == username
select new { U.USERNAME, R.TITLE }).ToList();
// var userContext=null;
USER dbuser = db.users.SingleOrDefault(q => q.USERNAME == username);
// dbuser = userContext.Login(username.ToLower(), password);
if (dbuser == null)
{
return(false);
}
if (dbuser.ROLE_ID <= 0)
{
return(false);
}
//decimal roleid = dbuser.ROLE_ID;
//string name = dbuser.NAME;
List <string> rolename = new List <string>();
foreach (var item in lstUserRoles)
{
rolename.Add(item.TITLE);
}
var ticket = new System.Web.Security.FormsAuthenticationTicket(
1,
username,
DateTime.Now,
DateTime.Now.AddMinutes(60),
true,
Serialize(dbuser.ID, dbuser.USERNAME, rolename.ToArray(), dbuser.NAME, (int)dbuser.IS_ACTIVE),
System.Web.Security.FormsAuthentication.FormsCookiePath);
string hash = System.Web.Security.FormsAuthentication.Encrypt(ticket);
var cookie = new System.Web.HttpCookie(System.Web.Security.FormsAuthentication.FormsCookieName, hash);
if (ticket.IsPersistent)
{
cookie.Expires = ticket.Expiration;
}
var context = System.Web.HttpContext.Current;
context.Response.Cookies.Add(cookie);
context.User = new UserIdentity(dbuser.ID, dbuser.USERNAME, rolename.ToArray(), dbuser.NAME, true, dbuser.IS_ACTIVE);
//--------------------------new
// System.Web.HttpContext.Current.User = new System.Security.Principal.GenericPrincipal(context.User.Identity, roles);
return(true);
}
public bool AddNewUserToDatabase(USER user)
{
System.Diagnostics.Contracts.Contract.Requires(user != null);
return System.Diagnostics.Contracts.Contract.Result<bool>();
}
public static User RegisterUser( User FbUser )
{
using (elmatEntities entities = new elmatEntities())
{
USER U = new USER();
U.FacebookID = FbUser.FacebookID;
U.Name = FbUser.Name;
entities.USER.Add(U);
entities.SaveChanges();
FbUser.UserID = U.UserID;
return FbUser;
}
}
