internal int InsertRecord(string FirstName, string LastName, string Email, string Password)
{
UsersDataContext dc = new UsersDataContext();
Users ObjTable;
ObjTable = new Users();
dataContext.Users.InsertOnSubmit(ObjTable);
try
{
#region Save Controls
ObjTable.FirstName = FirstName;
ObjTable.LastName = LastName;
ObjTable.Password = Tools.Encode(Password);
ObjTable.Email = Email;
ObjTable.Active = true;
ObjTable.HCGenderCode = HCGenderCode;
#endregion
dataContext.SubmitChanges();
}
catch (Exception exp)
{
return(-1);
}
return(ObjTable.Code);
}
public JsonResult SaveUserProfileJSON(string OldUserName, string UserNameEmail, bool Inactive)
{
MembershipUser mu = Provider.GetUser(OldUserName, false);
//Check to see if the old and new names are the same
if (OldUserName != UserNameEmail)
{
if (Membership.GetUser(UserNameEmail) != null)
{
return(new JsonResult {
Data = new { success = false, error = "New User Name / Email already exists!" }
});
}
mu.Email = UserNameEmail;
mu.IsApproved = !Inactive;
Membership.UpdateUser(mu);
UsersDataContext dc = new UsersDataContext();
dc.S1_Users_ModifyUserName(OldUserName, UserNameEmail);
return(new JsonResult {
Data = new { success = true, error = "User Name / Email changed!" }
});
}
mu.IsApproved = !Inactive;
Membership.UpdateUser(mu);
//The names are the same, no change required
return(new JsonResult {
Data = new { success = true, error = "Changes Saved!" }
});
}
public IQueryable <vRandUserADSs> GetRandAds(int?TakeCount)
{
UsersDataContext dc = new UsersDataContext();
IQueryable <vRandUserADSs> Result;
if (TakeCount != null)
{
Result = dc.vRandUserADSses.Take((int)TakeCount);
}
else
{
Result = dc.vRandUserADSses;
}
string CodeList = "";
foreach (var item in Result)
{
if (CodeList == "")
{
CodeList = item.Code.ToString();
}
else
{
CodeList = CodeList + "," + item.Code;
}
}
//if(CodeList != "")
// dataContext.spUpdateUserADSViewNum(CodeList);
return(Result);
}
/*
* public static ATS_ClientSettings_GetClientFromClientIDResult GetClientInfo(int ClientID)
* {
* var db = new ClientsDataContext();
* var result = db.ATS_ClientSettings_GetClientFromClientID(ClientID).SingleOrDefault();
*
* return result;
* }
*/
public static List <ScreeningONE.Models.Users.S1_Users_GetClientUsersResult> GetClientUsers(int clientid)
{
var db = new UsersDataContext();
var result = db.S1_Users_GetClientUsers(clientid);
return(result.ToList());
}
public static S1_Users_GetUserFromUserIDResult GetUserFromUserID(int userid)
{
using (UsersDataContext dc = new UsersDataContext())
{
return(dc.S1_Users_GetUserFromUserID(userid).FirstOrDefault());
}
}
public Users GetUserByID(string ID)
{
UsersDataContext dc = new UsersDataContext();
Users CurUser = dc.Users.SingleOrDefault(p => p.ID.Equals(ID));
return(CurUser);
}
public static int GetUniqueUserCount()
{
UsersDataContext dc = Configuration.GetUsersDataContext();
return((from c in dc.UniqueUsers
select c).Count());
}
public ActionResult ChangePass(string id)
{
Account_ChangePass viewChangePass = new Account_ChangePass();
viewChangePass.ShowFieldSet = true;
if (String.IsNullOrEmpty(id))
{
ViewData.ModelState.AddModelError("*", "There was an error processing this request. Please refresh and try again.");
viewChangePass.ShowFieldSet = false;
ViewData["Title"] = "Change Password - Failed";
}
else
{
var db = new UsersDataContext();
var username = db.S1_Users_ForgotPassword_GetUserName(id);
if (username == null)
{
ViewData.ModelState.AddModelError("*", "The user name could not be located. Please refresh and try again.");
viewChangePass.ShowFieldSet = false;
ViewData["Title"] = "Change Password - Failed";
}
else
{
ViewData["Title"] = "Change Password";
}
}
return View("ChangePass", "~/Views/Shared/Site.Master", viewChangePass);
}
public bool SendEmailToFriends(int UserCode, string[] EmailArray)
{
try
{
bool AllSuccess = true;
string CurEmail = "";
Tools tools = new Tools();
UsersDataContext dcUser = new UsersDataContext();
for (int i = 0; i < EmailArray.Length; i++)
{
CurEmail = EmailArray[i].Trim();
if (IsValidEmail(CurEmail))
{
vActiveUsers ExistingUser = dcUser.vActiveUsers.SingleOrDefault(p => p.Email.Equals(CurEmail));
if (ExistingUser == null)
{
string RandKey = tools.GetRandString(50);
Invitations NewInvitation = dcUser.Invitations.SingleOrDefault(p => p.Email.Equals(CurEmail) && p.EmailRemoved.Equals(true));
if (NewInvitation == null)
{
#region Send email
NewInvitation = new Invitations();
NewInvitation.InviterUserCode = UserCode;
NewInvitation.Email = CurEmail;
NewInvitation.GenKey = RandKey;
NewInvitation.HCInvitationsStatusCode = 1;//Invitation sent
NewInvitation.EmailRemoved = false;
NewInvitation.SendDate = DateTime.Now;
dcUser.Invitations.InsertOnSubmit(NewInvitation);
dcUser.SubmitChanges();
EmailTools emailTools = new EmailTools();
Users CurUser = dcUser.Users.SingleOrDefault(p => p.Code.Equals(UserCode));
bool SendResult = emailTools.SendInvitationMessage(CurUser, CurEmail);
if (!SendResult)
{
if (AllSuccess)
{
AllSuccess = false;
}
}
#endregion
}
}
else
{
Users FromUser = dcUser.Users.SingleOrDefault(p => p.Code.Equals(UserCode));
Users ToUser = dcUser.Users.SingleOrDefault(p => p.Code.Equals(ExistingUser.Code));
BOLUserMessages UserMessagesBOL = new BOLUserMessages();
UserMessagesBOL.SendAddFriendMessage(FromUser, ToUser, "");
}
}
}
return(AllSuccess);
}
catch
{
return(false);
}
}
protected void btnSendComment_Click(object sender, EventArgs e)
{
UtilDataContext dc = new UtilDataContext();
UserItemComments NewComment = new UserItemComments();
dc.UserItemComments.InsertOnSubmit(NewComment);
NewComment.ItemCode = _itemCode;
NewComment.UserCode = UserCode;
NewComment.HCItemTypeCode = _hCItemTypeCode;
NewComment.Comment = txtComment.Text;
NewComment.CommentDate = DateTime.Now;
NewComment.ID = Tools.GetRandID();
dc.SubmitChanges();
txtComment.Text = "";
string SiteDomain = ConfigurationSettings.AppSettings["SiteDomain"];
if (_hCItemTypeCode == 3)//Photos
{
UsersDataContext dcUser = new UsersDataContext();
Users OwnerUser = dcUser.Users.SingleOrDefault(p => p.Code.Equals(_ownerUserCode));
string OwnerUserFullName = OwnerUser.FirstName + " " + OwnerUser.LastName;
if (OwnerUser != null)
{
}
BOLUserActions UserActionsBOL = new BOLUserActions();
UserActionsBOL.NewAction(UserCode, "<a href='" + SiteDomain + "Users/Profile.aspx?ID=" + Session["UserID"] + "'>" + Session["FirstName"] + " " + Session["LastName"] + "</a> نظر جدیدی روی عکس <a href='" + SiteDomain + "Users/Profile.aspx?ID=" + OwnerUser.ID + "'>" + OwnerUserFullName + "</a> <a href='Users/ShowPhoto.aspx?ID=" + _params + "'>" + " ارسال کرده است.</a>", 7);
}
LoadComments(rptComments, _itemCode);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
IQueryable <vRandUsers> Result;
HttpContext context = HttpContext.Current;
if (context.Cache["RandUsers"] == null)
{
UsersDataContext dc = new UsersDataContext();
Result = dc.vRandUsers.Take(_randNum);
context.Cache.Insert("RandUsers", Result, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero);
}
Result = (IQueryable <vRandUsers>)context.Cache["RandUsers"];
dtlUsers.DataSource = Result;
dtlUsers.DataBind();
}
catch (Exception err)
{
BOLErrorLogs ErrorLogsBOL = new BOLErrorLogs();
ErrorLogsBOL.Insert(err.Message, DateTime.Now, Request.Url.AbsolutePath, "UCRandUsers::Load");
}
}
protected void Session_End(object sender, EventArgs e)
{
Session.Remove("lanDangNhap");
UsersDataContext db = new UsersDataContext();
db.sp_SetOffline(Session.GetCurrentUserID());
Session.RemoveAll();
}
public ActionResult Songs()
{
UsersDataContext loUserContext = new UsersDataContext();
List <SongsModel> loSongData = new List <SongsModel>();
loSongData = loUserContext.GetSongs();
return(View(loSongData));
}
public ControllerTestsBase(IntegrationContainersAppFactory integrationContainersFixture)
{
Client = integrationContainersFixture.Client;
_scope = integrationContainersFixture.Server.Host.Services.CreateScope();
_connectionString = integrationContainersFixture.ConnectionString;
_checkpoint = new Checkpoint();
Context = _scope.ServiceProvider.GetRequiredService <UsersDataContext>();
}
//
protected void btnSend_Click(object sender, EventArgs e)
{
string Subject = txtSubject.Text;
string MailBody = txtMailBody.Content;
if (string.IsNullOrEmpty(Subject))
{
msgBox.MessageTextMode = AKP.Web.Controls.Common.MessageMode.Error;
msgBox.Text = "لطفا عنوان ایمیل ر وارد کنید";
return;
}
if (string.IsNullOrEmpty(MailBody))
{
msgBox.MessageTextMode = AKP.Web.Controls.Common.MessageMode.Error;
msgBox.Text = "لطفا متن ایمیل ر وارد کنید";
return;
}
Tools tools = new Tools();
UsersDataContext dc = new UsersDataContext();
var Result = (from p in dc.Users
select new { p.Email }
).Distinct();
int Counter = 0;
int SuccessSent = 0;
string BCCList = "";
foreach (var item in Result)
{
Counter++;
string CurEmail = item.Email;
if (Counter % 50 != 0)
{
if (BCCList == "")
{
BCCList = CurEmail;
}
else
{
BCCList += "," + CurEmail;
}
}
else
{
bool SendResult = tools.SendMessageWithAttachment(MailBody, Subject, "*****@*****.**", CurEmail, BCCList, "", "");
if (SendResult)
{
SuccessSent += 50;
}
BCCList = "";
}
}
msgBox.Text = SuccessSent + " ایمیل با موفقیت ارسال شد";
}
public ActionResult CurrentUser()
{
if (Request.IsAuthenticated == false)
return View();
var dc = new UsersDataContext();
var user = dc.Users.First(x => x.USER_NAME == HttpContext.User.Identity.Name);
ViewBag.UserName = user.USER_FULL_NAME;
return View();
}
protected void Page_Load(object sender, EventArgs e)
{
if (ToUserCode != 0)
{
UsersDataContext dc = new UsersDataContext();
Users ToUser = dc.Users.SingleOrDefault(p => p.Code.Equals(ToUserCode));
ltrHeader.Text = "ارسال تقاضای دوستی برای " + ToUser.FirstName + " " + ToUser.LastName;
}
}
public ActionResult ConfirmEmail(string id, string portal, string ClientID, string ReturnURL)
{
Guid actionguid = new Guid();
try
{
actionguid = new Guid(id);
}
catch (FormatException)
{
ViewData.ModelState.AddModelError("emailSuccess", "The link you used to navigate to this page is not valid.");
}
if (String.IsNullOrEmpty(id))
{
ViewData.ModelState.AddModelError("emailSuccess", "The link you used to navigate to this page is no longer valid.");
}
if (ViewData.ModelState.IsValid)
{
var db = new UsersDataContext();
var result = db.S1_Users_VerifyEmail(id).SingleOrDefault();
if (result != null)
{
if (result.IsActive == 0)
{
var db2 = new UsersDataContext();
var result2 = db.S1_Users_InactivateMessageAction(actionguid);
if (result2 >= 0)
{
ViewData["ReturnUrl"] = result.MessageActionPath + "?UserName="******"emailSuccess"] = "Your account has been activated! You will be redirected automatically in about 5 seconds...";
}
}
else
{
ViewData["ReturnUrl"] = result.MessageActionPath;
ViewData.ModelState.AddModelError("emailSuccess", "This account has already been activated.");
}
}
else
{
ViewData.ModelState.AddModelError("emailSuccess", "The link you used to navigate to this page is no longer valid.");
}
}
return View();
}
public static UsersDataContext GetUsersDataContext()
{
UsersDataContext dc = new UsersDataContext(ConnectionString);
dc.DeferredLoadingEnabled = false;
dc.ObjectTrackingEnabled = false;
return(dc);
}
public IQueryable <Resources> GetByMasterCode(int MasterCode)
{
UsersDataContext dataContext = new UsersDataContext();
var Result = from p in dataContext.Resources
where p.MasterCode.Equals(MasterCode)
select p;
return(Result);
}
protected void setMaDonVi1(object sender, EventArgs e)
{
txtNamSuDung.Text = "2018";
txtTenDangNhap.Text = "banqldatambinh1";
AjaxPro.Utility.RegisterTypeForAjax(typeof(ProOnline._Default));
Session.SetConnectionString2(txtConn.Text);
Session.SetConnectionString1(@"Data Source=.\SQLEXPRESS;Initial Catalog=UserProOnline_laptrinh;Integrated Security=True");
Session.SetConnectionString2(@"Data Source=.\SQLEXPRESS;Initial Catalog=ProOnline_laptrinh2016;Integrated Security=True");
//Session.SetConnectionString2(@"Data Source=115.79.35.88;Initial Catalog=ProOnline_LT2016;User ID=laptrinh;Password=@Laptrinh@123");
//Session.SetConnectionString1(@"Data Source=115.79.35.88;Initial Catalog=UserProOnline_LT;User ID=laptrinh;Password=@Laptrinh@123");
SqlFunction sqlFun = new SqlFunction(Session.GetConnectionString1());
UsersDataContext db = new UsersDataContext();
SqlFunction _vSql = new SqlFunction(Session.GetConnectionString2());
IQueryable <tblDMDonvi> tblDMDonVi = from tdbDvi in db.tblDMDonvis
where tdbDvi.maDonVi.ToLower() == sqlFun.GetOneStringField("SELECT CONVERT(nvarchar(18), maDonVipr_sd) FROM tblUsers WHERE tenDangNhap=N'" + txtTenDangNhap.Text + "'") //"94000083"//"94000087" //
select tdbDvi;
tblDMDonvi _vdbDonVi = tblDMDonVi.FirstOrDefault();
Session.SetDonVi(_vdbDonVi);
Session.SetDonViCapTren("Đơn vị cấp trên");
Session.SetHienNgayInBC(true);
Session.SetNgayInBC("01/01/" + (txtNamSuDung.Text == "" ? DateTime.Now.Year.ToString() : txtNamSuDung.Text));
Session.SetMaChuong("1");
Session.SetDiaDanh("Vĩnh Long");
tblUser _vuser = new tblUser();
_vuser.ngayThaotac = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
_vuser.nguoiThaoTac = sqlFun.GetOneDecimalField("SELECT CONVERT(dec(18,0), maNguoidungpr) FROM tblUsers WHERE tenDangNhap=N'" + txtTenDangNhap.Text + "'");
_vuser.maNguoidungpr = sqlFun.GetOneDecimalField("SELECT CONVERT(dec(18,0), maNguoidungpr) FROM tblUsers WHERE tenDangNhap=N'" + txtTenDangNhap.Text + "'");
_vuser.tenDangNhap = txtTenDangNhap.Text;
//_vuser.sttNhanVienpr_sd = sqlFun.GetOneDecimalField("SELECT CONVERT(dec(18,0), sttNhanVienpr_sd) FROM tblUsers WHERE tenDangNhap=N'" + txtTenDangNhap.Text + "'");
_vuser.sttPhongBanpr_sd = sqlFun.GetOneDecimalField("SELECT CONVERT(dec(18,0), sttPhongBanpr_sd) FROM tblUsers WHERE tenDangNhap=N'" + txtTenDangNhap.Text + "'");
_vuser.idGrouppr_sd = sqlFun.GetOneStringField("SELECT CONVERT(nvarchar(250), idGrouppr_sd) FROM tblUsers WHERE tenDangNhap=N'" + txtTenDangNhap.Text + "'");
Session.SetCurrentUser(_vuser);
Session.SetNgayDauKy("01/01/" + (txtNamSuDung.Text == "" ? DateTime.Now.Year.ToString() : txtNamSuDung.Text));
Session.SetNgayCuoiKy("31/12/" + (txtNamSuDung.Text == "" ? DateTime.Now.Year.ToString() : txtNamSuDung.Text));
Session.SetCurrentDatetime(new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day));
Session.setNamSudung((txtNamSuDung.Text == "" ? DateTime.Now.Year.ToString() : txtNamSuDung.Text));
try
{
Session.SetTenDonVi("Tên đơn vị báo cáo");
txtConn.Text = @"Data Source=.\SQLEXPRESS;Initial Catalog=UserProOnline_laptrinh;Integrated Security=True";
txtTenDangNhap.Text = HttpContext.Current.Session.GetCurrentUser().tenDangNhap;
txtNamSuDung.Text = DateTime.Now.Year.ToString();
value.InnerText = HttpContext.Current.Session.GetDonVi().maDonVi + " Năm thao tác " + HttpContext.Current.Session.GetNamSudung() + "</br>";
value.InnerText += Session.GetConnectionString2().ToString();
Response.Redirect("/quanly/thanhly_moi.aspx");
}
catch
{
value.InnerText = "Chưa cấp session";
}
}
public void ActivateUser(int Code)
{
UsersDataContext dc = new UsersDataContext();
Users CurUser = dc.Users.SingleOrDefault(p => p.Code.Equals(Code));
if (CurUser != null)
{
CurUser.Active = true;
dc.SubmitChanges();
}
}
public DataTable GetGroupNameByUserCode(int userCode)
{
UsersDataContext dc = new UsersDataContext();
var ListResult = from p in dc.vUserGroups
where p.UserCode.Equals(userCode)
select p;
DataTable dt = new Converter <vUserGroups>().ToDataTable(ListResult);
return(dt);
}
DataTable IBaseBOL.GetDataSource(SearchFilterCollection sFilterCols, string SortString, int PageSize, int CurrentPage)
{
dataContext = new UsersDataContext();
string WhereCond = Tools.GetCondition(sFilterCols);
var ListResult = from v in dataContext.Resources
where !v.MasterCode.HasValue //|| v.TypeCode.Equals(2) || v.TypeCode.Equals(3) || v.TypeCode.Equals(4)
select v;
DataTable dt = new Converter <Resources>().ToDataTable(ListResult);
return(dt);
}
public DataTable GetNodeData(int NodeValue)
{
UsersDataContext dataContext = new UsersDataContext();
//string WhereCond = Tools.GetCondition(sFilterCols);
var ListResult = from v in dataContext.Resources
where v.MasterCode.Equals(NodeValue)
select v;
DataTable dt = new Converter <Resources>().ToDataTable(ListResult);
return(dt);
}
public DataTable GetAllFieldExcpetFields()
{
UsersDataContext dataContext = new UsersDataContext();
DataTable dt = new DataTable();
var ListResult = from r in dataContext.Resources
where (!r.HCResourceTypeCode.Equals(3))
select r;
ListResult = ListResult.OrderBy(p => p.Name);
dt = new Converter <Resources>().ToDataTable(ListResult);
return(dt);
}
public int ShowMutualFriends(int UserCode, int FriendCode)
{
UsersDataContext dc = new UsersDataContext();
ConcatUrl = "&Keyword=" + Keyword;
int ResultCount = 0;
int SkipCount = PageSize * (PageNo - 1);
System.Data.Linq.ISingleResult <spGetMutualFriendsResult> ItemList;
int LoggedUserCode = Convert.ToInt32(Session["UserCode"]);
ItemList = dc.spGetMutualFriends(UserCode, FriendCode);
ResultCount = dc.vUserFriends.Where(p => p.UserCode.Equals(UserCode)).Skip(SkipCount).Count();
rptItems.DataSource = ItemList;
rptItems.DataBind();
if (rptItems.Items.Count > 0)
{
string Message = "";
if (rptItems.Items.Count >= 500)
{
Message = " بیشتر از 500 " + " نتیجه برای <b>" + Keyword + " پیدا شد </b> ";
}
else
{
Message = ResultCount + " نتیجه برای <b>" + Keyword + " پیدا شد </b>";
}
//msgBox.Text = Message;
Page.Title = "دوستان مشترک:" + " سفحه " + PageNo;
lblPageTitle.Text = "دوستان مشترک";
int PageCount = ResultCount / PageSize;
if (ResultCount % PageSize > 0)
{
PageCount++;
}
pgrToolbar.PageNo = PageNo;
pgrToolbar.PageCount = PageCount;
pgrToolbar.ConcatUrl = ConcatUrl;
pgrToolbar.PageBind();
}
else
{
//msgBox.Text = " No results found for <b>" + Keyword + "</b>";
}
return(ResultCount);
}
public bool SendAddFriendMessage(Users FromUser, Users ToUser)
{
bool SendResult = false;
if (Tools.GetValue(ToUser.IAddMeAsFriend))
{
UtilDataContext dcUtil = new UtilDataContext();
UsersDataContext dcUser = new UsersDataContext();
EmailTemplates CurTemplate = dcUtil.EmailTemplates.SingleOrDefault(p => p.Title.Equals("AddFriend"));
if (CurTemplate != null)
{
string UserImageUrl;
string SiteDomain = ConfigurationSettings.AppSettings["SiteDomain"];
Tools tools = new Tools();
string MsgBody = CurTemplate.Template;
string MessageUrl = SiteDomain + "Default.aspx?AF=1";
if (FromUser.PicFile == null || FromUser.PicFile == "")
{
UserImageUrl = SiteDomain + "Files/Users/man_icon.gif";
}
else
{
UserImageUrl = SiteDomain + "Files/Users/" + FromUser.PicFile;
}
string RemoveEmailUrl = SiteDomain + "Users/Setting.aspx";
if (CurTemplate != null)
{
int FriendCount = dcUser.UserFriends.Where(p => p.UserCode.Equals(FromUser.Code)).Count();
int PhotoCount = dcUser.vUserAlbumPhotos.Where(p => p.UserCode.Equals(FromUser.Code)).Count();
MsgBody = CurTemplate.Template;
MsgBody = MsgBody.Replace("[UserFullName]", FromUser.FirstName + " " + FromUser.LastName);
MsgBody = MsgBody.Replace("[UserFirstName]", FromUser.FirstName);
MsgBody = MsgBody.Replace("[UserEmail]", FromUser.Email);
MsgBody = MsgBody.Replace("[MessageUrl]", MessageUrl);
MsgBody = MsgBody.Replace("[RecFirstName]", ToUser.FirstName);
MsgBody = MsgBody.Replace("[UserUrl]", SiteDomain + "Users/Profile.aspx?ID=" + FromUser.ID);
MsgBody = MsgBody.Replace("[ImageUrl]", UserImageUrl);
MsgBody = MsgBody.Replace("[RemoveEmailUrl]", RemoveEmailUrl);
MsgBody = MsgBody.Replace("[FriendCount]", FriendCount.ToString());
MsgBody = MsgBody.Replace("[PhotoCount]", PhotoCount.ToString());
}
string MsgSubject = FromUser.FirstName + " " + FromUser.LastName + " تقاضای دوستی با شما را دارد";
SendResult = tools.SendEmail(MsgBody, MsgSubject, "*****@*****.**", ToUser.Email, "", "");
BOLEmails EmailsBOL = new BOLEmails();
EmailsBOL.Insert(ToUser.Email, 3, MsgBody);
}
}
return(SendResult);
}
internal static void UpdateLastLoginTime(int Code)
{
try
{
UsersDataContext dc = new UsersDataContext();
Users CurUser = dc.Users.SingleOrDefault(p => p.Code.Equals(Code));
CurUser.LastLoginTime = DateTime.Now;
dc.SubmitChanges();
}
catch
{
}
}
public void GetAccess(int AccessType, int GroupCode, int MasterCode)
{
int ResourceCode;
UsersDataContext dataContext = new UsersDataContext();
var Result = dataContext.sp_GetMultipleAccess(AccessType, GroupCode, MasterCode);
var ListResult = dataContext.ExecuteQuery <GroupResources>(string.Format("exec sp_GetMultipleAccess '{0}','{1}','{2}'", AccessType, GroupCode, MasterCode));
foreach (var r in ListResult)
{
ResourceCode = (int)((GroupResources)r).ResourceCode;
GetAccess(AccessType, GroupCode, ResourceCode);
}
}
public void NewAction(int UserCode, string Comment, int HCActionTypeCode)
{
UsersDataContext dc = new UsersDataContext();
UserActions NewAction = new UserActions();
dc.UserActions.InsertOnSubmit(NewAction);
NewAction.UserCode = UserCode;
NewAction.HCActionTypeCode = HCActionTypeCode;
NewAction.Comment = Comment;
NewAction.ID = Tools.GetRandID();
NewAction.ActionDate = DateTime.Now;
dc.SubmitChanges();
}
public ActionResult Login(LoginInput input)
{
var dc = new UsersDataContext();
var user = dc.Users.FirstOrDefault(x => x.USER_NAME == input.Email);
dc.Dispose();
if (user == null || GetPasswordHash(input.Email, input.Password) != user.PSWHASH)
{
ModelState.AddModelError("UserNotExistOrPasswordNotMatch", "მომხმარებლის სახელი ან პაროლი არ ემთხვევა");
}
if (ModelState.IsValid)
{
FormsAuthentication.SetAuthCookie(input.Email, createPersistentCookie: false);
return RedirectFromLoginPage(input.ReturnUrl);
}
return View(new LoginInput { Email = input.Email, ReturnUrl = input.ReturnUrl });
}
public bool SaveUserInfo(string Email, int role, string FirstName, string LastName, string Country, string State, string Add1, string Add2, string serial, string Cellphone, string Phone1, string Phone2)
{
DAL.LoginModelDataContext createuser = new DAL.LoginModelDataContext();
DAL.User user = new User();
DAL.UsersDataContext userdata = new UsersDataContext();
Helpers.Login_Security sec = new Helpers.Login_Security();
Helpers.EmailSender sender = new Helpers.EmailSender();
if (EmailExists(Email))
{
return false;
}
else
{
string salt = "TempSalt";
string clearpass = sec.RandomString();
string hashedpassword = sec.hashPass(salt, clearpass);
user.Email = Email;
user.FirstName = FirstName;
user.LastName = LastName;
user.Country = Country;
user.State_Province = State;
user.Address1 = Add1;
user.Address2 = Add2;
user.Salt = salt;
user.RoleID = role;
user.HashedPassword = hashedpassword;
user.SerialNumber = serial;
user.Cellphone = Cellphone;
user.Phone1 = Phone1;
user.Phone2 = Phone2;
try
{
createuser.Users.InsertOnSubmit(user);
createuser.SubmitChanges();
sender.UserCreate(Email, clearpass, serial);
return true;
}
catch (Exception)
{
return false;
}
}
}
