public List <LoginGroupModel> getLoginGroupByLogin(int loginID)
{
List <LoginGroupModel> list = new List <LoginGroupModel>();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LoginID", loginID),
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_LoginGroupByLogin", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
LoginGroupModel model = new LoginGroupModel();
model.LoginGroupID = Convert.ToInt32(row["LoginGroupID"]);
model.LoginName = row["User"].ToString();
model.GroupName = row["GroupName"].ToString();
model.LoginID = Convert.ToInt32(row["LoginID"]);
model.GroupID = Convert.ToInt32(row["GroupID"]);
list.Add(model);
}
}
}
return(list);
}
public bool postLoginGroup(LoginGroupModel _object)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LoginGroupID", _object.LoginGroupID),
new SqlParameter("@LoginID", _object.LoginID),
new SqlParameter("@GroupID", _object.GroupID),
};
return(DBHelper.ExecuteNonQuery("uspPOST_LoginGroup", CommandType.StoredProcedure, parameters));
}
protected void btnAddLoginGroup_Click(object sender, EventArgs e)
{
try
{
if (ddlGroup.SelectedValue != "0" && ddlLogin.SelectedValue != "0")
{
LoginGroupModel model = new LoginGroupModel();
model.LoginGroupID = 0;
model.LoginID = Convert.ToInt32(ddlLogin.SelectedValue);
model.GroupID = Convert.ToInt32(ddlGroup.SelectedValue);
if (btnAddLoginGroup.Text == "Save")
{
bool status = obj.postLoginGroup(model);
if (status == true)
{
Alert = AlertsClass.SuccessAdd;
}
else
{
Alert = AlertsClass.ErrorWentWrong;
}
}
if (btnAddLoginGroup.Text == "Update")
{
model.LoginGroupID = Convert.ToInt32(Session["loginGroupId"]);
bool status = obj.postLoginGroup(model);
if (status == true)
{
btnAddLoginGroup.Text = "Save";
Session.Remove("loginGroupId");
Alert = AlertsClass.SuccessUpdate;
}
else
{
Alert = AlertsClass.ErrorWentWrong;
}
}
gridBind();
ddlLogin.SelectedValue = "0";
}
else
{
Alert = AlertsClass.ErrorRequired;
}
allowStaticMethods("ALerts('" + Alert + "');staticMethod();");
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
public ActionResult Login(/*string returnUrl*/)
{
LoginViewModel LoginViewModel = new LoginViewModel();
ForgotPasswordViewModel ForgotPasswordViewModel = new ForgotPasswordViewModel();
RegisterViewModel RegisterViewModel = new RegisterViewModel();
LoginGroupModel LoginGroupModel = new LoginGroupModel();
LoginGroupModel.LoginViewModel = LoginViewModel;
LoginGroupModel.ForgotPasswordViewModel = ForgotPasswordViewModel;
LoginGroupModel.RegisterViewModel = RegisterViewModel;
//ViewBag.ReturnUrl = returnUrl;
//return View();
return(View(LoginGroupModel));
}
public LoginGroupModel GetLoginGroup(int LoginGroupId)
{
var url = "api/LoginGroup/" + LoginGroupId;
string result = SC.Getcaller(url);
if (result != null)
{
LoginGroupModel _client = JsonConvert.DeserializeObject <LoginGroupModel>(result);
return(_client);
}
else
{
return(null);
}
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
//Create DisplayName
StringBuilder dn = new StringBuilder();
dn.Append(model.FirstName + " " + model.LastName);
model.DisplayName = dn.ToString();
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email, FirstName = model.FirstName, LastName = model.LastName, DisplayName = model.DisplayName
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
//Add new use to Registered User Role to limit access
UserRolesHelper helper = new UserRolesHelper(db);
var resultadd = helper.AddUserToRole(user.Id, "Registered User");
return(RedirectToAction("RegisterSucess", "Account"));
}
AddErrors(result);
}
LoginViewModel LoginViewModel = new LoginViewModel();
ForgotPasswordViewModel ForgotPasswordViewModel = new ForgotPasswordViewModel();
RegisterViewModel RegisterViewModel = new RegisterViewModel();
LoginGroupModel LoginGroupModel = new LoginGroupModel();
LoginGroupModel.LoginViewModel = LoginViewModel;
LoginGroupModel.ForgotPasswordViewModel = ForgotPasswordViewModel;
LoginGroupModel.RegisterViewModel = model;
ViewBag.ErrorMsg = "Invalid Register Attempt, Please try again.";
// If we got this far, something failed, redisplay form
return(RedirectToAction("Login", "Account", LoginGroupModel));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
if (Session["admin"] != null)
{
ddlClientBind();
ddlConditionBind();
}
else if (Session["poweruser"] != null)
{
divClient.Visible = false;
var list = (LoginModelForUser)Session["poweruser"];
int _clId = list.ClientID;
ddlGroupbind(_clId);
ddlGroup.Visible = true;
BindingClass.ClearDropDown(ddlGroup, "Select Branch");
BindingClass.ClearDropDown(ddlObject, "Select Device");
BindingClass.ClearDropDown(ddlObjSensor, "Select Location");
ddlConditionBind();
}
else if (Session["user"] != null)
{
divClient.Visible = false;
divGroup.Visible = false;
int loginID = Convert.ToInt32(Session["user"]);
LoginGroupModel li = LGS.GetLoginGroupByLogin(loginID);
if (li != null)
{
ddlObjectbind(li.GroupID);
ddlObject.Visible = true;
BindingClass.ClearDropDown(ddlObjSensor, "Select Location");
ddlConditionBind();
}
}
else
{
Response.Redirect("Login.aspx");
}
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
}
public async Task <ActionResult> DemoLogin(LoginViewModel model)
{
LoginGroupModel LoginGroupModel = new LoginGroupModel();
LoginGroupModel.LoginViewModel = model;
ForgotPasswordViewModel ForgotPasswordViewModel = new ForgotPasswordViewModel();
RegisterViewModel RegisterViewModel = new RegisterViewModel();
LoginGroupModel.ForgotPasswordViewModel = ForgotPasswordViewModel;
LoginGroupModel.RegisterViewModel = RegisterViewModel;
if (!ModelState.IsValid)
{
ModelState.AddModelError("", "Invalid login attempt.");
return(RedirectToAction("Login", "Account"));
}
if (model.Email == "*****@*****.**" || model.Email == "*****@*****.**" || model.Email == "*****@*****.**" || model.Email == "*****@*****.**")
{
model.Password = "******";
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout : false);
switch (result)
{
case SignInStatus.Success:
//return RedirectToLocal(returnUrl);
return(RedirectToAction("Index", "Home"));
case SignInStatus.LockedOut:
return(View("Lockout"));
//case SignInStatus.RequiresVerification:
// return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
//return RedirectToLocal(returnUrl);
return(View(LoginGroupModel));
}
}
protected void linkbtnEdit_Command(object sender, CommandEventArgs e)
{
try
{
if (e.CommandName == "UpdateID")
{
allowStaticMethods("staticMethod();");
int cmdArg = Convert.ToInt32(e.CommandArgument);
LoginGroupModel list = obj.getLoginGroupByID(cmdArg);
ddlGroup.SelectedValue = list.GroupID.ToString();
ddlLogin.SelectedValue = list.LoginID.ToString();
Session["loginGroupId"] = cmdArg.ToString();
btnAddLoginGroup.Text = "Update";
}
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
if (Session["admin"] != null)
{
ddlclientbind();
ddlgroup.Visible = false;
ddlObject.Visible = false;
}
else if (Session["poweruser"] != null)
{
ddlObject.Visible = false;
var list = (LoginModelForUser)Session["poweruser"];
int _clId = list.ClientID;
ddlGroupbind(_clId);
dvcl.Visible = false;
ddlgroup.Visible = true;
}
else if (Session["user"] != null)
{
dvcl.Visible = false;
dvgp.Visible = false;
var list = (LoginModelForUser)Session["user"];
int sessionLoginID = list.LoginID;
LoginGroupModel li = LGS.GetLoginGroupByLogin(sessionLoginID);
if (li != null)
{
ddlObjectbind(li.GroupID);
ddlObject.Visible = true;
}
}
}
catch (Exception)
{
Alert = AlertsClass.ErrorWentWrong;
}
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "ALerts('" + Alert + "')", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
if (Session["admin"] != null)
{
ddlClientbind();
ddlDays.Items.Clear();
ddlgroup.Visible = false;
ddlObject.Visible = false;
}
else if (Session["poweruser"] != null)
{
divClient.Visible = false;
ddlObject.Visible = false;
var list = (LoginModelForUser)Session["poweruser"];
int _clId = list.ClientID;
ddlGroupbind(_clId);
ddlgroup.Visible = true;
}
else if (Session["user"] != null)
{
divClient.Visible = false;
divGroup.Visible = false;
int loginID = Convert.ToInt32(Session["user"]);
LoginGroupModel li = LGS.GetLoginGroupByLogin(loginID);
if (li != null)
{
ddlObjectbind(li.GroupID);
ddlObject.Visible = true;
}
}
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
}
public LoginGroupModel getLoginGroupByID(int loginGroupID)
{
LoginGroupModel model = new LoginGroupModel();
string query = "select * from [LoginGroup] where LoginGroupID = @LoginGroupID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LoginGroupID", loginGroupID),
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand(query, CommandType.Text, parameters))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
model.LoginGroupID = Convert.ToInt32(row["LoginGroupID"]);
model.LoginID = Convert.ToInt32(row["LoginID"]);
model.GroupID = Convert.ToInt32(row["GroupID"]);
}
}
return(model);
}
public LoginGroupModel GetLoginGroupByLogin(int LoginId)
{
var url = "api/LoginGroup?LoginId=" + LoginId;
string result = SC.Getcaller(url);
if (result != null)
{
if (result.Contains("["))
{
string rpl = result.Replace("[", "").Replace("]", "");
LoginGroupModel _client = JsonConvert.DeserializeObject <LoginGroupModel>(rpl);
return(_client);
}
else
{
LoginGroupModel _client = JsonConvert.DeserializeObject <LoginGroupModel>(result);
return(_client);
}
}
else
{
return(null);
}
}
public bool postLoginGroup(LoginGroupModel _object)
{
return(obj.postLoginGroup(_object));
}
