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();
}
}
