public void LoadData()
{
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
DataTable nTable = new DataTable();
if (nUserLogin.GroupKey == 4)
{
nTable = Users_Data.GetList("", Session["CooperativeKey"].ToInt());
}
else if (nUserLogin.GroupKey == 3)
{
nTable = Users_Data.GetList(Session["CooperativeKey"].ToInt(), 3, "");
}
else if (nUserLogin.GroupKey == 2)
{
nTable = Users_Data.GetList("", nUserLogin.CooperativeKey, nUserLogin.GroupKey);
}
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add(null, 0, "", "", "", 0, DateTime.Now, DateTime.Now, 0);
}
GV_User.DataSource = nTable;
GV_User.DataBind();
DateTime dt = DateTime.Now;
}
public ActionResult Create(ViewModel model, String role_value, Users_Data users_data)
{
ViewBag.UserFirst = Session["first"];
ViewBag.UserLast = Session["last"];
var name = Session["first"];
//if (ModelState.IsValid)
//{
var checkEmail = db.Users_Data.Where(m => m.user_email_id == users_data.user_email_id).FirstOrDefault();
if (checkEmail == null)
{
//var _id = users_data.user_ID;
var firstname = model.first_name.ToString();
var lastname = model.last_name.ToString();
var middleName = model.user_middle_name;
var email = model.email_id.ToString();
var phonenum = model.Phone.ToString();
var pwd = model.user_web_pwd;
var role = role_value;
//var id = (users_Data.user_ID);
var addedby = name.ToString();
var keyword = "Create";
var username = model.username.ToString();
db.Database.ExecuteSqlCommand("create_user @First_name = {0}, @last_name = {1}, @middle_name = {2}, @Email = {3}, @Phone_number = {4}, @pwd = {5}, @role ={6}, @keyword={7}, @addedby={8}, @username={9}", firstname, lastname, middleName, email, phonenum, pwd, role, keyword, addedby, username);
return(View("Index"));
}
else
{
ModelState.AddModelError("", "Email id already exist");
return(View("Create"));
}
}
public ActionResult Save(ManageUsersModel model, String role_value)
{
if (Session["username"] == null)
{
return(Redirect("~/Home/Login"));
}
else
{
ViewBag.UserFirst = Session["first"];
ViewBag.UserLast = Session["last"];
Users_Data udata = new Users_Data();
Role role = new Role();
// udata.user_first_name = model.FirstName;
// udata.user_last_name = model.LastName;
//// udata.user_middle_name = model.MiddleName;
// udata.user_phone_number = model.PhoneNumber;
// udata.user_email_id = model.EmailId;
// //udata.user_full_name = model.FullName;
// udata.user_web_login = model.UserName;
// role.role_code = role_value;
var firstname = model.FirstName;
var lastname = model.LastName;
var middlename = model.MiddleName;
var email = model.EmailId;
var phonenum = model.PhoneNumber;
var pwd = model.Password;
var newrole = role_value;
var keyword = "Edit";
var addedby = model.AddedBy;
var username = model.UserName;
db.Database.ExecuteSqlCommand("create_user @First_name = {0}, @last_name = {1}, @middle_name = {2}, @Email = {3}, @Phone_number = {4}, @pwd = {5}, @role ={6}, @keyword={7}, @addedby={8}, @username={9}", firstname, lastname, middlename, email, phonenum, pwd, newrole, keyword, addedby, username);
// return View("Index");
var resIndex = (from ud in db.Users_Data
join r in db.Roles on ud.user_role_key equals r.role_key
select new ManageUsersModel
{
UserID = ud.user_ID,
FirstName = ud.user_first_name,
LastName = ud.user_last_name,
EmailId = ud.user_email_id,
PhoneNumber = ud.user_phone_number,
UserRole = r.role_code,
Password = ud.user_web_pwd,
AddedBy = ud.user_added_by,
UserName = ud.user_web_login,
IsActive = ud.user_active_flag == 0 ? false : true
}
).ToList();
//db.SaveChanges();
return(View("All", resIndex));
}
}
protected void OnPaging(object sender, GridViewPageEventArgs e)
{
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
GV_User.PageIndex = e.NewPageIndex;
DataTable nTable = Users_Data.GetList(txtSearch.Text, int.Parse(Session["CooperativeKey"].ToString()), nUserLogin.GroupKey);
GV_User.DataSource = nTable;
GV_User.DataBind();
}
protected void cmdView_Click1(object sender, ImageClickEventArgs e)
{
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
DataTable nTable = Users_Data.GetList(txtSearch.Text, int.Parse(Session["CooperativeKey"].ToString()), nUserLogin.GroupKey);
GV_User.DataSource = nTable;
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add(new Guid(), 0, "", "", "", 0, DateTime.Now, DateTime.Now, 0);
}
GV_User.DataBind();
}
public ActionResult Home(Users_Data user, int check)
{
ViewBag.check = check;
ViewBag.username = user;
HttpChannel channel = new HttpChannel();
ChannelServices.RegisterChannel(channel);
client = (ITwitterSentimentService.ITwitterSentimentService)Activator.GetObject
(typeof(ITwitterSentimentService.ITwitterSentimentService), "http://localhost:8080/RetrieveCases");
ViewBag.cases = client.RetrieveCases();
ChannelServices.UnregisterChannel(channel);
return(View("Home"));
}
protected void cmdLogin_Click(object sender, ImageClickEventArgs e)
{
string[] nResult = Users_Data.CheckUser(txtUserName.Text, txtPassword.Text);
if (nResult[0] == "ERR")
{
switch (nResult[1])
{
case "CheckUser_Error01":
lblStatus.Text = "Vui lòng kiểm tra tài khoản và mật khẩu";
break;
case "CheckUser_Error02":
lblStatus.Text = "User này đã lock, vui lòng liên hệ Administrator";
break;
case "CheckUser_Error03":
lblStatus.Text = "User này đã hết hạn, vui lòng liên hệ Administrator";
break;
}
}
else
{
if (cbRemember.Checked)
{
User_Info info = new User_Info(int.Parse(nResult[2]));
string cookies = RandomString(50);
info.Cookies = cookies;
HttpCookie ck = new HttpCookie("Code");
ck.Value = cookies;
this.Response.Cookies.Add(ck);
info.Cookies = cookies;
info.Save();
}
SessionUserLogin nLogin = new SessionUserLogin();
nLogin.Name = txtUserName.Text;
nLogin.Key = nResult[1];
Session["EmployeeKey"] = Session["MemberID"] = nLogin.EmployeeKey = int.Parse(nResult[2]);
nLogin.GroupKey = int.Parse(nResult[3]);
nLogin.CooperativeKey = int.Parse(nResult[4]);
nLogin.EmployeeName = nResult[5];
nLogin.BranchName = nResult[6];
Session["UserLogin"] = nLogin;
Session["MemberName"] = nResult[5];
Session["CooperativeKey"] = nLogin.CooperativeKey;
Session["UserName"] = txtUserName.Text;
Session["SysUserKey"] = nResult[1];
//
FormsAuthentication.RedirectFromLoginPage(nResult[1], false);
Response.Redirect("~/Book.aspx");
}
}
public ActionResult Verify_ParticipateInCase(Users_Data add)
{
int check = 0;
HttpChannel channel = new HttpChannel();
ChannelServices.RegisterChannel(channel);
client = (ITwitterSentimentService.ITwitterSentimentService)Activator.GetObject
(typeof(ITwitterSentimentService.ITwitterSentimentService), "http://localhost:8080/ParticipateCase");
client.ParticipateCase(add.tweet_text, add.first_name, add.last_name, add.case_id);
ChannelServices.UnregisterChannel(channel);
return(this.Home(add, check));
}
// GET: Email/Edit/5
public async Task <ActionResult> Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Users_Data users_Data = await db.Users_Data.FindAsync(id);
if (users_Data == null)
{
return(HttpNotFound());
}
return(View(users_Data));
}
protected void cmdLogin_Click(object sender, ImageClickEventArgs e)
{
string[] nResult = Users_Data.CheckUser(txtUserName.Text, txtPassword.Text);
if (nResult[0] == "ERR")
{
switch (nResult[1])
{
case "CheckUser_Error01":
lblStatus.Text = "Vui lòng kiểm tra Username và Password";
break;
case "CheckUser_Error02":
lblStatus.Text = "User này đã lock, vui lòng liên hệ Administrator";
break;
//case "CheckUser_Error03":
// lblStatus.Text = "User này đã hết hạn, vui lòng liên hệ Administrator";
// break;
case "CantLogin":
lblStatus.Text = "Tài khoản của bạn không đủ quyền truy cập!";
break;
}
}
else
{
SessionUserLogin nLogin = new SessionUserLogin();
nLogin.Name = txtUserName.Text;
nLogin.Key = nResult[1];
Session["EmployeeKey"] = nLogin.EmployeeKey = int.Parse(nResult[2]);
nLogin.GroupKey = int.Parse(nResult[3]);
nLogin.CooperativeKey = int.Parse(nResult[4]);
nLogin.EmployeeName = nResult[5];
nLogin.BranchName = nResult[6];
nLogin.CooperativeVenturesKey = int.Parse(nResult[7]);
Session["UserLogin"] = nLogin;
if (int.Parse(nResult[2]) != 0)
{
Session["MemberName"] = LoadDataToToolboxWeb.GetName("Select Name FROM PUL_Member WHERE [Key] =" + nResult[2]);
}
else
{
Session["MemberName"] = "";
}
//
FormsAuthentication.RedirectFromLoginPage(nResult[1], false);
Response.Redirect("~/Culture/Default.aspx");
}
}
public ActionResult ChangePassword(PwdChange cpwd)
{
if (ModelState.IsValid)
{
var email = Session["email"].ToString();
//string email = "*****@*****.**";
Users_Data userdata = db.Users_Data.Where(c => c.user_email_id == email && c.user_web_pwd == cpwd.current_pwd).FirstOrDefault();
if (userdata != null)
{
//Users_Data _uda = new Users_Data();
try
{
userdata.user_web_pwd = cpwd.new_pwd;
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
else
{
ModelState.AddModelError("", "Please enter valid password");
}
}
else
{
ModelState.AddModelError("", "Please enter all the fields");
return(View());
}
return(View());
}
public Users_Data AddUsers_Data(int user_goalId, DateTime date, double value)
{
try
{
var user_data = new Users_Data();
user_data.Date = date;
user_data.User_GoalId = user_goalId;
user_data.Value = value;
db.Users_Data.InsertOnSubmit(user_data);
db.SubmitChanges();
return(user_data);
}
catch (Exception e)
{
return(null);
}
}
public static bool CheckPassword(string Zold)
{
string UserName = HttpContext.Current.Session["UserName"].ToString();
try
{
string[] nResult = Users_Data.CheckUser(UserName, Zold);
if (nResult[0] == "ERR")
{
return(false);
}
else
{
return(true);
}
}
catch { return(false); }
}
public static bool SaveChangePass(string Zold, string Znew)
{
string UserName = HttpContext.Current.Session["UserName"].ToString();
try
{
string[] nResult = Users_Data.CheckUser(UserName, Zold);
if (nResult[0] == "ERR")
{
return(false);
}
else
{
Users_Data.UpdatePass(nResult[1], MyCryptography.HashPass(Znew));
return(true);
}
}
catch { return(false); }
}
public ActionResult Verify_addtweet(Users_Data add)
{
int check = 0;
HttpChannel channel = new HttpChannel();
ChannelServices.RegisterChannel(channel);
client = (ITwitterSentimentService.ITwitterSentimentService)Activator.GetObject
(typeof(ITwitterSentimentService.ITwitterSentimentService), "http://localhost:8080/AddTweet");
try
{
client.AddTweet(add.tweet_text, add.first_name, add.last_name);
}
catch (Exception e)
{
Console.WriteLine(e);
ChannelServices.UnregisterChannel(channel);
}
ChannelServices.UnregisterChannel(channel);
return(this.Home(add, check));
}
protected void GrDelete(object sender, CommandEventArgs e)
{
SessionUserLogin nUserLogin = (SessionUserLogin)Session["UserLogin"];
nUserLogin.CheckRole("CU0010");
if (!nUserLogin.Role.Del)
{
Response.Write("<script >alert('Bạn không có quyền xóa danh mục này!')</script>");
}
else
{
try
{
string mKey = e.CommandArgument.ToString();
User_Info info = new User_Info(mKey);
if ((DateTime.Now - info.CreatedDateTime).TotalDays > 7)
{
Response.Write("<script >alert('Dữ liệu đã quá 7 ngày, không được phép xóa!')</script>");
}
else
{
info.Delete();
DataTable nTable = Users_Data.GetList(txtSearch.Text, int.Parse(Session["CooperativeKey"].ToString()), nUserLogin.GroupKey);
GV_User.DataSource = nTable;
if (nTable.Rows.Count == 0)
{
nTable.Rows.Add(null, 0, "", "", "", 0, DateTime.Now, DateTime.Now, 0);
}
GV_User.DataBind();
}
}
catch
{
Response.Write("<script >alert('Có lỗi gì đó vui lòng thử lại!')</script>");
}
}
}
public ActionResult Verify_Login(Users_Data user_data)
{
HttpChannel channel = new HttpChannel();
ChannelServices.RegisterChannel(channel);
client = (ITwitterSentimentService.ITwitterSentimentService)Activator.GetObject
(typeof(ITwitterSentimentService.ITwitterSentimentService), "http://localhost:8080/CheckUser");
string check_user = client.CheckUser(user_data.first_name, user_data.last_name);
if (check_user == "Registered")
{
ChannelServices.UnregisterChannel(channel);
int check = 1;
return(this.Home(user_data, check));
}
else
{
ViewBag.check = 0;
ChannelServices.UnregisterChannel(channel);
return(View("Login"));
}
}
