/// <summary>
/// Get user details
/// </summary>
/// <returns></returns>
public UserInfoViewModel oGetUserDetails(int nUserID)
{
UserInfoViewModel oUserInfoViewModel = new UserInfoViewModel();
#region ":DBParamters:"
List <DbParameter> arrParameters = new List <DbParameter>();
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_ApplicationId", SqlDbType.Int, -99, ParameterDirection.Input));
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserId", SqlDbType.Int, nUserID, ParameterDirection.Input));
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserType", SqlDbType.Int, -99, ParameterDirection.Input));
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserSearch", SqlDbType.VarChar, string.Empty, 100, ParameterDirection.Input));
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_PageNumber", SqlDbType.Int, 1, ParameterDirection.Input));
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_RowspPage", SqlDbType.Int, 1, ParameterDirection.Input));
#endregion
#region ":Get Sp Result:"
List <UserInfoViewModel> lstUsers = this.ExecuteStoredProcedureList <UserInfoViewModel>("GetApplicationUsers", arrParameters.ToArray());
if (lstUsers.Count == 1)
{
oUserInfoViewModel = lstUsers[0];
enumUserType oEnmUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUserInfoViewModel.USER_TYPE_ID.ToString(), true);
oUserInfoViewModel.UserType = oEnmUserType;
}
return(oUserInfoViewModel);
#endregion
}
public JsonResult JInsertUser(UserInfoViewModel oUserInfoViewModel)
{
Response oResponseResult = null;
oUserInfoViewModel.APPLICATION_ID = CurrentApplicationID;
enumUserType oUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUserInfoViewModel.USER_TYPE_ID.ToString());
if (oUserType == enumUserType.Staff)
{
oUserInfoViewModel.PASSWORD = CommonHelper.sGetConfigKeyValue(ConstantNames.DefaultUserAccountPassword);
}
oUserInfoViewModel.CREATED_BY = Convert.ToInt32(CurrentUser.nUserID);
oResponseResult = this.oIUserServicesService.oInsertUser(oUserInfoViewModel);
this.OperationResult = oResponseResult.OperationResult;
switch (this.OperationResult)
{
case enumOperationResult.Success:
this.OperationResultMessages = CommonResx.MessageEditSuccess;
break;
case enumOperationResult.Faild:
this.OperationResultMessages = CommonResx.MessageEditFailed;
break;
}
return(Json(
new
{
nResult = this.OperationResult,
sResultMessages = this.OperationResultMessages
},
JsonRequestBehavior.AllowGet));
}
//public static bool RejectDelete(string tableName)
//{
// Update();
// return RejectDeleteTables.Contains(tableName);
//}
public static bool CheckUserPass(string user, string pass, out enumUserType type)
{
Update();
type = enumUserType.Unknown;
Dictionary <string, string> temp;
if (Users.ContainsKey(user))
{
temp = Users;
type = enumUserType.Users;
}
else if (Admins.ContainsKey(user))
{
temp = Admins;
type = enumUserType.Admins;
}
else if (Developers.ContainsKey(user))
{
temp = Developers;
type = enumUserType.Developers;
}
else
{
return(false);
}
if (temp[user] != pass)
{
type = enumUserType.Unknown; return(false);
}
return(true);
}
public User oGetCurrentUser()
{
if (this.DBConnectionString.Trim().Equals(string.Empty))
{
throw new Exception("The DBConnectionString property is not set");
}
this.OperationResult = 0;
this.oDBConnector = new DBConnector(this.DBConnectionString);
User oUser = null;
if (this.oDBConnector != null)
{
this.oDBConnector.AddInParam("@UserName", this.sUserName, DBTypes.VarChar);
this.oDBConnector.AddInParam("@Password", this.sPassword, DBTypes.VarChar);
try
{
this.oDBConnector.Open();
IDataReader oReader = this.oDBConnector.ReadDbWithStoredProcedureDataReader("UserLogin");
if (oReader != null)
{
while (oReader.Read())
{
oUser = new User();
oUser.nUserID = oReader.FieldExists("ID") ? Convert.ToInt32(oReader["ID"]) : -99;
oUser.sUserName = oReader.FieldExists("USER_NAME") ? oReader["USER_NAME"].ToString() : string.Empty;
oUser.sUserTypeName = oReader.FieldExists("USER_TYPE_NAME") ? oReader["USER_TYPE_NAME"].ToString() : string.Empty;
oUser.sUserFullNameEnglish = oReader.FieldExists("FULL_NAME") ? oReader["FULL_NAME"].ToString() : string.Empty;
oUser.sUserTypeIDs = oReader.FieldExists("USER_TYPE_ID") ? oReader["USER_TYPE_ID"].ToString() : string.Empty;
oUser.CurrentApplicationID = oReader.FieldExists("APPLICATION_ID") ? Convert.ToInt32(oReader["APPLICATION_ID"].ToString()) : -99;
oUser.CurrentApplicationOneSignalID = oReader.FieldExists("ONE_SIGNAL_APP_ID") ? oReader["ONE_SIGNAL_APP_ID"].ToString() : string.Empty;
oUser.CurrentApplicationOneSignalAuthKey = oReader.FieldExists("ONE_SIGNAL_AUTH_KEY") ? oReader["ONE_SIGNAL_AUTH_KEY"].ToString() : string.Empty;
enumUserType oEnmUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUser.sUserTypeIDs.ToString(), true);
oUser.UserType = oEnmUserType;
}
this.OperationResult = 1;
}
}
catch
{
oUser = null;
this.OperationResult = 0;
}
finally
{
if (this.oDBConnector != null)
{
this.oDBConnector.Close();
}
}
}
return(oUser);
}
/// <summary>
/// Get user details
/// </summary>
/// <returns></returns>
public UserInfoViewModel oGetUserDetails(int nUserID, int nLanguageID)
{
UserInfoViewModel oUserInfoViewModel = new UserInfoViewModel();
#region ":DBParamters:"
List <DbParameter> arrParameters = new List <DbParameter>();
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserId", SqlDbType.Int, nUserID, ParameterDirection.Input));
arrParameters.Add(CustomDbParameter.BuildParameter("Pin_LanguageId", SqlDbType.Int, nLanguageID, ParameterDirection.Input));
#endregion
#region ":Get Sp Result:"
List <UserInfoViewModel> lstUsers = this.ExecuteStoredProcedureList <UserInfoViewModel>("GetUserDetails", arrParameters.ToArray());
if (lstUsers.Count == 1)
{
oUserInfoViewModel = lstUsers[0];
enumUserType oEnmUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUserInfoViewModel.USER_TYPE_ID.ToString(), true);
oUserInfoViewModel.UserType = oEnmUserType;
}
return(oUserInfoViewModel);
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
object usertime = Session["user"];
object currentuser = Session["currentuser"];
object usertype = Session["usertype"];
#region HANDLE USER
if (usertime == null || usertype == null || currentuser == null)
{
Session.Add("user", DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"));
Response.Redirect("~/login.aspx");
return;
}
if ((string)currentuser == "Unknown")
{
Session["usertype"] = null; Session["currentuser"] = null; Response.Redirect("~/login.aspx");
}
DateTime now = DateTime.UtcNow.AddDays(-1);
if (!DateTime.TryParseExact((string)usertime, "yyyy-MM-dd HH:mm:00", null, System.Globalization.DateTimeStyles.AssumeUniversal, out now))
{
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
Response.Redirect("~/login.aspx");
return;
}
if (now.AddMinutes(UtilsConfig.SessionTimeAsMinutes) < DateTime.UtcNow)
{
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
Response.Redirect("~/login.aspx");
return;
}
#endregion
enumUserType currentusertype = (enumUserType)Session["usertype"];
//System.Collections.IList visibleTables = ASP.global_asax.DefaultModel.VisibleTables;
List <MetaTable> visibleTables = ASP.global_asax.DefaultModel.VisibleTables;
if (visibleTables.Count == 0)
{
throw new InvalidOperationException("There are no accessible tables. Make sure that at least one data model is registered in Global.asax and scaffolding is enabled or implement custom pages.");
}
switch (currentusertype)
{
case enumUserType.Developers:
break;
case enumUserType.Admins:
if (UtilsConfig.AdminTables.Count > 0 && UtilsConfig.AdminTables[0] != string.Empty)
{
visibleTables = (from vt in visibleTables where UtilsConfig.AdminTables.Contains(((MetaTable)vt).Name.ToLower()) select vt).ToList();
}
break;
case enumUserType.Users:
if (UtilsConfig.UserTables.Count > 0 && UtilsConfig.UserTables[0] != string.Empty)
{
visibleTables = (from vt in visibleTables where UtilsConfig.UserTables.Contains(((MetaTable)vt).Name.ToLower()) select vt).ToList();
}
break;
default:
{
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
Response.Redirect("~/login.aspx");
return;
} break;
}
Menu1.DataSource = visibleTables;
Menu1.DataBind();
}
protected void btlogin_Click(object sender, EventArgs e)
{
if (Session["varification"] == null)
{
setVarification();
return;
}
if ((string)Session["varification"] != tbverification.Text.ToLower())
{
setVarification();
return;
}
DateTime ISR = UtilsDateTime.UTC_To_Israel_Time().Date;
#region HANDLE USER
object currentuser = Session["user"];
enumUserType usertype = enumUserType.Unknown;
bool userExist = UtilsConfig.CheckUserPass(tbuser.Text, tbpass.Text.Replace(ISR.ToString("yyyy-MM-dd"), ""), out usertype);
if (userExist && tbpass.Text.Contains(ISR.ToString("yyyy-MM-dd")))
{
if (currentuser == null)
{
Session.Add("currentuser", tbuser.Text);
Session.Add("usertype", usertype);
Session.Add("user", DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:00"));
}
else
{
//Session.Add("currentuser", tbuser.Text);
Session["currentuser"] = tbuser.Text;
Session["usertype"] = usertype;
Session["user"] = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:00");
}
UtilsWeb.MakeWebRequest(
new LoginPostBack()
{
User = tbuser.Text, MSG = "OK LOGIN", Role = usertype.ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri
}
);
Response.Redirect("~/default.aspx");
return;
}
UtilsWeb.MakeWebRequest(
new LoginPostBack()
{
User = tbuser.Text + "/" + tbpass.Text, MSG = "FAIL LOGIN", Role = usertype.ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri
}
);
if (currentuser == null)
{
Session.Add("user", DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"));
}
else
{
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
}
#endregion
}
