public CourseReport(MUser user, List <MCourse> source)
{
_user = user;
_source = source;
SignedInUser.User = _user;
InitializeComponent();
}
public void Delete(MUser user)
{
if (Session != null)
{
Session.Update("User_Delete", user);
}
}
public CoursesPage(MUser user)
{
InitializeComponent();
_user = user;
SignedInUser.User = user;
BindingContext = modelSearchCourse = new CourseSearchVM();
}
/// <inheritdoc />
public override MPlayer GenerateMPlayer(MUser mUser)
{
MPlayer mPlayer = new MPlayer(mUser);
base.MPlayers.Add(mPlayer.Id, mPlayer);
return(mPlayer);
}
/// <summary>
/// 查询是否存在指定的用户记录
/// </summary>
/// <param name="ifpaxUsers"></param>
/// <returns></returns>
public override bool Exists(IModel ifpaxUsers)
{
MUser fpaxUsers = (MUser)ifpaxUsers;
strSql = "select * from " + TableName + " where DB_USER='******' and USER_PWD='" + fpaxUsers.USER_PWD + "'";
return(recordIsExist(strSql));
}
public MDBUser(MUser user)
{
UserId = user.UserId;
UserName = user.UserName;
Email = user.Email;
Timelines = new List <MDBTimelineInfo>();
}
private async Task SubmitAsync()
{
IsLoading = true;
await IsLoadingChanged.InvokeAsync(IsLoading);
var user = MUser.FromUser(User);
user.Biography = await editor.GetHTML();
if (user.Biography == "<p><br></p>")
{
user.Biography = null;
}
if (avatarPreview != null)
{
var response = await HttpClient.PostAsJsonAsync("api/images", avatarPreview);
user.AvatarImageId = int.Parse(await response.Content.ReadAsStringAsync());
}
await HttpClient.PutAsJsonAsync("api/users/profile", user);
NavigationManager.NavigateTo(NavigationManager.Uri, true);
IsLoading = false;
}
/// <summary>
/// ------------------------------
/// Date Modified: 03/04/2012
/// Modified By: Josephine Gad
/// (description) Set mUser.LastActivityDate to -Membership.UserIsOnlineTimeWindow
/// -------------------------------------------
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LoginStatus1_LoggingOut(object sender, LoginCancelEventArgs e)
{
MembershipUser mUser = Membership.GetUser(GlobalCode.Field2String(MUser.GetUserName()));
if (mUser != null)
{
mUser.LastActivityDate = DateTime.Now.AddMinutes(-Membership.UserIsOnlineTimeWindow);
Membership.UpdateUser(mUser);
}
FormsAuthentication.SignOut();
try
{
//Response.Redirect("Login.aspx");
Response.Redirect(MUser.GetLDAPLogin());
}
catch (Exception ex)
{
try
{
Response.Redirect("../Login.aspx", false);
}
catch
{
Response.Redirect("Login.aspx", false);
}
}
}
/// <summary>
/// Date Modified: 19/03/2012
/// Modified By: Josephine Gad
/// (description) Use Session instead of Query String for date
/// Get uoHiddenFieldPopupCalendar value of master page to refresh list
/// -------------------------------------
/// Date Modified: 29/03/2012
/// Modified By: Josephine Gad
/// (description) Get default value of date from QueryString if new load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
//InitializeValues();
string userRole = InitializeValues();
SetDefaultValues();
string userName = MUser.GetUserName();
if (!IsPostBack)
{
uoHiddenFieldDate.Value = Request.QueryString["dt"];
Session["DateFrom"] = uoHiddenFieldDate.Value;
}
else
{
if (Session["DateFrom"] != null && GlobalCode.Field2String(Session["DateFrom"]) != "")
{
uoHiddenFieldDate.Value = GlobalCode.Field2String(Session["DateFrom"]);
}
else
{
uoHiddenFieldDate.Value = Request.QueryString["dt"];
}
}
if (!IsPostBack)
{
//Session["strPrevPage"] = Request.RawUrl;
//string UserRolePrimary = UserAccountBLL.GetUserPrimaryRole(userName);
//string userRole = UserRolePrimary;
//uoHiddenFieldUserRole.Value = userRole;//MUser.GetUserRole();
//uoHiddenFieldUser.Value = userName;//MUser.GetUserName();
//SetDefaultValues();
GetVessel();
GetNationality();
GetGender();
GetRank();
BindRegionList();
BindPortList();
if (userRole == TravelMartVariable.RoleHotelVendor || userRole == TravelMartVariable.RoleVehicleVendor)
{
uoTRVessel.Visible = false;
}
else
{
uoTRVessel.Visible = true;
}
}
HiddenField uoHiddenFieldPopupCalendar = (HiddenField)Master.FindControl("uoHiddenFieldPopupCalendar");
if (uoHiddenFieldPopupCalendar.Value == "1")
{
BindRegionList();
GetTravelRequestList();
}
ListView1.DataSource = null;
ListView1.DataBind();
}
public static int SaveUserImage(Ctx ctx, byte[] buffer, string imageName, bool isSaveInDB, int userID)
{
MUser user = new MUser(ctx, userID, null);
int imageID = Util.GetValueOfInt(user.GetAD_Image_ID());
MImage mimg = new MImage(ctx, imageID, null);
mimg.ByteArray = buffer;
mimg.ImageFormat = imageName.Substring(imageName.LastIndexOf('.'));
mimg.SetName(imageName);
if (isSaveInDB)
{
mimg.SetBinaryData(buffer);
mimg.SetImageURL(string.Empty);
}
else
{
//mimg.SetImageURL(HostingEnvironment.MapPath(@"~/Images/100by100"));//Image Saved in File System so instead of byteArray image Url will be set
mimg.SetImageURL("Images/Thumb100x100");//Image Saved in File System so instead of byteArray image Url will be set
mimg.SetBinaryData(new byte[0]);
}
if (!mimg.Save())
{
return(0);
}
user.SetAD_Image_ID(mimg.GetAD_Image_ID());
if (!user.Save())
{
return(0);
}
return(mimg.GetAD_Image_ID());
}
public MUser Authenticiraj(string username, string pass)
{
var user = _ctx.Users.Include("UsersRoles.Role").FirstOrDefault(x => x.Username == username);
if (user != null)
{
var hashedPass = HashHelper.GenerateHash(user.PasswordSalt, pass);
if (hashedPass == user.PasswordHash)
{
var muser = new MUser
{
Id = user.Id,
Email = user.Email,
Username = user.Username,
Roles = user.UsersRoles.Select(x => new MRole {
Id = x.RoleId, Name = x.Role.Name
}).ToList()
};
return(muser);
}
}
return(null);
}
public static List <MUser> GetALlUsers()
{
List <MUser> lstUser = new List <MUser>();
try
{
string sql = "SELECT * FROM M_USERS";
var result = SQLiteCommon.ExecuteSqlWithResult(sql);
if (result != null && result.HasRows)
{
while (result.Read())
{
MUser user = new MUser();
user.UserId = result["USERID"]?.ToString();
user.FullName = result["FULLNAME"]?.ToString();
user.CreateBy = result["CREATEBY"]?.ToString();
user.Email = result["EMAIL"]?.ToString();
user.Mobile = result["MOBILE"]?.ToString();
user.Password = result["PASSWORD"]?.ToString();
user.Role = short.Parse(result["ROLE"]?.ToString());
user.RoleDisplay = user.Role == 0 ? "ADMIN" : "USERS";
user.CreateDate = Convert.ToDateTime(result["CREATEDATE"]?.ToString());
lstUser.Add(user);
}
}
return(lstUser);
}
catch (Exception ex)
{
throw ex;
}
}
public MUser GetUser(MUser MUser)
{
MUser user = new MUser();
UserRequest request = new UserRequest();
UserResponse response = new UserResponse();
request.User = MUser;
request.ApplicationToken = ConfigurationManager.AppSettings["ApplicationToken"].ToString();
string bodyrequest = JsonConvert.SerializeObject(request);
string statuscode = string.Empty;
string bodyresponse = new Helper().InvokeApi("security/api/User", "GetUser", bodyrequest, ref statuscode);
if (statuscode.Equals("OK"))
{
response = JsonConvert.DeserializeObject <UserResponse>(bodyresponse);
if (response.Code.Equals("0"))
{
user = response.User;
}
}
return(user);
}
public override object Run(MBuilderModel model, string path, string parms)
{
MUser currentUser = CurrentUser(model);
// Чтение списка пользователей
MPaginationList l = new MPaginationList(parms);
List <MArt> la = new List <MArt>();
string clsIdList = ClsAdapter.GetParenIdList(GetParm("clsid", ""), "USR");
string f = "";
if (string.IsNullOrEmpty(clsIdList) || GetParm("isAll", false))
{
f = "--";
}
model.Select(l, typeof(MEntity),
$@"select * from [MEntity] (nolock) where EntityTypeId='USR'
and code like {model.AddParam("%"+GetParm("code", "")+"%")}
and name like {model.AddParam("%" + GetParm("name", "") + "%")}
{f} and clsId in ({clsIdList})"
);
if (l.Count > 0)
{
model.Select(la, typeof(MArt), $"select * from [MArt] (nolock) where EntityId in ({l.IdList()})");
foreach (MArt art in la)
{
art.Entity.Arts.Add(art);
}
}
return(l);
}
public void DeleteUser(MUser user)
{
MembershipUser User = Membership.GetUser(user.UserName);
if (User != null)
{
SqlConnection connection =
new SqlConnection(ConfigurationManager.ConnectionStrings["rolesConnectionString"].ConnectionString);
try
{
connection.Open();
object UserGUID = User.ProviderUserKey;
Membership.DeleteUser(User.UserName);
SqlCommand cmd =
new SqlCommand("delete from UsersInformation where UserId='" + User.ProviderUserKey + "'",
connection);
int res = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
logger.Error(string.Format("DeleteUser|ERROR:{0}", ex.Message));
}
finally
{
connection.Close();
}
}
}
public JsonResult AddNewUser(VMNewUser user)
{
MUser u = new MUser()
{
Username = user.Username,
FirstName = user.FirstName,
LastName = user.LastName,
EMail = user.EMail
};
foreach (MAddress a in user.Addresses)
{
db.Address.Add(a);
u.Addresses.Add(a);
}
foreach (VMApplicationWizard app in user.Applications)
{
var id = app.ApplicationId;
var foundModel = db.Applications.Find(id);
u.Applications.Add(foundModel);
}
db.Users.Add(u);
db.SaveChanges();
return(Json("success"));
}
/// <summary>
/// Author: Josephine Gad
/// Date Created: 02/Jan/2013
/// Description: Set default values
/// ------------------------------------
/// </summary>
protected void InitializeValues()
{
string sUserName = "";
if (GlobalCode.Field2String(Session["UserName"]) == "")
{
sUserName = MUser.GetUserName();
Session["UserName"] = sUserName;
}
MembershipUser muser = Membership.GetUser(GlobalCode.Field2String(Session["UserName"]));
if (muser == null)
{
Response.Redirect("~/Login.aspx", false);
}
else
{
if (muser.IsOnline == false)
{
Response.Redirect("~/Login.aspx", false);
}
}
if (GlobalCode.Field2String(Session["DateFrom"]) == "")
{
Session["DateFrom"] = GlobalCode.Field2DateTime(Request.QueryString["dt"]).ToShortDateString();
}
uoHiddenFieldDate.Value = GlobalCode.Field2String(Session["DateFrom"]);
Session["strPrevPage"] = Request.RawUrl;
ListView1.DataSource = null;
ListView1.DataBind();
}
public ActionResult <Models.JsonResult> ChangePwd([FromBody] MUser User, string oldpwd, string newpwd)
{
try
{
if (User == null || User.id <= 0)
{
return(BadRequest("Error while creating"));
}
else if (oldpwd == null || oldpwd.Length < 8)
{
return(BadRequest("Error while creating"));
}
else if (newpwd == null || newpwd.Length < 8)
{
return(BadRequest("Error while creating"));
}
else
{
Repository.RepSqlDatabase.LogConnection(_hostEnvironment, "User.ChangePassword", Newtonsoft.Json.JsonConvert.SerializeObject(User) + ", PwdOld : " + oldpwd + ", PwdNew : " + newpwd);
_interface = HttpContext.RequestServices.GetService(typeof(UserContext)) as UserContext;
return(_interface.GetChangePwd(User, oldpwd, newpwd));
}
}
catch (Exception ex)
{
Repository.RepSqlDatabase.LogErrorQuery(_hostEnvironment, "User.Login", ex);
return(BadRequest("Error while creating"));
}
}
public ActionResult Create(MUser mUser)
{
if (ModelState.IsValid)
{
String avatar = XString.ToAscii(mUser.Fullname);
mUser.Password = XString.ToMD5(mUser.Password);
mUser.Created_at = DateTime.Now;
mUser.Created_by = int.Parse(Session["Admin_ID"].ToString());
mUser.Updated_at = DateTime.Now;
mUser.Updated_by = int.Parse(Session["Admin_ID"].ToString());
var file = Request.Files["Image"];
if (file != null && file.ContentLength > 0)
{
String filename = avatar + file.FileName.Substring(file.FileName.LastIndexOf("."));
mUser.Image = filename;
String Strpath = Path.Combine(Server.MapPath("~/Content/Path/user/"), filename);
file.SaveAs(Strpath);
}
db.User.Add(mUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mUser));
}
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
if (!ValidateForm())
{
return;
}
if (userNameTextBox.Enabled == true)
{
user = new MUser();
}
else
{
user = (MUser)DataMaster.GetObjectById(typeof(MUser), userNameTextBox.Text);
}
user.UserName = userNameTextBox.Text;
user.UserPassword = userPasswordTextBox.Text;
user.UserStatus = userStatusCheckBox.Checked;
if (userNameTextBox.Enabled == true)
{
DataMaster.SavePersistence(user);
}
else
{
DataMaster.UpdatePersistence(user);
}
DeleteTMenuUser();
SaveTMenuUser();
BindData();
}
public IList <MUser> GetAllUser()
{
using (var session = MySQLClientHelper.OpenSession())
{
using (var cmd = session.CreateCommand())
{
var list = new List <MUser>();
cmd.Connection = session;
cmd.CommandText = "select * from users";
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("id: " + reader.GetInt32("id") + " userName : "******"userName"));
var user = new MUser();
user.Id = reader.GetInt32("id");
user.UserName = reader.GetString("userName");
user.PassWord = reader.GetString("passWord");
user.Age = reader.GetInt32("age");
list.Add(user);
}
session.Close();
return(list);
}
}
}
/// <summary>
/// Date Modified: 19/03/2012
/// Modified By: Josephine Gad
/// (description) Use Session instead of Query String for date
/// Get uoHiddenFieldPopupCalendar value of master page to refresh list
/// -------------------------------------
/// Date Modified: 29/03/2012
/// Modified By: Josephine Gad
/// (description) Get default value of date from QueryString if new load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
string userRole = InitializeValues();
SetDefaultValues();
string userName = MUser.GetUserName();
if (!IsPostBack)
{
uoHiddenFieldDate.Value = Request.QueryString["dt"];
Session["DateFrom"] = uoHiddenFieldDate.Value;
BindRegionList();
BindPortList();
}
else
{
if (Session["DateFrom"] != null && GlobalCode.Field2String(Session["DateFrom"]) != "")
{
uoHiddenFieldDate.Value = GlobalCode.Field2String(Session["DateFrom"]);
}
else
{
uoHiddenFieldDate.Value = Request.QueryString["dt"];
}
}
if (!IsPostBack )
{
//if (Request.QueryString["dt"] != null)
//{
// if (Request.QueryString["dt"].ToString() != "")
// {
// uoHiddenFieldDate.Value = Request.QueryString["dt"].ToString();
// uoHiddenFieldDate.Value = uoHiddenFieldDate.Value.Replace("_", "/");
// }
//}
GetVessel();
GetNationality();
GetGender();
GetRank();
if (userRole == TravelMartVariable.RoleHotelVendor || userRole == TravelMartVariable.RoleVehicleVendor)
{
uoTRVessel.Visible = false;
}
else
{
uoTRVessel.Visible = true;
}
//GetNoTravelRequestList();
//HtmlControl uoRowDateTo = (HtmlControl)Master.FindControl("uoRowDateTo");
//uoRowDateTo.Visible = false;
}
HiddenField uoHiddenFieldPopupCalendar = (HiddenField)Master.FindControl("uoHiddenFieldPopupCalendar");
if (uoHiddenFieldPopupCalendar.Value == "1")
{
GetNoTravelRequestList();
}
ListView1.DataSource = null;
ListView1.DataBind();
}
public ActionResult ChangePassword(MUser user)
{
if (!ModelState.IsValid)
{
return(View(user));
}
else
{
if (user.Password != user.ConfirmPassword)
{
ModelState.AddModelError("", "Xác thực mật khẩu không đúng!");
return(View());
}
else
{
var result = db.Users.Find(user.ID);
string password = "******" + user.Password + "#^%";
string temp = MD5Hash(password);
if (result != null)
{
result.Password = temp;
db.SaveChanges();
ViewBag.Messege = "success";
ModelState.AddModelError("", "Đổi mật khẩu thành công!");
return(View());
}
else
{
ModelState.AddModelError("", "Đổi mật khẩu thất bại!");
return(View());
}
}
}
}
protected string InitializeValues()
{
string sUserName = GlobalCode.Field2String(Session["UserName"]);
if (GlobalCode.Field2String(Session["UserName"]) == "")
{
sUserName = MUser.GetUserName();
Session["UserName"] = sUserName;
}
MembershipUser muser = Membership.GetUser(GlobalCode.Field2String(Session["UserName"]));
if (muser == null)
{
Response.Redirect("~/Login.aspx", false);
}
else
{
if (muser.IsOnline == false)
{
Response.Redirect("~/Login.aspx", false);
}
}
Session["strPrevPage"] = Request.RawUrl;
if (GlobalCode.Field2String(Session["UserRole"])=="")
{
Session["UserRole"] = UserAccountBLL.GetUserPrimaryRole(sUserName);
}
uoHiddenFieldUserRole.Value = GlobalCode.Field2String(Session["UserRole"]);//MUser.GetUserRole();
uoHiddenFieldUser.Value = sUserName;//MUser.GetUserName();
return uoHiddenFieldUserRole.Value;
}
public string InsertUserApproved(MUser MUser)
{
UserRequest request = new UserRequest();
UserResponse response = new UserResponse();
string returnMsg = string.Empty;
request.User = MUser;
request.ApplicationToken = ConfigurationManager.AppSettings["ApplicationToken"].ToString();
string bodyrequest = JsonConvert.SerializeObject(request);
string statuscode = string.Empty;
string bodyresponse = new Helper().InvokeApi("security/api/User", "InsertUserApproved", bodyrequest, ref statuscode);
if (statuscode.Equals("OK"))
{
response = JsonConvert.DeserializeObject <UserResponse>(bodyresponse);
returnMsg = response.Code + "|" + response.Message;
}
else
{
returnMsg = "2" + "|" + "Error invoking User api";
}
return(returnMsg);
}
private string ValidateUserData(MUser objMuser, string password, string _lstRole, ref List <MRole> lstRole)
{
List <string> errMessage = new List <string>();
if (string.IsNullOrEmpty(objMuser.FullName))
{
errMessage.Add("Name can't be empty");
}
if (string.IsNullOrEmpty(objMuser.Username))
{
errMessage.Add("Username can't be empty");
}
if (string.IsNullOrEmpty(objMuser.Email))
{
errMessage.Add("Email can't be empty");
}
if (string.IsNullOrEmpty(password))
{
errMessage.Add("Password can't be empty");
}
try
{
lstRole = JsonConvert.DeserializeObject <List <MRole> >(_lstRole);
}
catch {
//TODO LOG
errMessage.Add("List Role can't be empty");
}
return(string.Join(" \n ", errMessage));
}
public override object Run(MBuilderModel model, string path, string parms)
{
MUser currentUser = CurrentUser(model);
string clsType = GetParm("clsType", "");
int parentId = GetParm("parentId", 0);
if (GetParm("clstypelist", false))
{
List <MClsType> lt = model.MainDic.GetAll <MClsType>((object o) => (clsType == "" || clsType == ((MClsType)o).Id));
return(lt);
}
MTreeList l = new MTreeList(parentId);
model.Select(l, typeof(MCls), $"select * from [MCls] (nolock) where ClsTypeId={model.AddParam(clsType)} and ParentId={model.AddParam(parentId)}");
List <MCls> k = new List <MCls>();
if (clsType != "")
{
model.Select(k, typeof(MCls), $"select * from [MCls] where id in ({l.IdList()}) and id in (select ParentId from MCls)");
foreach (MCls cls in l)
{
cls.webix_kids = true;
}
}
return(l);
}
public IActionResult SignUp(string fullname, string email, string username, string password, string password2, string listRole)
{
List <MRole> lstRole = new List <MRole>();
string errMsg;
MUser objMuser = new MUser()
{
FullName = fullname,
Email = email,
Username = username,
Password = password,
IsActive = true,
IsLocked = false
};
errMsg = ValidateUserData(objMuser, password, listRole, ref lstRole);
if (errMsg == "")
{
MUserVM obju = new MUserVM();
obju.ListRole = new List <TuserRole>();
foreach (var role in lstRole)
{
obju.ListRole.Add(new TuserRole()
{
Username = username,
RoleID = role.RoleID
});
}
obju.objUser = objMuser;
errMsg = acc.Register(obju, password2);
return(Z_Result.SetResult(errMsg));
}
return(Z_Result.SetResult(errMsg));
}
/// <summary>
/// Author:Charlene Remotigue
/// Date Created: 29/03/2012
/// Description: Initialize session values
/// </summary>
/// <returns></returns>
protected void InitializeValues()
{
if (Session["UserName"] == null)
{
Response.Redirect("~/Login.aspx", false);
}
string sUserName = "";
if (GlobalCode.Field2String(Session["UserName"]) == "")
{
sUserName = MUser.GetUserName();
Session["UserName"] = sUserName;
}
MembershipUser muser = Membership.GetUser(GlobalCode.Field2String(Session["UserName"]));
if (muser == null)
{
Response.Redirect("~/Login.aspx", false);
}
else
{
if (muser.IsOnline == false)
{
Response.Redirect("~/Login.aspx", false);
}
}
Session["strPrevPage"] = Request.RawUrl;
Session["HotelPath"] = Path.GetFileName(Request.Path);
}
public void Post([FromBody] MUser value)
{
UserActions ua = new UserActions();
value.Role_FK = 3;
ua.AddUser(value);
}
private void mUserToolStripMenuItem_Click(object sender, EventArgs e)
{
MedicalChest data = new MedicalChest(databaseUser.Connection);
MUser user = new MUser();
var qur = from u in data.MUser
select u;
DataTable datat = new DataTable();
qur.ToList<MUser>();
}
public DoctorsPrescription Build(DoctorsPrescription dp, MUser user, Doctor doctor)
{
if(dp!=null)
{
dp.UserName = user.Name;
dp.UserSurname = user.Surname;
dp.DoctorName = doctor.Name;
dp.DoctorSurname = doctor.Surname;
}
return dp;
}
public ActionResult Create(MUser model)
{
//check existed
var q = this.userService.Find(c => c.UserName == model.UserName);
if (q != null)
{
ModelState.AddModelError("UserName", "User name existed");
}
if (ModelState.IsValid)
{
//default password 123456
model.UserPwd = CEncrypt.DesEncrypt("123456");
model.CreateUser = this.LoginUser.UserName;
model.CreateDate = DateTime.Now;
model.Email = string.Empty;
this.userService.Add(model);
return RedirectToAction("List");
}
return View();
}
public void DeleteUser(MUser user)
{
MembershipUser User = Membership.GetUser(user.UserName);
if (User != null)
{
SqlConnection connection =
new SqlConnection(ConfigurationManager.ConnectionStrings["rolesConnectionString"].ConnectionString);
try
{
connection.Open();
object UserGUID = User.ProviderUserKey;
Membership.DeleteUser(User.UserName);
SqlCommand cmd =
new SqlCommand("delete from UsersInformation where UserId='" + User.ProviderUserKey + "'",
connection);
int res = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
logger.Error(string.Format("DeleteUser|ERROR:{0}", ex.Message));
}
finally
{
connection.Close();
}
}
}
public bool Add(MUser model)
{
return this.userDal.Add(model);
}
public void UpdateUser(MUser user)
{
MembershipUser User = Membership.GetUser(user.UserName);
if (User != null)
{
User.Email = user.Email;
Membership.UpdateUser(User);
// update roles
if (!Roles.IsUserInRole(User.UserName, "portal"))
Roles.AddUserToRole(User.UserName, "portal");
// update extra info
object UserGUID = User.ProviderUserKey;
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["rolesConnectionString"].ConnectionString);
connection.Open();
try
{
string salutation = user.Salutation;
string firstname = user.FirstName;
string lastname = user.LastName;
string usercod = user.UserCod;
SqlCommand cmd =
new SqlCommand(
"update UsersInformation set Salutation='" + salutation + "',FirstName='" + firstname +
"',LastName='" + lastname + "',UserCod='" + usercod + "' where UserId='" + User.ProviderUserKey +
"'", connection);
int res = cmd.ExecuteNonQuery();
if (res <= 0)
{
cmd =
new SqlCommand(
"insert into UsersInformation (UserId, Salutation, FirstName,LastName,UserCod) VALUES('"
+ User.ProviderUserKey + "','" + salutation + "','" + firstname + "','" + lastname + "','" +
usercod + "')", connection);
res = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
logger.Error(string.Format("UpdateUser|ERROR:{0}", ex.Message));
}
finally
{
connection.Close();
}
}
}
public List<MUser> GetAllUsers()
{
int totalUsers = 0;
MembershipUserCollection allUsers = Membership.Providers["PortalProvider"].GetAllUsers(0, 1000, out totalUsers);
List<MUser> users = new List<MUser>();
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);
foreach (MembershipUser User in allUsers)
{
MUser user = new MUser();
user.Email = User.Email;
user.UserName = User.UserName;
user.LastLogin = User.LastLoginDate.ToString("G");
user.IsApproved = User.IsApproved.ToString();
// string[] roles = Roles.GetRolesForUser(User.UserName);
//user.Role = roles[0];
// user.Password = User.GetPassword();
// user.PasswordQuestion = User.PasswordQuestion;
SqlCommand cmd = new SqlCommand("select * from UsersInformation where UserId='" + User.ProviderUserKey + "'", connection);
connection.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
user.FirstName = rdr["FirstName"].ToString();
user.LastName = rdr["LastName"].ToString();
user.UserCod = rdr["UserCod"].ToString();
user.IsAsoc = Convert.ToBoolean(rdr["IsAsoc"].ToString());
user.AsocId = Convert.ToInt32(rdr["AsocId"].ToString());
}
else
{
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = conn;
cmd2.CommandText = "SELECT [Cod], [Nume] FROM [Ferme_CCL] Where ([Cod] <> '') ORDER BY [Nume]";
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable table = ds.Tables[0];
DataRow row = table.Rows[0];
user.UserCod = row["Cod"].ToString().Trim();
conn.Close();
user.FirstName = "";
user.LastName = "";
}
rdr.Close();
connection.Close();
}
users.Add(user);
}
return users;
}
public ActionResult Edit(MUser model)
{
var q = this.userService.Find(c => c.Id == model.Id);
if (ModelState.IsValid)
{
q.GroupId = model.GroupId;
q.IsActive = model.IsActive;
this.userService.Update(q);
return RedirectToAction("List");
}
return View();
}
public List<MUser> GetUser(string username)
{
MembershipUser User = Membership.GetUser(username);
List<MUser> users = new List<MUser>();
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["rolesConnectionString"].ConnectionString);
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);
//foreach (MembershipUser User in allUsers)
// {
MUser user = new MUser();
user.Email = User.Email;
user.UserName = User.UserName;
user.LastLogin = User.LastLoginDate.ToString("G");
user.IsApproved = User.IsApproved.ToString();
string[] roles = Roles.GetRolesForUser(User.UserName);
user.Role = roles[0];
// user.Password = User.GetPassword();
user.PasswordQuestion = User.PasswordQuestion;
SqlCommand cmd = new SqlCommand("select * from UsersInformation where UserId='" + User.ProviderUserKey + "'", connection);
connection.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
user.Salutation = rdr["Salutation"].ToString();
user.FirstName = rdr["FirstName"].ToString();
user.LastName = rdr["LastName"].ToString();
user.UserCod = rdr["UserCod"].ToString();
}
else
{
SqlCommand cmd2 = new SqlCommand
{
Connection = conn,
CommandText = "SELECT [Cod], [Nume] FROM [Ferme_CCL] Where ([Cod] <> '') ORDER BY [Nume]"
};
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable table = ds.Tables[0];
DataRow row = table.Rows[0];
user.UserCod = row["Cod"].ToString().Trim();
conn.Close();
user.Salutation = "";
user.FirstName = "";
user.LastName = "";
}
rdr.Close();
connection.Close();
}
// }
users.Add(user);
return users;
}
public bool Update(MUser model)
{
return this.userDal.Update(model);
}
