public int InsertLog(LoginSchema objLoginSchema) { login_conn = new SqlConnection(); login_conn = SQLHelper.OpenConnection(); SqlParameter[] _param = new SqlParameter[3]; try { _param[0] = new SqlParameter("@UserSessionID", SqlDbType.UniqueIdentifier); _param[0].Value = (objLoginSchema.Usersessionid); _param[1] = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier); _param[1].Value = objLoginSchema.User_id; _param[2] = new SqlParameter("@IPSecurities", SqlDbType.VarChar); _param[2].Value = Convert.ToString(objLoginSchema.IPAddress); SqlCommand command = new SqlCommand(); command.CommandText = "uspInsertUserLog"; command.CommandTimeout = 5000; command.CommandType = CommandType.StoredProcedure; int result = HelperCls.ExecuteNonQuery(login_conn, null, CommandType.StoredProcedure, command.CommandText, _param); return(result); } catch (Exception Ex) { throw Ex; } finally { login_conn.Close(); login_conn.Dispose(); } }
public int UpdateUserPassword(LoginSchema objLoginSchema) { login_conn = new SqlConnection(); login_conn = SQLHelper.OpenConnection(); SqlParameter[] _param = new SqlParameter[2]; try { _param[0] = new SqlParameter("@UserName", SqlDbType.VarChar); _param[0].Value = (objLoginSchema.UserName); _param[1] = new SqlParameter("@Password", SqlDbType.VarChar); _param[1].Value = Convert.ToString(objLoginSchema.Password); SqlCommand command = new SqlCommand(); command.CommandText = "uspUpdateUserPassword"; command.CommandTimeout = 5000; command.CommandType = CommandType.StoredProcedure; int result = HelperCls.ExecuteNonQuery(login_conn, null, CommandType.StoredProcedure, command.CommandText, _param); return(result); } catch (Exception Ex) { throw Ex; } finally { login_conn.Close(); login_conn.Dispose(); } }
// Added by Anand Dated on 07-08-2018 public int ChangePwd(LoginSchema objLoginSchema) { login_conn = new SqlConnection(); login_conn = SQLHelper.OpenConnection(); SqlParameter[] _param = new SqlParameter[4]; try { _param[0] = new SqlParameter("@UserID", SqlDbType.VarChar); _param[0].Value = (objLoginSchema.UserID); _param[1] = new SqlParameter("@CurrentPassword", SqlDbType.VarChar); _param[1].Value = objLoginSchema.ChangedPassword; _param[2] = new SqlParameter("@Newpassword", SqlDbType.VarChar); _param[2].Value = objLoginSchema.ConfirmPassword; _param[3] = new SqlParameter("@Seed", SqlDbType.VarChar); _param[3].Value = objLoginSchema.SessionID; SqlCommand command = new SqlCommand(); command.CommandText = "uspChangePassword"; command.CommandTimeout = 5000; command.CommandType = CommandType.StoredProcedure; int result = HelperCls.ExecuteNonQuery(login_conn, null, CommandType.StoredProcedure, command.CommandText, _param); return(result); } catch (Exception Ex) { throw Ex; } finally { login_conn.Close(); login_conn.Dispose(); } }
public int insertSession(LoginSchema objLoginSchema) { try { login_conn = new SqlConnection(); login_conn = HelperCls.OpenConnection(); objTran = login_conn.BeginTransaction(); string user_names = "insert into UserSession ([UserID],[SessionID],[LoggedInAt],[LoggedFrom]) values(CAST('" + objLoginSchema.UserID + "'as uniqueidentifier),'" + objLoginSchema.SessionID + "',GetDate(),'" + objLoginSchema.IPAddress + "')"; returnval = HelperCls.ExecuteNonQuery(login_conn, objTran, CommandType.Text, user_names); return(returnval); } catch (Exception e) { return(0); } finally { objTran.Commit(); HelperCls.CloseConnection(login_conn); returnval = 0; } }
public int ForceChangePasswordDAL(LoginSchema objLoginSchmema) { try { login_conn = new SqlConnection(); login_conn = HelperCls.OpenConnection(); objTran = login_conn.BeginTransaction(); string user_names = "update UserMaster set Password='******',PasswordChanged='1' where UserID='" + objLoginSchmema.UserID + "' COLLATE SQL_Latin1_General_CP1_CS_AS"; returnval = HelperCls.ExecuteNonQuery(login_conn, objTran, CommandType.Text, user_names); return(returnval); } catch (Exception e) { return(0); } finally { objTran.Commit(); HelperCls.CloseConnection(login_conn); returnval = 0; } }
public int LogoutSession(string str) { try { login_conn = new SqlConnection(); login_conn = HelperCls.OpenConnection(); objTran = login_conn.BeginTransaction(); string user_names = "update UserSession set LoggedOutAt=GetDate() where SessionID='" + str + "'"; returnval = HelperCls.ExecuteNonQuery(login_conn, objTran, CommandType.Text, user_names); return(returnval); } catch (Exception e) { return(0); } finally { objTran.Commit(); HelperCls.CloseConnection(login_conn); returnval = 0; } }
public int ChangeResetPasswordSVT(LoginSchema objLoginSchema) { try { ds = new DataSet(); login_conn = new SqlConnection(); login_conn = HelperCls.OpenConnection(); StringBuilder var1 = new StringBuilder(); SqlParameter[] _param = new SqlParameter[3]; _param[0] = new SqlParameter("@EmailID", SqlDbType.VarChar); _param[0].Value = objLoginSchema.EmailId1; _param[1] = new SqlParameter("@Password", SqlDbType.VarChar); _param[1].Value = objLoginSchema.Password; _param[2] = new SqlParameter("@ForgetPasswordToken", SqlDbType.VarChar); _param[2].Value = objLoginSchema.ForgotPasswordToken; SqlCommand command = new SqlCommand(); command.CommandText = "Proc_AdminUserRegistration"; command.CommandTimeout = 5000; command.CommandType = CommandType.StoredProcedure; int result = HelperCls.ExecuteNonQuery(login_conn, null, CommandType.StoredProcedure, command.CommandText, _param); return(result); } catch (Exception ex) { throw ex; } finally { login_conn.Close(); login_conn.Dispose(); } }
public int IncreaseAttemptCount(LoginSchema objLoginSchema) { login_conn = new SqlConnection(); login_conn = HelperCls.OpenConnection(); SqlParameter[] _param = new SqlParameter[2]; try { //_param[0] = new SqlParameter("@UserID", SqlDbType.VarChar); //_param[0].Value = Convert.ToString(objLoginSchema.UserID); _param[0] = new SqlParameter("@QueryNo", SqlDbType.Int); _param[0].Value = (objLoginSchema.QueryNo); _param[1] = new SqlParameter("@UserName", SqlDbType.VarChar); _param[1].Value = Convert.ToString(objLoginSchema.UserName); _param[1].Size = 50; SqlCommand command = new SqlCommand(); command.CommandText = "SP_GetLogin"; command.CommandTimeout = 5000; command.CommandType = CommandType.StoredProcedure; int result = HelperCls.ExecuteNonQuery(login_conn, null, CommandType.StoredProcedure, command.CommandText, _param); return(result); } catch (Exception Ex) { throw Ex; } finally { login_conn.Close(); login_conn.Dispose(); } }