public ActionResult CreateOrUpdate(UsersModel model)
{
var entity = model.Id > 0 ? _userService.GetById(model.Id) : new Users();
string password = entity.Password;
string passwordSalt = entity.PasswordSalt;
Mapper.CreateMap<UsersModel, Users>();
Mapper.Map(model, entity);
entity.LastUpdated = DateTime.Now;
string msg = string.Empty;
if (entity.Id == 0)
{
entity.LoginDate = DateTime.Now;
entity.PasswordSalt = AES.GetRandomSalt();
entity.Password = AES.Encrypt(entity.Password, entity.PasswordSalt);
_userService.Insert(entity);
msg = "Thêm thành công !";
}
else
{
entity.PasswordSalt = passwordSalt;
entity.Password = password;
_userService.Update(entity);
msg = "Cập nhật thành công !";
}
TempData["Message"] = null;
if (!String.IsNullOrEmpty(msg))
TempData["Message"] = msg;
return RedirectToAction("Edit", new { Id = entity.Id });
}
public ActionResult Create()
{
var model = new UsersModel();
model.CreatedDate = DateTime.Now;
model.IsActive = true;
PrepareAllGendersModel(model);
return View(model);
}
public ActionResult BanUser(int? userId, bool? isBanned, UsersModel model)
{
if (userId.HasValue && isBanned.HasValue)
Execute(() => _accountService.BanUser(userId.GetValueOrDefault(), isBanned.Value));
FillUsersModel(model);
return ModelIsValid
? (ActionResult)View("UsersData", model)
: JsonErrorResult();
}
public ActionResult Registration(UsersModel user)
{
if (ModelState.IsValid)
{
currentUserService.SendActivationEmail(user);
currentUserService.Add(user);
logger.Debug("Was added the user with id" + user.id_user);
return RedirectToAction("Login", "Account");
}
else return View(user);
}
public User convertToDal(UsersModel user)
{
var listOfUser = new User();
listOfUser.id_user = user.id_user;
listOfUser.First_Name = user.First_Name;
listOfUser.Last_Name = user.Last_Name;
listOfUser.Password = user.Password;
listOfUser.Email = user.Email;
listOfUser.Roles = "user";
return listOfUser;
}
public UsersModel convertToUI(User user)
{
var listOfUser = new UsersModel();
listOfUser.id_user = user.id_user;
listOfUser.First_Name = user.First_Name;
listOfUser.Last_Name = user.Last_Name;
listOfUser.Password = user.Password;
listOfUser.Email = user.Email;
listOfUser.Roles = user.Roles;
return listOfUser;
}
public ActionResult ActivateUser(int? userId, UsersModel model)
{
if (userId.HasValue)
Execute(() => _accountService.ActivateUser(userId.GetValueOrDefault()));
FillUsersModel(model);
return ModelIsValid
? (ActionResult)View("UsersData", model)
: JsonErrorResult();
}
public ActionResult Edit(int Id)
{
var entity = _userService.GetById(Id);
var model = new UsersModel();
if (entity != null)
{
Mapper.CreateMap<Users, UsersModel>();
Mapper.Map(entity, model);
}
PrepareAllGendersModel(model);
return View(model);
}
public HttpResponseMessage Post(UserRegistrationDTO user)
{
UsersModel userModel = new UsersModel();
bool add = userModel.AddUser(user);
HttpResponseMessage response;
if (add)
{
SuccessMessage msg = new SuccessMessage("Registration successful!");
response = Request.CreateResponse(HttpStatusCode.OK, msg);
return response;
}
else
{
ErrorMessage msg = new ErrorMessage("Registration failed! Username or email already exists");
response = Request.CreateResponse(HttpStatusCode.Forbidden, msg);
return response;
}
}
/// <summary>
/// RegisterNewUSer
/// </summary>
/// <returns></returns>
public int RegisterNewUSer(UsersModel UsersDTO)
{
return(objUsersDAL.RegisterNewUSer(UsersDTO));
}
public ActionResult Results(UsersModel m)
{
return(View(m));
}
/// <summary>
///判断用户登录信息 type 0:首页登录 1:后台管理员
/// </summary>
public ResponseModel CheckLogin(int userid, string username, string password, string type, ref UsersModel user)
{
var users = type == "1" ? _db.Users.FirstOrDefault(c => c.F_Account == username && c.F_Password == password && c.F_IsSystem == 1) : _db.Users.FirstOrDefault(c => c.F_Account == username && c.F_Password == password && c.F_IsSystem == 0);
if (users == null)
{
return(new ResponseModel {
code = 0, result = "该账号不存在,或者密码错误！"
});
}
else
{
if (type == "0")
{
UsersModel u = new UsersModel();
u.F_UserId = userid;
u.F_Account = username;
u.F_RealName = users.F_RealName;
u.F_Sex = users.F_Sex == 0 ? "女" : "男";
u.F_Remark = users.F_Remark;
u.F_Image = users.F_Image;
user = u;
//MemoryCacheService.SetChacheValue("loginuserinfo", list);
}
return(new ResponseModel {
code = 200, result = "登录成功"
});
}
}
public static void Set(this HttpSessionStateBase session, UsersModel value)
{
session["user"] = value;
}
public Dashboard(UsersModel u)
{
InitializeComponent();
}
public XmlProvider(String src, String parserType, String trackedFile, Dictionary <int, String[]> tags, UsersModel user) : this(src, parserType, trackedFile, user)
{
KnownNodes = tags;
}
public XmlProvider(String src, String parserType, UsersModel user) : this(src, user)
{
FileParser = parserType;
}
public XmlCommentProvider(string src, UsersModel user) : base(src, user)
{
}
public UsersViewModel()
{
Users = new UsersModel();
}
public bool mail(UsersModel user)
{
bool activeted=false;
//MailMessage message = new MailMessage();
//SmtpClient client = new SmtpClient();
//client.Host = "smtp.gmail.com";
//client.Port = 587;
//string userActivation = "http://*****:*****@gmail.com");
//message.To.Add(user.Email);
//message.Subject = "Account Activation";
//message.Body = "Hi" + user.First_Name + "</br>Your Email Confirmation link is Here</br> <a href = '" + userActivation + "'>click Here</a>";
//message.IsBodyHtml = true;
//client.EnableSsl = true;
//client.UseDefaultCredentials = true;
//client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "zerooptununouanouacinci");
//client.Send(message);
return activeted;
}
public ActionResult SendMessageForActivate(int? userId, UsersModel model)
{
if (userId.HasValue)
{
var user = Execute(() => _accountService.GetUser(userId.GetValueOrDefault()));
if (ModelIsValid)
{
var activateModel = new MailActivateModel
{
Token = Execute(() => _accountService.GetUserActivateToken(user.Email)),
Email = user.Email,
Password = StringGeneration.Generate(8)
};
Execute(() => _accountService.SetPassword(user.Id, activateModel.Password));
if (ModelIsValid && !string.IsNullOrEmpty(activateModel.Token))
_mailer.SendMessageAsync("ActivateAccount", activateModel, user.Email);
}
}
FillUsersModel(model);
return ModelIsValid
? (ActionResult)View("UsersData", model)
: JsonErrorResult();
}
public ActionResult Save(UsersModel user)
{
logger.Debug("You saved edited information about the user:"******" " + user.First_Name + " " + user.Last_Name + " " + user.Email);
currentUserService.Save(user);
return RedirectToAction("Information");
}
public IActionResult DeleteUser([FromBody] UsersModel model)
{
var data = DbClientFactory <UsersDbClient> .Instance.DeleteUser(model.Id, appSettings.Value.ConnectionString);
return(Ok(data));
}
// GET: Users
public ActionResult Index()
{
var model = new UsersModel();
return(View(model));
}
public ActionResult UsersData(UsersModel model)
{
FillUsersModel(model);
return View(model);
}
public ActionResult Edit(UsersModel model)
{
return(null);
}
public XmlProvider(String src, String parserType, String trackedFile, UsersModel user) : this(src, parserType, user)
{
TrackedFile = trackedFile;
}
private void PrepareAllGendersModel(UsersModel model)
{
if (model == null)
throw new ArgumentNullException("model");
var male = new SelectListItem() { Text = "Nam", Value = "1" };
var female = new SelectListItem() { Text = "Nữ", Value = "2" };
var other = new SelectListItem() { Text = "Khác", Value = "0", Selected = true };
model.AvailableGenders.Add(male);
model.AvailableGenders.Add(female);
model.AvailableGenders.Add(other);
}
static void Main(string[] args)
{
string _ConsumerKey = ConfigurationManager.AppSettings.Get("ConsumerKey");
string _ConsumerSecret = ConfigurationManager.AppSettings.Get("ConsumerSecret");
string _AccessToken = ConfigurationManager.AppSettings.Get("AccessToken");
string _AccessTokenSecret = ConfigurationManager.AppSettings.Get("AccessTokenSecret");
OAuthInfo oAuthInfo = new OAuthInfo
{
AccessSecret = _AccessTokenSecret,
AccessToken = _AccessToken,
ConsumerSecret = _ConsumerSecret,
ConsumerKey = _ConsumerKey
};
HideReplyService hideRepliesService = new HideReplyService(oAuthInfo);
HideReplyModel model = hideRepliesService.HideReply("1296341968176451585");
// Sampled Stream Service Test
SampledStreamService streamService = new SampledStreamService(oAuthInfo);
streamService.DataReceivedEvent += StreamService_DataReceivedEvent;
streamService.StartStream("https://api.twitter.com/2/tweets/sample/stream?expansions=attachments.poll_ids,attachments.media_keys,author_id,entities.mentions.username,geo.place_id,in_reply_to_user_id,referenced_tweets.id,referenced_tweets.id.author_id", 100, 5);
// Recent Search
RecentSearchService searchService = new RecentSearchService(oAuthInfo);
List <RecentSearchResultsModel> resultsModels = searchService.SearchTweets("iphone", 100, 3);
// Tweet(s)
TweetService tweetsService = new TweetService(oAuthInfo);
TweetModel tweetModel = tweetsService.GetTweet("1293779846691270658");
List <string> tids = new List <string>();
tids.Add("1293779846691270658"); // social opinion tweet
tids.Add("1293779846691270658"); // social opinion tweet
TweetsModel tweetModels = tweetsService.GetTweets(tids);
// User(s)
UserService userService = new UserService(oAuthInfo);
UserModel userModel = userService.GetUser("socialopinions");
List <string> users = new List <string>();
users.Add("jamie_maguire1");
users.Add("socialopinions");
UsersModel usersResults = userService.GetUsers(users);
// Metrics
List <string> ids = new List <string>();
ids.Add("1258736674844094465"); // social opinion tweet
TweetMetricsService service = new TweetMetricsService(oAuthInfo);
List <TweetMetricModel> metricModels = service.GetTweetMetrics(ids);
// testing Filtered Stream
FilteredStreamService filteredStreamService = new FilteredStreamService(oAuthInfo);
List <FilteredStreamRule> rules = filteredStreamService.CreateRule(
new MatchingRule {
tag = "testing #iPhone", Value = "#iphone"
});
filteredStreamService.DataReceivedEvent += FilteredStreamService_DataReceivedEvent;
filteredStreamService.StartStream("https://api.twitter.com/2/tweets/search/stream?tweet.fields=attachments,author_id,context_annotations,conversation_id,created_at,entities,geo,id,in_reply_to_user_id,lang,public_metrics,possibly_sensitive,referenced_tweets,source,text,withheld&expansions=author_id&user.fields=created_at,description,entities,id,location,name,pinned_tweet_id,profile_image_url,protected,public_metrics,url,username,verified,withheld", 10, 5);
}
public bool Add(UsersModel user)
{
userDal.Add(userConvert.convertToDal(user));
return true;
}
public static string SearchData(string batchno, string status, string floc, string tloc, string fdate, string tdate)
{
//按用户查看数据
UsersModel model = (UsersModel)HttpContext.Current.Session[SysConst.S_LOGIN_USER];
if (status == "Both")
{
status = "'In Progress','Finish'";
}
if (status == "In Progress")
{
status = "'In Progress'";
}
if (status == "Finish")
{
status = "'Finish'";
}
string sql = "";
string sql_d = "";
string sqlquery = "";
string res = string.Empty;
try
{
if (model.USERNAME != "administrator")
{
sql = " SELECT a.[Organization],a.[OperationNo],a.[TransactionType],a.[SerialNO],a.[PartNO],a.[From_LOC],a.[To_LOC],a.[Quantity],a.[Creater],a.[Createdate],a.[BatchNO],a.[ContainerStatus]" +
" FROM [ProcessHOAudit_T] a where a.[ContainerStatus] in (" + status + ") AND a.[Organization]+a.[OperationNo] IN (SELECT ORGANIZATION + OPERATION FROM UserCtrl U WHERE U.USERNAME = '******')";
}
if (model.USERNAME == "administrator")
{
sql = " SELECT [Organization],[OperationNo],[TransactionType],[SerialNO],[PartNO],[From_LOC],[To_LOC],[Quantity],[Creater],[Createdate],[BatchNO],[ContainerStatus] " +
" FROM [ProcessHOAudit_T] a where a.[ContainerStatus] in (" + status + ") ";
}
if (fdate != "")
{
sql = sql + " and a.Createdate between cast('" + fdate + "' as datetime) and cast('" + tdate + "' as datetime)";
}
if (batchno != "")
{
sql = sql + " and a.BatchNO = '" + batchno + "'";
}
if (floc != "")
{
sql = sql + " and a.From_LOC like '" + floc + "'";
}
if (tloc != "")
{
sql = sql + " and a.To_LOC like '" + tloc + "'";
}
//直接交接的数据
if (model.USERNAME != "administrator")
{
sql_d = " SELECT p.[Organization],p.[Operation],p.[TransactionType],p.SERIALNO,p.PARTNO,p.FROM_LOC,p.TO_LOC,p.QUANTITY,p.CREATER,p.CREATEDATE," +
" p.BATCHNO,'Finish' FROM PROCESSHANDOVER_T p WHERE p.[ContainerStatus] in (" + status + ") AND p.[Organization]+p.[Operation] IN (SELECT ORGANIZATION + OPERATION FROM UserCtrl U WHERE U.USERNAME = '******')";
}
if (model.USERNAME == "administrator")
{
sql_d = " SELECT p.[Organization],p.[Operation],p.[TransactionType],p.SERIALNO,p.PARTNO,p.FROM_LOC,p.TO_LOC,p.QUANTITY,p.CREATER,p.CREATEDATE," +
" p.BATCHNO,'Finish' FROM PROCESSHANDOVER_T p WHERE p.[ContainerStatus] in (" + status + ")";
}
if (fdate != "")
{
sql_d = sql_d + " and p.Createdate between cast('" + fdate + "' as datetime) and cast('" + tdate + "' as datetime)";
}
if (batchno != "")
{
sql_d = sql_d + " and p.BatchNO = '" + batchno + "'";
}
if (floc != "")
{
sql_d = sql_d + " and p.From_LOC like '" + floc + "'";
}
if (tloc != "")
{
sql_d = sql_d + " and p.To_LOC like '" + tloc + "'";
}
sqlquery = " select aa. [Organization],aa.[OperationNo],aa.[TransactionType],aa.[SerialNO],aa.[PartNO],aa.[From_LOC],aa.[To_LOC],aa.[Quantity],aa.[Creater],aa.[Createdate],aa.[BatchNO],aa.[ContainerStatus] from " +
" (" + sql + " union all " + sql_d + ") aa order by aa.[Creater] desc";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper.Query(sqlquery);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <PlexContainer> luw = new List <PlexContainer>();
foreach (DataRow row in ds.Tables[0].Rows)
{
PlexContainer ERM = new PlexContainer(row);
luw.Add(ERM);
}
JavaScriptSerializer jssl = new JavaScriptSerializer();
res = jssl.Serialize(luw);
res = res.Replace("\\/Date(", "").Replace(")\\/", "");
}
}
catch (Exception e)
{
}
return(res);
}
public ActionResult AdminAdd(UsersModel model)
{
UserInfo userInfo = new UserInfo();
if (ModelState.IsValid)
{
//验证用户名是否重复
PartUserInfo info = Users.GetPartUserByName(model.UserName);
if (info != null)
{
return(PromptView("用户名不能重复"));
}
//model.Email = Request.Form.Get("Email").ToString();
//Regex regex = new Regex(@"([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])");
//bool a = regex.IsMatch(model.Email);
//if (a == false)
//{
// return PromptView("/admin/Users/AdminAdd", "请输入正确的邮箱格式!");
//}
//model.Mobile = Request.Form.Get("Mobile").ToString();
//Regex regem = new Regex(@"1[34578]\d{9}");
//bool b = regem.IsMatch(model.Mobile);
//if (b == false)
//{
// return PromptView("/admin/Users/AdminAdd", "请输入正确的手机号码!");
//}
//model.Password = Request.Form.Get("Password").ToString();
//Regex regeb = new Regex(@"\d{6}");
//bool c = regeb.IsMatch(model.Password);
//if (c == false)
//{
// return PromptView("/admin/Users/AdminAdd", "请至少输入6位数的密码!");
//}
string ck = WebHelper.GetCookie("bs", "uname");
userInfo.UserID = model.UserID;
userInfo.UserName = model.UserName;
//userInfo.Password,
userInfo.Salt = Users.GenerateUserSalt();
userInfo.Password = Users.CreateUserPassword(model.Password, userInfo.Salt);
if (Request.Form.Get("NickName").ToString().Equals(""))
{
userInfo.NickName = ck;
}
else
{
userInfo.NickName = model.NickName;
}
userInfo.Email = model.Email;
userInfo.Mobile = model.Mobile;
userInfo.AdminGroupID = model.AdminGroupID;
userInfo.Avatar = "";
userInfo.RankCredits = 0;
userInfo.UserRankID = 0;
userInfo.VerifyEmail = 0;
userInfo.State = 0;
userInfo.Address = "";
userInfo.Birthday = DateTime.Parse("1900-1-1");
userInfo.Body = "";
userInfo.Gender = 0;
userInfo.IdCard = "";
userInfo.LastIP = "";
userInfo.LastTime = DateTime.Now;
userInfo.RegionId = 0;
userInfo.RegIP = "";
userInfo.RegTime = DateTime.Now;
Users.CreateUser(userInfo);
//AddAdminOperateLog
return(PromptView("管理员新加成功"));
}
List <UserRoleInfo> resultList = new List <UserRoleInfo>();
resultList = UserRoles.GetUserRoleList().ToList();
//Load();
TempData["modelList"] = resultList;
return(View(model));
}
public static string addAssetCard(String data)
{
string res = "0";
IT_AssetInfoModel AssetVO = new IT_AssetInfoModel();
JavaScriptSerializer jssl = new JavaScriptSerializer();
AssetVO = jssl.Deserialize <IT_AssetInfoModel>(data);
UsersModel model = (UsersModel)HttpContext.Current.Session[SysConst.S_LOGIN_USER];
List <String> sqllist = new List <String>();
//数据重复性检查
string errorMsg = String.Empty;
if (!String.IsNullOrEmpty(AssetVO.IT_AssetNO))
{
if (ValueRepeatCheck("IT_AssetNO", AssetVO.IT_AssetNO))
{
errorMsg = "IT_AssetNO is repeat" + '\n';
}
}
if (!String.IsNullOrEmpty(AssetVO.FIN_AssetNO))
{
if (ValueRepeatCheck("FIN_AssetNO", AssetVO.FIN_AssetNO))
{
errorMsg = "FIN_AssetNO is repeat" + '\n';
}
}
if (!String.IsNullOrEmpty(AssetVO.SerialNO))
{
if (ValueRepeatCheck("SerialNO", AssetVO.SerialNO))
{
errorMsg = "SerialNO is repeat" + '\n';
}
}
if (!String.IsNullOrEmpty(AssetVO.MacAddress))
{
if (ValueRepeatCheck("MacAddress", AssetVO.MacAddress))
{
errorMsg = "MAC ID is repeat" + '\n';
}
}
if (String.IsNullOrEmpty(errorMsg))
{
//生成日志表
string sql1 = "select next value for FGA_AssetCardID";
string akey = "ITA" + FGA_DAL.Base.SQLServerHelper_WMS.GetSingle(sql1).ToString();
string sql2 = " INSERT INTO [FGA_AssetCard_T]([AssetKey],[AssetName],[Category],[Brand],[IT_AssetNO],[FIN_AssetNO],[SerialNO] " +
",[CreateDate],[Creator],[InsuranceDate],[MacAddress],[Note],[Dr],[LastEditUser],[LastAction],[AssetConfig]) " +
"VALUES('" + akey + "','" + AssetVO.AssetName + "','" + AssetVO.Category + "','" + AssetVO.Brand + "','" + AssetVO.IT_AssetNO + "' " +
" ,'" + AssetVO.FIN_AssetNO + "','" + AssetVO.SerialNO + "',getdate(),'" + model.USERNAME + "','' " +
" ,'" + AssetVO.MacAddress + "','" + AssetVO.Note + "','0',null,'Asset Added','" + AssetVO.AssetConfig + "')";
string sql3 = "insert into [FGA_ITAssetInfos_T]([Issue_Date],[Creator],[CreateDate],[PlexID],[Active],[Status],[AssetKey],[Note],[IsCheck]) " +
"values(convert(varchar(10),getdate(),120),'" + model.USERNAME + "',getdate(),'fy.it','0','Idle','" + akey + "','" + AssetVO.Note + "',0) ";
sqllist.Add(sql2);
sqllist.Add(sql3);
if (FGA_DAL.Base.SQLServerHelper_WMS.ExecuteSqlTran(sqllist) > 0)
{
res = akey;
}
else
{
res = "0";
}
}
else
{
res = errorMsg;
}
return(res);
}
private void btnSave_Click(object sender, EventArgs e)
{
for (int i = 1; i < grvData.RowCount; i++)
{
try
{
if (grvData.GetRowCellValue(i, "1") == null)
{
continue;
}
string code = grvData.GetRowCellValue(i, "1").ToString();
if (code == "")
{
continue;
}
DepartmentModel department = null;
DepartmentModel departmentKP = null;
UsersModel userFind = null;
try
{
department = (DepartmentModel)DepartmentBO.Instance.FindByAttribute("Code", grvData.GetRowCellValue(i, "7").ToString())[0];
}
catch { }
try
{
departmentKP = (DepartmentModel)DepartmentBO.Instance.FindByAttribute("Code", grvData.GetRowCellValue(i, "10").ToString())[0];
}
catch { }
try
{
userFind = (UsersModel)UsersBO.Instance.FindByAttribute("LoginName", grvData.GetRowCellValue(i, "16").ToString())[0];
}
catch { }
ModulesModel module = null;
string moduleCode = "";
try
{
moduleCode = grvData.GetRowCellValue(i, "5").ToString();
module = (ModulesModel)ModulesBO.Instance.FindByAttribute("Code", grvData.GetRowCellValue(i, "5").ToString().Substring(0, 10))[0];
}
catch { }
ModuleErrorModel error;
if (!ModuleErrorBO.Instance.CheckExist("Code", code))
{
error = new ModuleErrorModel();
}
else
{
error = (ModuleErrorModel)ModuleErrorBO.Instance.FindByAttribute("Code", code)[0];
}
//error.Description = moduleCode.Length == 10 ? grvData.GetRowCellValue(i, "6").ToString() : moduleCode + ": "
// + grvData.GetRowCellValue(i, "6").ToString();
//error.HuongKhacPhucTamThoi = grvData.GetRowCellValue(i, "9").ToString();
//error.Status = grvData.GetRowCellValue(i, "12").ToString().Trim().ToLower() == "ok" ? 1 : 0;
//error.StatusTK = grvData.GetRowCellValue(i, "12").ToString().Trim().ToLower() == "ok" ? 1 : 0;
//error.DepartmentID = department == null ? 0 : department.ID;
//error.DepartmentKPID = departmentKP == null ? 0 : departmentKP.ID;
//error.Reason = grvData.GetRowCellValue(i, "8") == null ? "" : grvData.GetRowCellValue(i, "8").ToString();
//error.UserFindID = userFind == null ? 0 : userFind.ID;
//error.CreatedBy = "thao.nv";
error.UpdatedDate = TextUtils.ToDate(grvData.GetRowCellValue(i, "2").ToString());
error.CreatedDate = TextUtils.ToDate(grvData.GetRowCellValue(i, "2").ToString());
error.CompleteTimeTK = TextUtils.ToDate(grvData.GetRowCellValue(i, "11").ToString());
if (error.ID == 0)
{
error.Code = code;
error.ModuleID = module == null ? 0 : module.ID;
ModuleErrorBO.Instance.Insert(error);
}
else
{
ModuleErrorBO.Instance.Update(error);
}
}
catch (Exception)
{
}
}
MessageBox.Show("Thêm lỗi thành công!");
}
public ActionResult <UsersModel> Create(UsersModel userModel)
{
_service.Create(userModel);
return(CreatedAtRoute("GetUser", new { id = userModel.Id.ToString() }, userModel));
}
public int Register(UsersModel UserLogin)
{
int Id;
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
//DateTime? DOB;
//if (UserLogin.DOB == "")
//{
// DOB = null;
//}
//else {
// DOB = DateTime.ParseExact(UserLogin.DOB, "MM/dd/yyyy", CultureInfo.InvariantCulture);
//}
//DateTime? ExpDate;
//if (UserLogin.ExpDate == "")
//{
// ExpDate = null;
//}
//else
//{
// ExpDate = DateTime.ParseExact(UserLogin.ExpDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
//}
SqlCommand cmd = new SqlCommand("[therapistdb].[SP_Register]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", UserLogin.FirstName);
cmd.Parameters.AddWithValue("@LastName", UserLogin.LastName);
cmd.Parameters.AddWithValue("@Email", UserLogin.Email);
cmd.Parameters.AddWithValue("@Phone", UserLogin.Phone);
cmd.Parameters.AddWithValue("@Password", UserLogin.Password);
cmd.Parameters.AddWithValue("@RefType", UserLogin.RefType);
cmd.Parameters.AddWithValue("@InsuranceNo", UserLogin.InsuranceNo);
cmd.Parameters.AddWithValue("@Age", UserLogin.Age);
cmd.Parameters.AddWithValue("@ExpDate", null);
if (UserLogin.RefType == 1)
{
cmd.Parameters.AddWithValue("@DOB", null);
}
else
{
cmd.Parameters.AddWithValue("@DOB", UserLogin.DOB);
}
//New Field
cmd.Parameters.AddWithValue("@AddrLine1", UserLogin.AddrLine1);
cmd.Parameters.AddWithValue("@AddrLine2", UserLogin.AddrLine2);
cmd.Parameters.AddWithValue("@City", UserLogin.City);
cmd.Parameters.AddWithValue("@State", UserLogin.State);
cmd.Parameters.AddWithValue("@Country", UserLogin.Country);
cmd.Parameters.AddWithValue("@PostalCode", UserLogin.PostalCode);
cmd.Parameters.AddWithValue("@ServiceID", UserLogin.ServiceID);
cmd.Parameters.AddWithValue("@BankDetail", UserLogin.BankDetail);
cmd.Parameters.AddWithValue("@RegistrationNo", UserLogin.RegistrationNo);
cmd.Parameters.AddWithValue("@Skill", UserLogin.Skill);
cmd.Parameters.AddWithValue("@ServiceArea", UserLogin.ServiceArea);
cmd.Parameters.AddWithValue("@Monday", UserLogin.Monday);
cmd.Parameters.AddWithValue("@Tuesday", UserLogin.Tuesday);
cmd.Parameters.AddWithValue("@Wednesday", UserLogin.Wednesday);
cmd.Parameters.AddWithValue("@Thursday", UserLogin.Thursday);
cmd.Parameters.AddWithValue("@Friday", UserLogin.Friday);
cmd.Parameters.AddWithValue("@Saturday", UserLogin.Saturday);
cmd.Parameters.AddWithValue("@Sunday", UserLogin.Sunday);
cmd.Parameters.AddWithValue("@FromTime", UserLogin.FromTime);
cmd.Parameters.AddWithValue("@ToTime", UserLogin.ToTime);
cmd.Parameters.AddWithValue("@Gender", UserLogin.Gender);
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
Id = (int)cmd.Parameters["@id"].Value;
conn.Close();
return(Id);
}
public UsersController()
{
Model = new UsersModel();
}
/// <summary>
/// Run through the OAuth login process to obtain an auth token and secret. Then login using that information and request the user's
/// info to validate credentials
/// </summary>
/// <param name="consumerKey"></param>
/// <param name="consumerSecret"></param>
/// <param name="redirectAction"></param>
/// <param name="oauth_token"></param>
/// <param name="oauth_token_secret"></param>
/// <param name="userInfo"></param>
/// <returns></returns>
public static Client OAuthLogin(string consumerKey, string consumerSecret, Func <Uri, string> redirectAction, out string oauth_token, out string oauth_token_secret, out UsersModel userInfo)
{
var client = new RestClient(ApiUrl);
client.Authenticator = RestSharp.Authenticators.OAuth1Authenticator.ForRequestToken(consumerKey, consumerSecret);
var request = new RestRequest("oauth/request_token", Method.POST);
var response = client.Execute(request);
var qs = HttpUtility.ParseQueryString(response.Content);
oauth_token = qs["oauth_token"];
oauth_token_secret = qs["oauth_token_secret"];
request = new RestRequest("oauth/authenticate");
request.AddParameter("oauth_token", oauth_token);
var uri = new Uri(client.BuildUri(request).ToString());
var verifier = redirectAction(uri);
request = new RestRequest("oauth/access_token", Method.POST);
client.Authenticator = RestSharp.Authenticators.OAuth1Authenticator.ForAccessToken(
consumerKey, consumerSecret, oauth_token, oauth_token_secret, verifier
);
response = client.Execute(request);
qs = HttpUtility.ParseQueryString(response.Content);
oauth_token = qs["oauth_token"];
oauth_token_secret = qs["oauth_token_secret"];
return(OAuthLogin(consumerKey, consumerSecret, oauth_token, oauth_token_secret, out userInfo));
}
/// <summary>
/// SaveUser
/// </summary>
/// <param name="AccountModelDTO"></param>
/// <returns></returns>
public int SaveUser(UsersModel UsersDTO)
{
return(objUsersDAL.SaveUser(UsersDTO));
}
public bool Save(UsersModel user)
{
userDal.Save(userConvert.convertToDal(user));
return true;
}
public void r100Implementation(UsersModel instance)
{
// This is the placeholder for method implementation.
instance.Password = ApplicationMembershipProvider.EncodeUserPassword(instance.Password);
}
private void FillUsersModel(UsersModel model)
{
var users = Execute(() => _accountService.GetUsers(model.SortType, model.Term, model.Pager.PageId, model.Pager.PageSize, CurrentUser.Role));
model.CopyFrom(users);
}
public UsersModel GetUserById(int userId)
{
var userModel = new UsersModel(_userUseCase.GetUserById(userId));
return(userModel);
}
public HomeController()
{
usersModel = new UsersModel();
}
public IHttpActionResult Register(UsersModel model)
{
try
{
if (!ModelState.IsValid)
{
responseData.message = ModelStateErrors(ModelState);
return(Ok(responseData));
}
//DateTime a = DateTime.ParseExact(model.ExpDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
//DateTime b = Convert.ToDateTime(model.DOB);
model.ServiceID = HttpContext.Current.Request.Form["ServiceID"];
model.ServiceArea = HttpContext.Current.Request.Form["ServiceArea"];
RegisterDL obj = new RegisterDL();
int Id = obj.Register(model);
// Upload Files
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count > 0)
{
//string path = HttpContext.Current.Server.MapPath("~/Uploads/" + model.RefType + "_" + Id);
//if (!Directory.Exists(path))
//{
// Directory.CreateDirectory(path);
//}
for (int iCnt = 0; iCnt <= files.Count - 1; iCnt++)
{
System.Web.HttpPostedFile hpf = files[iCnt];
if (hpf != null && !string.IsNullOrEmpty(hpf.FileName))
{
DocumentModel doc = new DocumentModel();
Stream str = hpf.InputStream;
BinaryReader Br = new BinaryReader(str);
//string fileName = RandomString(8) + Path.GetExtension(hpf.FileName);
//string filePath = Path.Combine(path, fileName);
//hpf.SaveAs(filePath);
Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
string base64String = Convert.ToBase64String(FileDet, 0, FileDet.Length);
doc.RefId = Id;
doc.RefType = model.RefType;
//doc.DocPath = filePath;
doc.DocName = hpf.FileName;
doc.FileContent = base64String;
string ext = Path.GetExtension(hpf.FileName).ToUpper();
if (ext == ".PDF")
{
doc.MimeType = "application/pdf";
}
else if (ext == ".JPEG" || ext == ".JPG")
{
doc.MimeType = "image/jpeg";
}
else if (ext == ".PNG")
{
doc.MimeType = "image/png";
}
obj.TransDocument(doc);
}
}
}
;
SendMail mail = new SendMail();
if (model.RefType == 1)
{
string body = mail.createEmailBody("TherapistRegistration.html");
body = body.Replace("{UserName}", model.FirstName + " " + model.LastName);
mail.SendGeneralMail("Therapist Registration", model.Email, body);
}
else
{
string body = mail.createEmailBody("PatientRegistration.html");
body = body.Replace("{UserName}", model.FirstName + " " + model.LastName);
mail.SendGeneralMail("Patient Registration", model.Email, body);
}
responseData.success = true;
responseData.message = "Register successfully.";
responseData.code = (int)HttpStatusCode.Created;
return(Ok(responseData));
}
catch (Exception ex)
{
responseData.message = ex.Message != null?ex.Message.ToString() : "server error";
return(Ok(responseData));
}
}
public string Post([FromBody] UsersModel IncomingUsers)
{
return(Create.CreateUsers(IncomingUsers));
}
/// <summary>
/// Create a Client object with OAuth crednetials and a request the user's info to validate credentials
/// </summary>
/// <param name="consumerKey"></param>
/// <param name="consumerSecret"></param>
/// <param name="oauth_token"></param>
/// <param name="oauth_token_secret"></param>
/// <param name="userInfo"></param>
/// <returns></returns>
public static Client OAuthLogin(string consumerKey, string consumerSecret, string oauth_token, string oauth_token_secret, out UsersModel userInfo)
{
var client = new Client(consumerKey, consumerSecret, oauth_token, oauth_token_secret);
userInfo = client.Account.GetInfo();
client.Username = userInfo.User.Username;
return(client);
}
public XmlProvider(String src, UsersModel user)
{
CurrentUser = user;
SourcePath = src;
CachedTags = new HashSet <String>();
}
public ActionResult Add(UsersModel user, HttpPostedFileBase image)
{
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
string query = @"INSERT INTO Users VALUES (@Username, @Password, @FirstName, @LastName, @EmailAddress,
@ContactNo,@Image,@Birthdate, @DateCreated) ";
using (SqlCommand cmd = new SqlCommand(query, con))
{
string imageFile = user.Image;
cmd.Parameters.AddWithValue("@Username", user.Username);
cmd.Parameters.AddWithValue("@Password", user.Password);
cmd.Parameters.AddWithValue("@Firstname", user.FirstName);
cmd.Parameters.AddWithValue("@Lastname", user.LastName);
cmd.Parameters.AddWithValue("@EmailAddress", user.EmailAddress);
cmd.Parameters.AddWithValue("@ContactNo", user.ContactNo);
double a;
string c = imageFile;
if (imageFile != null)
{
imageFile = DateTime.Now.ToString("yyyyMMddHHmmss-") + image.FileName;
cmd.Parameters.AddWithValue("@Image", imageFile);
image.SaveAs(Server.MapPath("~/Images/Users/" + imageFile));
}
else
{
imageFile = "user-default.png";
cmd.Parameters.AddWithValue("@Image", imageFile);
}
cmd.Parameters.AddWithValue("@Birthdate", user.Birthdate);
cmd.Parameters.AddWithValue("@DateCreated", DateTime.Now);
cmd.ExecuteNonQuery();
UserLogin.UserID = user.UserID;
/*ADDED*/
UserLogin.FN = user.FirstName;
UserLogin.LN = user.LastName;
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(user.EmailAddress);
mail.Subject = "Foodies Registration";
mail.Body = "Thank you " + user.LastName + ", " + user.FirstName + " for creating an account in Foodies.com. ";
mail.IsBodyHtml = true;
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "alec12345");
SmtpServer.Port = 587;
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
return(RedirectToAction("Index", "Recipe"));
}
}
}
public AdministrationModel()
{
UsersModel = new UsersModel();
UserRolesModel = new UserRolesModel();
}
